Re: no mem, server hung

From: RR <rickraster_at_hotmail.com>
Date: 20 Jun 2002 12:09:52 -0700
Message-ID: <97b4acf3.0206201109.3d4213a7@posting.google.com>

Also, don't know if this has any bearing, but I ran a select * from v$system_event where event like '%wait%'; and got the following:

EVENT                   TOTAL_WAITS TOTAL_TIMEOUTS TIME_WAITED

AVERAGE_WAIT
----------------------- ----------- -------------- -----------

slave wait                    75879          45208           0        
   0
free buffer waits                 2              1           0        
   0
local write wait                  9              0           0        
   0
buffer busy waits                98              1           0        
   0
LGWR wait for redo copy         279            135           0

Does this help anything?

Rick Received on Thu Jun 20 2002 - 14:09:52 CDT