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