Re: Resolving Contentions?

The average wait is the total time waited divided by the total number of waits.
I wouldn't focus on that area initially. You need to look into buffer cache hit rate and shared pool hit rate first, and maybe the page fault rate of your box.
Also, as to your post, without looking at output, it will be impossible to tell how to correct it.

Hth,

Sybrand Bakker, Oracle DBA

<comtrex_inc_at_my-deja.com> wrote in message news:7pfbv4$mfe$1_at_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:46:14 CDT