How to collect statistics in Oracle Metadata tables ?

Asked

Viewed 633 times

3

Collecting statistics from User Tables is simple, just use the dbms_utility.analyze_schema, but you can (and can) do this for the Oracle Metadata tables ?

This post, was the origin of this doubt.

database oracle

  • Putz, I won the Tumbleweed (great name!!) for this question !!

  • Dude, it’s not the answer you’re looking for, but just like to point out that from Oracle 10g to Procedure analyze_schema is no longer recommended. You should use DBMS_STATS.GATHER_SCHEMA_STATS if you want to do it on the nail.

  • 1

    http://docs.oracle.com/cd/E16655_01/appdev.121/e17602/d_stats.htm#i1055451 seems to be the answer, I will test later.

  • Beauty, I wrote an answer for registration purposes (although I don’t think it should help much the OP of the other question... Unless he disabled the Autotask Oracle does a good job of keeping statistics up to date).

1 answer

1


As my comment, in current versions of Oracle (>= 10g), the statistical analysis functions for the optimizer are done with the package DBMS_STATS, in general but these statistics are not the problem; Oracle has several Jobs to collect statistics regularly (see documentation on statistics management for the optimizer).

Anyway, you can still trigger the analysis of a schema manually with the Procedure DBMS_STATS.GATHER_SCHEMA_STATS.

Regarding the dictionary of the system, there is still the Procedure DBMS_STATS.GATHER_DICTIONARY_STATS.

Browser other questions tagged database oracle

You are not signed in. Login or sign up in order to post.