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