Database Tuning (MOSC)

MOSC Banner

ADDM Report Feedback required

edited Apr 14, 2010 6:09PM in Database Tuning (MOSC) 2 commentsAnswered
Hi All,

I have get the below response from the ADDM report. Looking for experts how i can resolve this issue.

Thanks in advance.... 

Finding 6: Commits and Rollbacks

Impact is .02 active sessions, 14.74% of total activity.

--------------------------------------------------------

Waits on event "log file sync" while performing COMMIT and ROLLBACK operations

were consuming significant database time.

Waits on event "log file sync" were the cause of significant database wait on

"gc buffer busy release" when releasing a data block.

Recommendation 1: Host Configuration

Estimated benefit is .02 active sessions, 14.74% of total activity.

-------------------------------------------------------------------

Action

Investigate the possibility of improving the performance of I/O to the

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