v$sql - executions vs loads vs invalidations
Date: Tue, 01 May 2012 19:41:33 +1000
I am currently working on a system that is experiencing frequent
ORA-04031 errors. Investigation found that they have a LOT of SQL with
literal values and while I suggested that they fix the code to use bind
variables I meantime set CURSOR_SHARING=FORCE in an attempt to avoid
these errors. This had virtually no effect and while further
investigating I found a number of rows in v$sql with that were
similar to this:
EXECUTIONS: 0 How I read this is that this statement was loaded 2794 times, invalidated 2793 but never executed, but I think this opinion may stem from my ignorance. This is one of hundreds of such statements.
Can anyone enlighten me?
Gerry MillerReceived on Tue May 01 2012 - 04:41:33 CDT