Question regarding Interpreting ADDM Report finding
Below is excerpt of of an ADDM report that I ran against one of our Oracle E-Business Suite instances. I have a question regarding how do I intrepret the first finding.
The way I read it is that .57 active session (less than 1%) of the total sessions during the period of time encompassed by this report that 100% of these sessions activity could benifit from this tuning suggestion. in other words less than 1% of the active sessions 100% of the activity of that session could benifit from this tuning.
Am I interpreting this correctly? I want to make sure I'm interpreting what the ADDM Reports are saying accurately. Any advise would be greatly appreciated. I have similar information being report by ADDM for larger periods of time and just want to know what the report numbers are really saying to me.
Thanks
---------------------------------------------------------------------------------------------------------
ADDM Report for Task 'TASK_47980'
---------------------------------
Analysis Period
---------------
AWR snapshot range from 17861 to 17903.
Time period starts at 23-MAY-11 12.59.50 AM
Time period ends at 26-MAY-11 01.00.15 PM
Analysis Target
---------------
Database 'ORI97' with DB ID 2512236993.
Database version 11.1.0.7.0.
ADDM performed an analysis of instance ori97, numbered 1 and hosted at
unitrin1.
Activity During the Analysis Period
-----------------------------------
Total database time was 171512 seconds.
The average number of active sessions was .57.
Summary of Findings
-------------------
Description Active Sessions Recommendations
Percent of Activity
------------------- ------------------- ---------------
1 I/O Throughput .57 | 100 1
2 Top Segments by I/O .24 | 42.04 5
3 Top SQL by DB Time .17 | 30.18 5
4 RMAN I/O .14 | 25.27 1
5 CPU Usage .08 | 14.97 1
6 Undersized SGA .08 | 14.93 1
7 Top SQL By I/O .04 | 7.47 3
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Findings and Recommendations
----------------------------
Finding 1: I/O Throughput
Impact is .57 active sessions, 100% of total activity.
------------------------------------------------------
The throughput of the I/O subsystem was significantly lower than expected.
Recommendation 1: Host Configuration
Estimated benefit is .57 active sessions, 100% of total activity.
-----------------------------------------------------------------
Action
Consider increasing the throughput of the I/O subsystem. Oracle's
recommended solution is to stripe all data file using the SAME
methodology. You might also need to increase the number of disks for
better performance. Alternatively, consider using Oracle's Automatic
Storage Management solution.
Rationale
During the analysis period, the average data files' I/O throughput was
2.8 M per second for reads and 10 K per second for writes. The average
response time for single block reads was 1.8 milliseconds.
Symptoms That Led to the Finding:
---------------------------------
Wait class "User I/O" was consuming significant database time.
Impact is .34 active sessions, 60.17% of total activity.