Slow performance with Oracle accessing the data dictionary
If you're having some performance issues accessing the data dictionary on common tasks like create user, create synonyms, etc. It might be a problem with the statistics.
We're not supposed to "re gathered" the statistics with Oracle 10G but sometimes there's no other choices.
- First, remove the statistics:
execute dbms_stats.delete_schema_stats('SYS'); - Then recreate them:
execute dbms_stats.gather_schema_stats('SYS');
www.CInformatique.com
No comments:
Post a Comment