Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> DBA_SEGMENTS and Full scan
Hi
Actually a single request on the Dba_segments have 7 Full_scan on SYS.TAB$, SYS.TABPARTS$, SYS.CLU$ ... . Is there a way to contourn this problem ?
SELECT SUM(bytes)/1024/1024
FROM DBA_SEGMENTS
WHERE tablespace_name = 'TBDATA001'
AND segment_type = 'TABLE'
/
Oracle version is 9.2.0.6
O.S. AIX 5.3
Received on Fri Jun 16 2006 - 04:24:19 CDT