Insufficient storage of the table data
Date: 28 Jul 2003 13:38:14 -0700
Message-ID: <3fa1b346.0307281238.44f2223d_at_posting.google.com>
[Quoted] To all DBA experts,
Recently, I did a query on the DBA_SEGMENTS for a specific table and the result showing that 588 extents for that table. The retired DBA told me that it's a major concern because it should not pass the recomments extents (which is 20).
I was looking for any kind of documents that talks about this but I am out of luck. All I can find is pros and cons between large and small extents.
Would someone out there help me with this? Would a table with 588
extents
be a big concern? Where can find that information?
This is the query that I used:
> SELECT * from dba_segments where segment_name='HARVERSIONDATA'
SUBSTR(SEGMENT_NAM SUBSTR(TABL BYTES BLOCKS EXTENTS INITIAL_EXTENT NEXT_EXTENT PCT_INCREASE
------------------ ----------- --------- --------- --------- -------------- ----------- ------------ HARVERSIONDATA HARVESTBLOB 18477056 4511 588 11255808 12288 0
Thanks in advance. Received on Mon Jul 28 2003 - 22:38:14 CEST