Re: V$SQLAREA
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Thu, 15 Dec 2011 02:26:06 +0000 (UTC)
Message-ID: <pan.2011.12.15.02.26.06_at_gmail.com>
On Wed, 14 Dec 2011 17:46:18 -0800, onedbguru wrote:
Date: Thu, 15 Dec 2011 02:26:06 +0000 (UTC)
Message-ID: <pan.2011.12.15.02.26.06_at_gmail.com>
On Wed, 14 Dec 2011 17:46:18 -0800, onedbguru wrote:
> You have to remember that the whole latch/locking mechanisms changed
> with 11.1 and even more in 11.2 Here is a quote from Tanel Poder:
> "In Oracle 11g even more library cache operations have been changed to
> use KGX mutexes instead of latches."
I am aware of that. Jonathan Lewis also writes about that in his latest book. I only wanted to stress the fact that the old recommendation for V$SQLAREA no longer holds true and that the steep price tag connected to that table has been removed.
-- http://mgogala.byethost5.comReceived on Wed Dec 14 2011 - 20:26:06 CST