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

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Tue, 01 Mar 2005 22:51:08 -0800
Message-ID: <1109746079.914342@yasure>

Haximus wrote:

> 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).

The onus is not on us to demonstrate that you have been repeatedly posted advice that wanders blindly between dead-wrong and outright dangerous.

Pointing out to others that the bridge is out is sufficient for them to avoid driving off the cliff.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)

Received on Wed Mar 02 2005 - 00:51:08 CST