V$SQLAREA
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Wed, 14 Dec 2011 20:47:02 +0000 (UTC)
Message-ID: <pan.2011.12.14.20.47.02_at_gmail.com>
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.
Date: Wed, 14 Dec 2011 20:47:02 +0000 (UTC)
Message-ID: <pan.2011.12.14.20.47.02_at_gmail.com>
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.
-- http://mgogala.byethost5.comReceived on Wed Dec 14 2011 - 14:47:02 CST