Database Tuning (MOSC)

MOSC Banner

I/O contention on 10g database - windows server

edited Apr 7, 2016 5:03AM in Database Tuning (MOSC) 12 commentsAnswered

Hello Everyone

I have an ongoing performance issue on a 10.2.0.5 database hosted on Windows 2008 server.

Physical memory utilisation on the db server is quite high at 90%.

I have attached the ADDM report as well.  Messages in this related to hard parsing and invalid cursors could be due to flush shared_pool which I did.

Requesting help from Performance Tuning experts.

EventWaitsTime(s)Avg Wait(ms)% Total Call TimeWait Class
CPU time1,65173.3
db file sequential read149,021456320.2User I/O
direct path read51,2784812.1User I/O
log file parallel write13,9074632.1System I/O
log file sync8,3454552.0Commit

Wait Class

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