Re: Querying v$ tables very slow after upgrade

On 6/26/07, Ian Cary <Ian.Cary_at_ons.gsi.gov.uk> wrote:
>
>
> There is a patch 5029334 which includes a script catspace.sql to rebuild a
> number of the space views ( e.g. *_SEGMENTS , *_EXTENTS) It sounds as if
> your problem is a bit more widespread but it may help.
> The bug affects 10.2.0.1 , 10.2.0.2 and 10.2.0.3 and the patch certainly
> improved the perfomance on DBA_EXTENTS on the 10.2.0.2 database I'm using.
>
>

While ML note *422730.1* claims that this affects 10.2.0.3 as well, the patch will
not install on 10.2.0.2, claiming that 10.2.0.2 is required.

There is a difference in catspace.sql in 10.2.0.3 when compared to the patch,
but the performance of DBA_EXTENTS on 10.2.0.3 seems acceptable.

Don't know about 10.2.0.1.

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--
http://www.freelists.org/webpage/oracle-l