Re: Event 'db file seq. read' stuck for hours on the same file#/block# ?

From: Haximus <e_at_t.me>
Date: Tue, 01 Mar 2005 22:42:28 GMT
Message-ID: <od6Vd.31627$_G.19109@clgrps12>

Sybrand Bakker wrote:

> On Tue, 01 Mar 2005 08:29:03 GMT, "Haximus" <e_at_t.me> wrote:
>

>>All I was suggesting is to check if the session is hung on a latch
>>request:
>>
>>select * from v$session_wait sw, v$latchname ln where sw.p2=ln.latch#
>>where sw.sid=###
>>
>>Are all you DBA fixtures here such ogres?  ;)
>>

>
> latch requests are latch requests, and have nothing to do with
> sequential read.
> You are by far the worst source of misinformation here and and would
> advise everyone not to follow up on your postings. You really don't
> know what you are talking about.
> I would consider it unprofessional to let 'advise' like this passed
> without warning.

If you're going to condemn advice, at least provide an explanation of why it is incorrect but don't condemn a guy for trying to help. At least not unless you have a better suggestion to identify/resolve the problem, which so far has been (blank). Received on Tue Mar 01 2005 - 16:42:28 CST