Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> extents for segments for sys/system user>4. Please Help
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
Received on Fri Jul 23 1999 - 05:56:11 CDT