Re: extents for segments for sys/system user>4. Please Help

Anurag

Unless the number of extents is in the hundreds, I wouldn't worry about it. There's an old myth that multiple extents is a performance problem, but that's all it is - a myth.

HTH. Pete

Anurag Minocha wrote:

> Hi,
>
> when i run the following query i get a lot of segment names whose
> extents are greater than 4. What should i do. Is this a problem or
> not, and how should i fix it
>
> select substr(segment_name,1,25)"SEGMENT
> NAME",extents,next_extent,bytes,
> 2 segment_type from sys.dba_segments where extents>4 and owner in
> 3 ('SYS','SYSTEM');
>
> Thanks
> anurag
>
> reply at
> anurag_at_synergy-infotech.com

--
Regards

Pete

Received on Fri Jul 23 1999 - 11:17:32 CDT