High waits/Timeouts - log file parallel write

From: TP <pele_00_2000_at_yahoo.com>
Date: Mon, 27 Feb 2006 14:09:10 -0800 (PST)
Message-ID: <20060227220910.4359.qmail@web30004.mail.mud.yahoo.com>

Hello all,

I seeing high Waits, Timeouts from one the problem instance.

Top 5 Timed Events

---

                     % Total
Event                                            

  Waits Time (s) Ela Time

---

• ----------- -------- CPU time 8 40.51 control file parallel write 642 5 25.56 db file sequential read 343 2 9.40 log file parallel write 9,697 2 7.99 log file sync 425 1 5.69

  ---

^LWait Events for DB: C3PO Instance: C3PO Snaps: 15 -16
-> s - second
-> cs - centisecond - 100th of a second
-> ms - millisecond - 1000th of a second
-> us - microsecond - 1000000th of a second
-> ordered by wait time desc, waits desc (idle
events last)

                                                 
                                 
                                                 
                 Avg
                                                 
   Total Wait   wait    Waits
Event                               Waits  
Timeouts   Time (s)   (ms)     /txn
---------------------------- ------------
---------- ---------- ------ --------
control file parallel write           642        
 0          5      8      1.4
db file sequential read               343        
 0          2      6      0.7
log file parallel write             9,697     
8,429          2      0     21.1
log file sync                         425        
 0          1      3      0.9
process startup                        30        
 0          1     38      0.1
SQL*Net break/reset to clien        3,522        
 0          1      0      7.7
control file sequential read          333        
 0          0      1      0.7
db file scattered read                  3        
 0          0     15      0.0
LGWR wait for redo copy             1,142        
 0          0      0      2.5
db file parallel write                873        
 0          0      0      1.9
SQL*Net more data to client           207        
 0          0      0      0.5
latch free                             29        
29          0      0      0.1
buffer busy waits                       2        
 0          0      0      0.0

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

It seems like I'm having some issue with the LGWR "log file parallel write" (timeouts).
Can you suggest and/or provide some
recommendations? The DB version is 9205 on Solaris 2.9.

Thanks in advance!
Tom

"  ,--o                          
  -\\_<_   Do you ride? "                     

(*)/-'(*)

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Feb 27 2006 - 16:09:10 CST