Resolving Contentions?

From: <comtrex_inc_at_my-deja.com>
Date: Wed, 18 Aug 1999 22:26:58 GMT
Message-ID: <7pfbv4$mfe$1@nnrp1.deja.com>

Hi,
I am new to the dba world so please be patient. I run the session sql on our database and got on many lines average-wait greater then 0 what does that mean? How to correct it?
This box is really slow.
btw: that sql is from High Performance oracle 8 tuning.

prompt **********************************************************

prompt Session Event Section

prompt **********************************************************

prompt if average-wait > 0 then contention exists prompt
 select substr(event,1,30) event,

       total_waits, total_timeouts, average_wait  from v$session_event
where average_wait > 0 ;

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Wed Aug 18 1999 - 17:26:58 CDT