| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Very Large Next Extent
Alter it before it happens ?
"alter table...(etc)"
or has it already happened ?
check out the existing extent sizes
Regards
Glenn Baron
Tapan Trivedi <tapan.trivedi_at_abbnm.com> wrote in article
<37F29320.F337F23D_at_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,MA
X_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
>
 |
 |