Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Very Large Next Extent
Hey Guys,
I ran the following query on one of my instances and I got the following
results. I have a table with a next extent of 52428800 which is really
very big. What do I do about this as export/import is not an option for
this table (9 million rows ) and always being written to and other
application constraints. Any hints , suggestions, experiences, comments
welcome.
Thank you. Tapan H Trivedi
select
SEGMENT_NAME,SEGMENT_TYPE,BYTES,BLOCKS,EXTENTS,INITIAL_EXTENT,NEXT_EXTENT,MAX_EXTENTS,PCT_INCREASE
from dba_segments
where extents > 20
order by extents desc;
SEGMENT_NAME SEGMENT_TYPE BYTES BLOCKS EXTENTS INITIAL_EXTENT NEXT_EXTENT MAX_EXTENTS PCT_INCREASE --------------------------------------------------------------------------------------------------------------------------- SYS_C0026295 INDEX 172134400 84050 82 2097152 2097152 121 0 ESDATA TABLE 195174400 95300 69 2097152 52428800 121 0 EVTMSG 100771840 49205 49 10240 2099200 121 0 EVTAUG 73482240 35880 36 10240 2097152 121 0 EVTJUL 56688640 27680 28 10240 2097152 121 0Received on Wed Sep 29 1999 - 17:30:56 CDT
![]() |
![]() |