Help analyze ADDM report
I am trying to figure out a plan of attack on a performance issue, but was not successful. I hope experts here can advise. First I apologize the the long post. The database is 12.1.0.2. Below are the findings.
Top ADDM findings:
Description Active Sessions Recommendations
Percent of Activity
------------------------------- ------------------- ---------------
1 Top SQL Statements 3.71 | 62.81 5
2 Soft Parse 3.33 | 56.32 2
3 Shared Pool Latches 3.32 | 56.23 1
1. For most of the top SQL, there was a common reason:
Rationale
Database time for this SQL was divided as follows: 0% for SQL execution,
100% for parsing, 0% for PL/SQL execution and 0% for Java execution.
2. For Soft parse
Action
Consider increasing the session cursor cache size by increasing the value of parameter "session_cached_cursors".