Re: Interesting problem

From: Mladen Gogala <>
Date: Wed, 25 May 2011 16:33:02 +0000 (UTC)
Message-ID: <>

On Wed, 25 May 2011 08:27:25 -0700, John Hurley wrote:

> If you put a 10046 trace on this code my guess is that you will see a
> ton of logical io's ... library cache latching from plsql should often
> be pretty minimal and session_cached_cursors is set above 0 by default
> in 10g and above.

Yes, you are right. Thanks for the clarification. I didn't use 10046 yesterday because it was fairly obvious where the problem was. I followed your advice and there was a ton of logical I/O. BTW, the database is 64bit on RH Leenoox, with the April PSU applied.

Received on Wed May 25 2011 - 11:33:02 CDT

Original text of this message