Re: system events

Don't worry about that event....

  That event is the time Oracle is waiting for you to type in your queries (or click something in your app).
This will almost always have the longest time.

-John
www.ezsql.net

"Roger Clarke" <rclarke_at_brookes.ac.uk> wrote in message news:9ktmpa$r4j$1_at_cs3.brookes.ac.uk...
> Dear all
>
> EVENT TOTAL_WAITS TIME_WAITED
> SQL*Net message from client 414364 40916046
>
> The above data was taken from the V$SYSTEM_EVENT table. This event has by
 far
> the longest waits, and I would like to decrease it if possible.
>
> Anyone know exactly what this is caused by, and how to lower the number of
> waits? My guess was network traffic, but I cannot find explicit reference
 to
> this event anywhere.
>
> Any have experience of long waits on this event?
>
> Roger Clarke
> Database Administrator
>
Received on Thu Aug 09 2001 - 06:37:17 CDT