Execute to Parse % in statspack
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Execute to Parse % in statspack

  1. #1
    Join Date
    Jul 2001
    Location
    Montreal
    Posts
    218

    Execute to Parse % in statspack

    Hi, I've been generating several statspack reports of our OLTP database(9.2.0.4) and noticed that the "Execute to Parse %" is constantly between 25-50%. The %Library Hit% is always near 100%. We are not suffering performance problems. We have CURSOR_SHARING=SIMILAR.
    Do I need to be concerned with the Execute to Parse issue since the Libary cache is always around 100%?
    Thanks for your inputs.

  2. #2
    Join Date
    Mar 2004
    Location
    DC,USA
    Posts
    650
    when everything is working fine why do you worry, relax

    What's is your value on session cached cursors?

  3. #3
    Join Date
    Jul 2001
    Location
    Montreal
    Posts
    218
    Hi. session_cached_cursors=50

    Is this why the percentage is too low? Should I increase it to 200?

  4. #4
    Join Date
    Mar 2004
    Location
    DC,USA
    Posts
    650
    That would reduce the parse count. Run statspack again to see the difference.

    Are there waits, I/O - run TKprof and post.

  5. #5
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    Quote Originally Posted by pascal01
    Hi, I've been generating several statspack reports of our OLTP database(9.2.0.4) and noticed that the "Execute to Parse %" is constantly between 25-50%. The %Library Hit% is always near 100%. We are not suffering performance problems. We have CURSOR_SHARING=SIMILAR.
    Do I need to be concerned with the Execute to Parse issue since the Libary cache is always around 100%?
    Thanks for your inputs.
    CURSOR_SHARING=SIMILAR requires additional soft parse. It's NOT advisable to use SIMILAR / FORCE in a production environment.

  6. #6
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Quote Originally Posted by pascal01
    Hi. session_cached_cursors=50

    Is this why the percentage is too low? Should I increase it to 200?
    Maybe yes, maybe no. How much time is being spent doing this?
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

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