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

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