Database Tuning (MOSC)

MOSC Banner

Need further interpretation on ADDM Report

edited Jan 17, 2012 8:11AM in Database Tuning (MOSC) 4 commentsAnswered
Hi,

We have a 10.2.0.3 DB and our Radius Application team is complaining on the slow response of the database during inserts and update..
I checked the ADDM Report and found the following findings ... can someone help me interpret this recommendations, actions and rationale .

FINDING 1: 67% impact (340 seconds)
-----------------------------------
Waits on event "log file sync" while performing COMMIT and ROLLBACK operations
were consuming significant database time.

   RECOMMENDATION 1: Application Analysis, 67% benefit (340 seconds)
      ACTION: Investigate application logic for possible reduction in the
         number of COMMIT operations by increasing the size of transactions.
      RATIONALE: The application was performing 508 transactions per minute
         with an average redo size of 1268 bytes per transaction.

   RECOMMENDATION 2: Host

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