Displaying the Oracle Table Statistics

If you use Oracle with the cost-based Optimizer, you should create statistics for the database tables on a regular basis. You should analyze tables using BR*Tools and schedule them in the CCMS DBA scheduling calendar (transaction code DB13). Ensure regularly that tables or indexes were correctly analyzed.

To display data from the last table analysis:

1. From the main screen, choose Administration → Control/Monitoring → Performance Menu → Database → Tables / Indexes.

   Alternatively, enter transaction code DB02.

2. Choose Checks.
3. In Cost based optimizer, choose Dates of table analysis.

   The initial screen shows the following data:

   • The init<SID>.ora parameter optimizer_mode. Possible values are:

     SELECT: The cost-based optimizer is active.

     RULE: The rule-based optimizer is active.

   • Data from the last table analysis of BRCONNECT. You can use the function DBA Operations Log to display directly the corresponding logs.
   • Statistics on how many tables were analyzed and at what time.

The function All tables displays detailed information about the last table analysis. For each database table the system displays the date of the last analysis (dba_tab_coumns.last_analyzed), the number of lines in a table as determined by the last analysis (dba_tables.num_rows), as well as the sample size used to determine the last statistics (dba_tab_coumns.sample_size/dba_tables.num_rows).

For more information, see Database Statistics with BR*Tools and your Oracle documentation.

See also:

Monitoring the Shared Pool (Oracle)