Re: system events

In general, as others have said, don't
worry about it, as it is Oracle waiting
for the client program to do something.

HOWEVER - if you take a snapshot over
a period of time when only batch processes are running, then we would assume that those batch processes don't need 'thinking' time; so if the 'wait for client' is high during those sorts of events (you could target v$session_event for specific sessions) then it may indicate that your network is overloaded, or your batch client process is doing something very expensive at its end of th system.

--
Jonathan Lewis

Seminars on getting the best out of Oracle
Last few places available for Sept 10th/11th
See http://www.jlcomp.demon.co.uk/seminar.html




Roger Clarke wrote in message <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

>