Re: "db file async I/O submit" wait event : 11gR2
- From: Martin Berger <martin.a.berger@xxxxxxxxx>
- To: aditya.yadavalli@xxxxxxxxx
- Date: Thu, 29 Jul 2010 07:20:31 +0200
Aditya,
I've compared your first and last Top events:
Top 5 Timed Events
Avg %Total
~~~~~~~~~~~~~~~~~~
wait Call
Event Waits Time (s)
(ms) Time
----------------------------------------- ------------ -----------
------ ------
db file async I/O submit 13 53
4068 56.2
log file switch (checkpoint incomplete) 4 27
6808 28.9
CPU time
6 6.2
log file parallel write 1,452
5 4 5.8
control file parallel write 65 1
20 1.4
total time: 92s
Top 5 Timed Events
Avg %Total
~~~~~~~~~~~~~~~~~~
wait Call
Event Waits Time (s)
(ms) Time
----------------------------------------- ------------ -----------
------ ------
free buffer waits 117 195
1669 84.8
CPU time
30 13.2
total time: 225s
how long does yor job run?
I suspect you are suffering from some other problems currently not
seen within the wait events.
hth
Martin
op 5 Timed Events
Avg %Total
~~~~~~~~~~~~~~~~~~
wait Call
Event Waits Time (s)
(ms) Time
----------------------------------------- ------------ -----------
------ ------
free buffer waits 117 195
1669 84.8
CPU time
30 13.2
Performance has not much improved overall, compared to another 9i
instance which is having less system resources and buffer sizes the
current instance is taking twice the time. Only the difference is
that top wait event is changing ... still researching the issue..
Cheers/Aditya
Top 5 Timed
Events Avg
%Total
~
~
~~~~~~~~~~~~~~~~
wait
Call
Event Waits Time
(s) (ms)
Time
----------------------------------------- ------------ -----------
------
------
db file async I/O submit 13
53 4068
56.2
log file switch (checkpoint incomplete) 4
27 6808
28.9
CPU time 6
6.2
log file parallel write 1,452
5 4
5.8
control file parallel write 65
1 20
1.4
--
//www.freelists.org/webpage/oracle-l
Other related posts:
