Database Tuning (MOSC)

MOSC Banner

Help analyze ADDM report

edited Aug 15, 2017 4:20PM in Database Tuning (MOSC) 16 commentsAnswered

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".

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center