Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Event 'db file seq. read' stuck for hours on the same file#/block# ?

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 23:19:09 GMT
Message-ID: <NL6Vd.31866$_G.31835@clgrps12>


Sybrand Bakker wrote:

> On Tue, 01 Mar 2005 19:58:39 GMT, Haximus <e_at_t.me> wrote:
>

>>Anywho... this is beside the point I wanted to make, which is something is
>>obviously blocking the read from completing... like for example another
>>session accessing to the same block, in which case could result in a
>>'buffer busy wait' hang, that sort of thing, or latch contention....  get
>>the idea?

>
> You are very talented at making a mess of things, aren't you?
> What has 'buffer busy wait' to do with 'latch contention', apart from
> nothing?

For example, two concurrent processes trying to read the same data block into buffer ... one process will block the other until the read has been completed, resulting in a 'buffer busy wait.' Anyhow, if you go back and read what I wrote you'll see that your reading comprehension needs a little work.

>>
>>Just a tip: quoting from manuals doesn't help anyone when obviously you do
>>not seem to understand the underlying processes involved.

>
> If you would only follow up your own advice and try to understand the
> processes involved....

Yes, and again, your offering/fix/solution/advice was what? Received on Tue Mar 01 2005 - 17:19:09 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US