Re: Parse

  • From: Niall Litchfield <niall.litchfield@xxxxxxxxx>
  • To: oracle455@xxxxxxxxx
  • Date: Sun, 16 Aug 2015 14:00:36 +0100

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?




--
Niall Litchfield
Oracle DBA
http://www.orawin.info
  • References:
    • Parse
      • From: Michael Calisi

Other related posts: