Home » RDBMS Server » Performance Tuning » Top wait events (Oracle ,11.2.0.3.0 , Solaris 10 sparc 64 bit)
Top wait events [message #588249] Mon, 24 June 2013 04:29 Go to next message
zeeshan047
Messages: 60
Registered: June 2010
Location: PAKISTAN
Member


hi,

We are using 11.2.0.3.0 on solaris 10 facing slow performance, following are the Wait Events in AWR report, need assistance to overcome it. Also if any specific document to analyze AWR report and to pin point the performance bottleneck.

Foreground Wait Events
**********************
Avg
%Time Total Wait wait Waits % DB
Event Waits -outs Time (s) (ms) /txn time
-------------------------- ------------ ----- ---------- ------- -------- ------
direct path read 308,729 0 21,191 69 58.0 39.5
db file sequential read 208,754 0 3,742 18 39.2 7.0
cursor: pin S 19,541,899 0 2,561 0 3,668.5 4.8



Background Wait Events
**********************
Avg
%Time Total Wait wait Waits % bg
Event Waits -outs Time (s) (ms) /txn time
-------------------------- ------------ ----- ---------- ------- -------- ------
log file parallel write 26,479 0 942 36 5.0 40.3
db file parallel write 216,823 0 809 4 40.7 34.6
control file sequential re 11,673 0 56 5 2.2 2.4
control file parallel writ 6,280 0 35 6 1.2 1.5
direct path read 534 0 26 49 0.1 1.1



[Updated on: Mon, 24 June 2013 04:29]

Report message to a moderator

Re: Top wait events [message #588257 is a reply to message #588249] Mon, 24 June 2013 05:09 Go to previous messageGo to next message
Michel Cadot
Messages: 58938
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Not formatted post -> no look.

Regards
Michel
Re: Top wait events [message #588259 is a reply to message #588257] Mon, 24 June 2013 05:30 Go to previous message
Flyby
Messages: 144
Registered: March 2011
Location: Belgium
Senior Member
Find what is causing the direct path reads (~50%) and cpu ~50%. (see Foreground events)
Previous Topic: Tuning a SQL query
Next Topic: Different Timings between 2 Nodes
Goto Forum:
  


Current Time: Fri Aug 29 23:13:32 CDT 2014

Total time taken to generate the page: 0.05278 seconds