DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: "Execute to Parse ratio" NEGATIVE

  1. #1
    Join Date
    Oct 2006
    Location
    Mumbai
    Posts
    184

    "Execute to Parse ratio" NEGATIVE

    Dear All,

    A strange problem again:

    I have taken statspack reports and my "execute to parse ratio" is negative in some reports. When i diagnose the "SQL ordered by Parse Calls for DB:" i have the below query

    Parse Calls Executions Parses Hash Value
    ------------ ------------ -------- ----------
    30,116 15,517 31.17 766554780
    Module: dpm2010.exe
    SELECT SYSDATE FROM DUAL

    which shows the number of parse calls higher than the executions.

    Can anybody tell me what should be the workaround to resolve this issue ?

    Paresh

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    stop parsing it and never executing it - its your application which does it, so you need to fix dpm2010.exe

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width