Use the Activity Monitor to monitor application performance and concurrency, resource consumption, and SQL statement usage of a database or database partition.
The Activity Monitor provides a set of predefined reports based on a specific subset of monitor data. These reports allow you to focus monitoring on application performance, application concurrency, resource consumption, and SQL statement use. The Activity Monitor also provides recommendations for most reports. These recommendations can assist you to diagnose the cause of database performance problems, and to tune queries for optimal utilization of database resources.
Tasks from the Activity Monitor | Aspects of tasks | Invocation |
---|---|---|
Transactions | View transactions running on a selected application. | Select one or more applications in the Report data pane. Right-click and select Show Latest Transactions . The Application Transactions window opens. |
Statements | View SQL statements running on a selected application. | Select one or more applications in the Report data pane. Right-click and select Show Latest Statements. The Application Statements window opens. |
View the text of SQL statements running on a selected application. | From the Application Statements window, right-click on a statement in the Report data pane. Select Show Statement Text | |
Application Lock Chains | View locks and lock-waiting situations that currently affect a selected application. | Select an application in the Report data pane. Right-click and select Show Lock Chains. The Application Lock Chains window opens. |
View information about a selected application for which you are viewing lock information. | From the Application Lock Chains window, right-click an application, and select About. | |
View information about the locks held and the locks waited on by a selected application in your database. | From the Application Lock Chains window, right-click an application, and select Show Lock Details. | |
View report data and recommendations | View information to help you interpret report data. | From an Activity Monitor window, an Application Statements window, or an Application Transactions window, use the Report arrow to select the report and click the Report Details push button. View the Details page. |
View recommendations provided by Activity Monitor | From an Activity Monitor window, an Application Statements window, or an Application Transactions window, use the Report arrow to select the report and click the Report Details push button. View the Recommendations page. |
The Report data pane also provides access to other Activity Monitor windows. From the Activity Monitor, you can drill down from the applications you are monitoring to the individual transactions or to the individual SQL statements that these applications are running.