Re: strange wait?

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Fri, 8 Jul 2005 12:08:07 +0000 (UTC)
Message-ID: <dalqb7$6ok$1@nwrdmz03.dmz.ncs.ea.ibs-infra.bt.com>

"hopehope_123" <hopehope_123_at_yahoo.com> wrote in message news:1120822389.697372.214090_at_g14g2000cwa.googlegroups.com...
> Hi Jonathan ,
>
> Thanks for your help. As far as i understood , the session has
> completed the db file seq.read event , am i right? Then what does it
> really wait or what does it really do?
>
> thanks,
> hope
>

After the wait is over, it will use CPU until the next wait. Your session seems to have been on the CPU for 627 seconds, non-stop (apart from time when it was de-scheduled by the operating system, of course).

-- 
Regards

Jonathan Lewis

Now waiting on the publishers:    Cost Based Oracle - Volume 1

http://www.jlcomp.demon.co.uk/faq/ind_faq.html
The Co-operative Oracle Users' FAQ

http://www.jlcomp.demon.co.uk/appearances.html
Public Appearances - schedule updated 8th July 2005

Received on Fri Jul 08 2005 - 07:08:07 CDT