"Spendius" <spendius_at_muchomail.com> wrote in message
news:aba30b75.0502280753.1eeb7aaa_at_posting.google.com...
> Hi,
> We have a procedure that makes the sessions that call it hang for
> hours, and I see in V$SESSION_WAIT the event 'db file sequential
> read' showing the same file number and block number ALL THE TIME
> it keeps hanging (in fact I never waited until it ended but always
> killed the sessions).
>
> Is it a normal behaviour ? It's all the more peculiar as the file and
> block id's point to an index block, created on a empty table !
> Nothing moves, everything seems to be stalled to death. The fields
> p1/p2/p3text and p1/p2/p3 keep showing me the same file#, block# and
> blocks values: 12, 37173, 1...
>
> Any idea about what's going on please ?
> (Oracle 8.1.7.4 64-bit on Solaris 8)
Just a thought... latch contention? 'db file seq. read' is for control file
and datafile header access, a latch must be required to access these areas,
the process might be requesting one in willing-to-wait mode, not getting it
and retrying... retrying... etc
Received on Mon Feb 28 2005 - 23:54:09 CST
