V$SQLAREA
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.
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.
0