Friday, July 20, 2007

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');

No comments: