Re: Interesting problem
From: Mladen Gogala <no_at_email.here.invalid>
Date: Wed, 25 May 2011 16:33:02 +0000 (UTC)
Message-ID: <pan.2011.05.25.16.33.02_at_email.here.invalid>
On Wed, 25 May 2011 08:27:25 -0700, John Hurley wrote:
Date: Wed, 25 May 2011 16:33:02 +0000 (UTC)
Message-ID: <pan.2011.05.25.16.33.02_at_email.here.invalid>
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 10.2.0.5 64bit on RH Leenoox, with the April PSU applied.
-- http://mgogala.byethost5.comReceived on Wed May 25 2011 - 11:33:02 CDT