Description of the illustration addm_report_pg1

The screenshot shows the Automatic Database Diagnostic Monitor (ADDM) page. At the top of the page on the right-hand side is the refresh date, Jun 29, 2007 7:24:39 PM PDT, followed by a Refresh button,

The first section on this page is the Database Activity section. This section contains a chart that graphs the number of active sessions over time. The time values range from 5:43 to 7:20, in 10 minute increments. There are three types of activity shown in the chart: Waits, User I/O, and CPU. In the chart, only Wait has a value above zero.

The next section on the page is the ADDM Performance Analysis. At the top of this section, under the title, is the Task Name, which is ADDM:499723071_8 in this image. On the right-hand side of the page are 3 buttons: Filters, View Snapshots, and View Report. Information about the task is then displayed. The information shown in this screenshot is:

Task Owner: SYS
Average Active Sessions: 0.7
Period Start Time: Jun 29, 2007 11:48:20 AM PDT
Period Duration (minutes): 11.8
Instance: sales.example.com

Next is the chart of ADDM Findings. There are 2 findings in this table. They are:

Top SQL by DB Time, with an impact of 87.4 percent, occurring in 2 out of 7 snapshots taken in the last 24 hours
Row Lock Waits, with an impact of 87.2 percent, affecting 1 of 2 instances, and occurring in 2 out of 7 snapshots collected in the last 24 hours

The next section on the page is the Informational Findings section. This is a list of findings, which is not expanded in this screenshot.

The next section displayed is the Affected Instances section, which contains a table of the available instances, the percentage to which each instance is affected, and the status of that instance. In this screenshot, the following information is displayed:

Instance sales.example.com_sales1 has a 96.4 percent impact and a status of Analyzed
Instance sales.example.com_sales2 has a 3.6 percent impact and a status of Analyzed

End of description.