High waits/Timeouts - log file parallel write

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

Other related posts: