Need further interpretation on ADDM Report
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 .
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 0