Re: strange wait?

"hopehope_123" <hopehope_123_at_yahoo.com> wrote in message news:1120803515.959388.189880_at_o13g2000cwo.googlegroups.com...
>
> Hi ,
>
> The below session ( sid=62) is waiting on db_file_sequental_read event
> for more than 627 seconds. When i strace the process id , i see it is
> polling. Why is this session waiting for disk index read although there
> is no real io in the process? What does this mean?
>
> INST_ID SID SEQ# EVENT P1TEXT P1 P1RAW P2TEXT P2 P2RAW P3TEXT P3 P3RAW
> WAIT_TIME SECONDS_IN_WAIT STATE
> 1 62 37 db file sequential
> read file# 348 000000000000015C block# 48779 000000000000BE8B blocks 1
> 0000000000000001 2 627 WAITED
> KNOWN TIME
>
> This is oracle warehouse builder session . The seq , p1, p2 values are
> all same , it seems the session cont. is requesting the same blcok
> number .
>
> Kind Regards,
> tolga
>

The process is not waiting, the state is "Waited known time". The db file sequential read waited about 2/100 sec (wait_time), and stopped waiting about 627 seconds ago.

Since then the session has probably been using CPU non-stop.

-- 
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 June 22nd 2005