Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: DBA_SEGMENTS and Full scan
Guitarator wrote:
> 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
What problem is this causing you?
Received on Fri Jun 16 2006 - 08:43:29 CDT