Re: V$SQLAREA

From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Wed, 14 Dec 2011 20:57:41 +0000 (UTC)
Message-ID: <pan.2011.12.14.20.57.41_at_gmail.com>

On Wed, 14 Dec 2011 20:47:02 +0000, Mladen Gogala wrote:

> In older versions of Oracle, there was a rule saying that V$SQLAREA is
> evil because queries against it will hit library cache latch once for
> every row. I was unable to confirm this in 11.2.0.3. The only latch it
> seems to be hitting is SQL memory manager workarea list latch.
> Did anyone else notice that? If my findings are right, that would make
> V$SQLAREA view much more useful for monitoring and querying purposes.

BTW, here is an old discussion from the Oracle-l mentioning V$SQLAREA:

http://www.freelists.org/post/oracle-l/Few-questions-about-VSQLAREA,1

Another text is here:
https://netfiles.uiuc.edu/jstrode/www/oraview/V$SQLAREA.html

-- 
http://mgogala.byethost5.com

Received on Wed Dec 14 2011 - 14:57:41 CST