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

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

--
Sybrand Bakker, Senior Oracle DBA