469,949 Members | 2,212 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,949 developers. It's quick & easy.

get_dbsize_info

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

Jan 10 '06 #1
4 2904
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?
Jan 10 '06 #2
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?


Jan 10 '06 #3
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

Jan 11 '06 #4
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


Jan 11 '06 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Erik Hendrix | last post: by
6 posts views Thread by kaming | last post: by
5 posts views Thread by DeeBee2 | last post: by
2 posts views Thread by Anonymous Sender | last post: by
1 post views Thread by jerry8huang | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.