Insufficient storage of the table data

From: tcny2k <tcny2k_at_yahoo.com>
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

Original text of this message