Cursors in oracle for updating all records examples
Analyze normal data dictionary objects (not fixed dictionary objects) using the same interval that you currently use when analyzing other objects.
The Rule Based Optimizer (RBO) is desupported with 10g.
Oracle 10g also offers two new procedures in the dbms_stats package.
First, the This example gathers statistics from the SYS and SYSTEM schemas as well as any other schemas that are related to RDBMS components (e.g., OUTLN or DBSNMP).
Here is an example of the use of the gather_fixed argument within the dbms_stats.gather_schema_stats procedure: .
These allow you to export and import statistics to user-defined statistics tables, just as you could with normal table statistics previously.