Collecting statistics from User Tables is simple, just use dbms_utility.analyze_schema, but can (and can) do this for the Oracle Metadata tables?
This post , was the source of this doubt.
How to collect statistics in Oracle Metadata tables?
3
asked by anonymous 06.06.2014 / 23:28
1 answer
1
According to my comment, in current versions of Oracle (> = 10g), the statistics analysis functions for the optimizer are done with the DBMS_STATS", in general however these statistics are not the problem; Oracle has several automatic jobs to collect statistics on a regular basis (see documentation on statistics management for the optimizer ).
Anyway, you can still trigger analysis of a schema manually with the procedure DBMS_STATS.GATHER_SCHEMA_STATS .
Regarding the system dictionary, there is still the procedure DBMS_STATS.GATHER_DICTIONARY_STATS .
15.06.2014 / 19:08