get_dbsize

get_dbsize_info

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

daiesy@hotmail.com - 10 Jan 2006 19:54 GMT

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

Reply to this Message

Gert van der Kooij - 10 Jan 2006 20:06 GMT

> 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
[quoted text clipped - 6 lines]
> Thanks,
> Ember

Maybe logfiles are also counted?

Reply to this Message

Pierre Saint-Jacques - 10 Jan 2006 23:20 GMT

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.

Signature

Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515

>> 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
[quoted text clipped - 8 lines]
>
> Maybe logfiles are also counted?

Reply to this Message

daiesy@hotmail.com - 11 Jan 2006 03:44 GMT

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

Reply to this Message

Pierre Saint-Jacques - 11 Jan 2006 22:11 GMT

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.

Signature

Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515

>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
[quoted text clipped - 3 lines]
>
> Ember

Reply to this Message