Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Very Large Next Extent

Very Large Next Extent

From: Tapan Trivedi <tapan.trivedi_at_abbnm.com>
Date: Wed, 29 Sep 1999 17:30:56 -0500
Message-ID: <37F29320.F337F23D@abbnm.com>


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            0

Received on Wed Sep 29 1999 - 17:30:56 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US