Hi.
I'm running Oracle 10g on windows 2003.
Which is more trustworthy - the command line or Enterprise Manager?
Enterprise Manager has recommended that i shrink various indexes and tables. It makes the same recommendations even after i have shrunk all the objects it suggests.
I couldn't see a way from within OEM of finding the size of anything. So I ran a select statement on the command line querying the dba_segments table so that i could see what sizes the indexes and tables were so i could monitor if Enterprise Manager segment advisor was really doing anything.
The sizes of tables and indexes reported by segment advisor are completely different from the sizes reported in my select statement.
e.g. a table segment advisor claims to be 110MB with 50MB reclaimable space is reported as 2MB in my select statement!
So i'm wondering if there is a definitive way of getting the size of an oracle object? Whether it's a good idea to trust segment advisor or maybe i should just ignore its recommendations? And if there is a way (either via OEM or the command line) to see that a shrink job has really done anything?
thanks.
ps. this was select statement i used:
SQL> SELECT tablespace_name, segment_name, segment_type, bytes, blocks, extents FROM dba_segments WHERE tablespace_name = 'PRODUCTION';
I'm running Oracle 10g on windows 2003.
Which is more trustworthy - the command line or Enterprise Manager?
Enterprise Manager has recommended that i shrink various indexes and tables. It makes the same recommendations even after i have shrunk all the objects it suggests.
I couldn't see a way from within OEM of finding the size of anything. So I ran a select statement on the command line querying the dba_segments table so that i could see what sizes the indexes and tables were so i could monitor if Enterprise Manager segment advisor was really doing anything.
The sizes of tables and indexes reported by segment advisor are completely different from the sizes reported in my select statement.
e.g. a table segment advisor claims to be 110MB with 50MB reclaimable space is reported as 2MB in my select statement!
So i'm wondering if there is a definitive way of getting the size of an oracle object? Whether it's a good idea to trust segment advisor or maybe i should just ignore its recommendations? And if there is a way (either via OEM or the command line) to see that a shrink job has really done anything?
thanks.
ps. this was select statement i used:
SQL> SELECT tablespace_name, segment_name, segment_type, bytes, blocks, extents FROM dba_segments WHERE tablespace_name = 'PRODUCTION';