get_dbsize_info

[daiesy]

I'm playing with scripts to gather database size and count information
- can anyone tell me what the capacity output of the get_dbsize_info
procedure includes? It's about 25% larger than the number I get adding
up allocated pages (multiplied by page size, of course), and even if I
include free space in filesystems where temp and data sms tablespaces
reside and the instance home filesystem, I'm still about 10% short. Any
insight?

Thanks,
Ember

[Gert van der Kooij]

In article <11**********************@o13g2000cwo.googlegroups .com>,
(da****@hotmail.com) says...

I'm playing with scripts to gather database size and count information
- can anyone tell me what the capacity output of the get_dbsize_info
procedure includes? It's about 25% larger than the number I get adding
up allocated pages (multiplied by page size, of course), and even if I
include free space in filesystems where temp and data sms tablespaces
reside and the instance home filesystem, I'm still about 10% short. Any
insight?

Thanks,
Ember

Maybe logfiles are also counted?

[Pierre Saint-Jacques]

Would this not show LOBs space used.
Catalog tables used LOB columns for a lot of reasons and their space does
NOT show in pages allocated per table for SMS. All your catalog tables are
in SMS table spaces by default.
HTH, Pierre.

--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
"Gert van der Kooij" <ge**@invalid.nl> a écrit dans le message de news:
MP************************@news.xs4all.nl...

In article <11**********************@o13g2000cwo.googlegroups .com>,
(da****@hotmail.com) says...

I'm playing with scripts to gather database size and count information
- can anyone tell me what the capacity output of the get_dbsize_info
procedure includes? It's about 25% larger than the number I get adding
up allocated pages (multiplied by page size, of course), and even if I
include free space in filesystems where temp and data sms tablespaces
reside and the instance home filesystem, I'm still about 10% short. Any
insight?

Thanks,
Ember

Maybe logfiles are also counted?

[daiesy]

I think it must be the logs - the math works out right for it. I didn't
think that made sense, so I hadn't added it in. Thanks! Thanks for the
idea on LOBs, but the only LOBs in this database are in the catalog
tables, and the database is around 200GB, so catalog LOBs wouldn't make
much of a difference.

Ember

[Pierre Saint-Jacques]

Indeed, and thanks for pointing (finding) out that the oputput includes the
logs.
I hadn't thought of that.
One thing though, do the logs get included because their default log path is
a subdirectory of the database path or is the get_dbsize command smart
enough to figure out the current log path wherever that may be. I think the
latter but I'm not sure. I guess I'd have to test if I had the time!!
HTH, Pierre.

--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
<da****@hotmail.com> a écrit dans le message de news:
11**********************@g14g2000cwa.googlegroups. com...

I think it must be the logs - the math works out right for it. I didn't
think that made sense, so I hadn't added it in. Thanks! Thanks for the
idea on LOBs, but the only LOBs in this database are in the catalog
tables, and the database is around 200GB, so catalog LOBs wouldn't make
much of a difference.

Ember