Database Tuning (MOSC)

MOSC Banner

How to diagnose findings in ADDM report....

edited Sep 10, 2014 5:08AM in Database Tuning (MOSC) 8 commentsAnswered ✓
Hi There,
I need the assistance regarding findings in ADDM mean how diagnose it. Below are some finding in my ADDM report.

 
Finding 5: Hard Parse Due to Invalidations
Impact is .07 active sessions, 4.41% of total activity.
-------------------------------------------------------
Cursors were getting invalidated due to DDL operations. This resulted in
additional hard parses which were consuming significant database time.
 
   Recommendation 1: Application Analysis
   Estimated benefit is .07 active sessions, 4.41% of total activity.
   ------------------------------------------------------------------
   Action
      Investigate appropriateness of DDL operations.
 
   Symptoms That Led to the Finding:
   ---------------------------------
      Hard parsing of SQL statements was consuming significant database time.
      Impact is .29 active sessions, 18.36% of total activity.
 
 
Finding 6: Hard Parse Due to Sharing Criteria

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