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:47:31 -0800
Message-ID: <1109745862.420779@yasure>

Sybrand Bakker wrote:

> On Tue, 01 Mar 2005 16:22:48 GMT, "Haximus" <e_at_t.me> wrote:
>
>

>>Excessive amount of wait time on library cache latches?  This can happen 
>>when massive amounts of SQL parsing takes place, causes lots of library 
>>cache latch demand.  What does the entire SELECT look like.... are there 
>>literals embedded in it that would cause it to be reparsed every time, 
>>instead of reused from the library cache? 
>>

>
>
> Please stop posting this mess.
> If you submit an identical statement with identical literals for the
> second time it has the same hash value and it is only soft-parsed.
>
> I haven't seen such utter rubbish in this group for ages.
>
>
> --
> Sybrand Bakker, Senior Oracle DBA

And if you remember who posted that rubbish ... it is the same person posting under a different name. I was so hoping he'd learn SQL Server.

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

Received on Wed Mar 02 2005 - 00:47:31 CST