Re: DBA_SEGMENTS and Full scan

From: Guitarator <d.jeanneret_at_wanadoo.fr>
Date: 16 Jun 2006 07:58:47 -0700
Message-ID: <1150469926.964506.28650@y41g2000cwy.googlegroups.com>

It's just for optimize my tools. This tools looks for all my databases and the total time for 100 databases is about five minutes. you're right, it's not a real problem. Just for start to optimize it or take another way.

cu
Denis

Mark D Powell wrote:
> 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
>
> Why do you consider this a problem? On my 9.2.0.6 system running on
> AIX 5.2 the response for you query on a 8G tablespace was 2.4 seconds.
>
> Both TAB$ and CLU$ are stored in the same cluster so reading one of
> them will fetch the physical blocks for the other into memory if not
> alreay present.
>
> HTH -- Mark D Powell --
Received on Fri Jun 16 2006 - 09:58:47 CDT