Re: Oracle System Tables - Performance SUX

There are none.
One common source for performance problems is ANALYZEing the data dictionary. You shouldn't do that.
The dictionary has been designed using the rule-based optimizer. Try deleting the statistics (it won't harm when they are not there) by issuing dbms_utility.analyze_schema('SYS','DELETE')

Hth,

Sybrand Bakker, Oracle DBA

"Walter Dorninger" <walter.dorninger_at_aon.at> wrote in message news:8jfrut$1rn4$1_at_wrath.news.nacamar.de...
> Hi,
>
> When I access the data dictionary (system tabels) of my oracle database it
> seems to be very (!) slow. Does anyone know how if there are some settings
> to increase the performance of the data dictionary access ?
>
> I already placed the system datafile on a separate disk but the
 performance
> still sucks. There is also enough memory ... - so I don't have an idea.
>
> any suggestions ?
> Thanks
> Walter
>
>
Received on Thu Jun 29 2000 - 00:00:00 CDT