Re: Querying v$ tables very slow after upgrade

  • From: "Jared Still" <jkstill@xxxxxxxxx>
  • To: Ian.Cary@xxxxxxxxxxxxxx
  • Date: Tue, 26 Jun 2007 09:13:57 -0700

On 6/26/07, Ian Cary <Ian.Cary@xxxxxxxxxxxxxx> 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

Other related posts: