EMS logo

Products Navigation

SQL Manager for Oracle

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS SQL Manager for Oracle

On-line Documentation

Last Analyze Stats


The Last Analyze Stats tab displays the objects (tables and indexes) and the date when these objects were last analyzed (i.e. when statistics was last gathered).

 

Hint: Statistics for tables/indexes can be gathered with the help of Advanced Statistics Wizard.

 

Database Statistics - Last Analyze Stats

 

The list displays the objects as a grid with the following columns: Owner, Name, Last Analyzed. If more convenient, you can change the order of the columns by dragging their headers horizontally.

 

If necessary, you can group the data in grid by any of the columns. This operation is performed by dragging the column header to the gray "Group by" box area at the top. When grouping by a column is applied to the grid, all the rows are displayed as subnodes to the grouping row value. To reverse grouping, just drag the column header back.

 

Click a column caption to sort items by values of this column in the ascending or the descending mode.

 

In order to filter items in grid, you can use Custom Filter and Filter Builder dialog. For more information refer to the Filtering records page.

 


See also:

System Statistics

Sessions

Storage

SGA

Wait Events

Latches

Database Alerts