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 , and and the patch certainly
improved the perfomance on DBA_EXTENTS on the database I'm using.

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

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

Don't know about

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

Other related posts: