If you are tracing the session - i,e the *is* currently being hard parsed,
then there'll be a mis=1 in the trace, if you wish to determine how often a
query has *been* hard parsed since startup the LOADS column in (g)v$sqlarea
will tell you that.
On Sun, Aug 16, 2015 at 3:32 AM, Michael Calisi <oracle455@xxxxxxxxx> wrote:
Is there a way to check whether a query is being hard or soft parsed?