Question on Statspack: parses and executions
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Question on Statspack: parses and executions

  1. #1
    Join Date
    Jul 2004
    Posts
    21

    Post Question on Statspack: parses and executions

    I have a 9i Database (9.2.0.5)
    and when I run statspack
    under the section of Parses and Executions
    " Parse Calls Executions Parses Hash Value"

    I have entries like:

    2,853 2,853 3.68 864382921
    Module: clearquest.exe
    select site_id, next_aux_id from dbglobal

    True the init.ora - cursor_sharing is set to EXACT
    (and session_cached_cursors set to 100)

    Why is the # of parses = # executions,
    For such a sql statement (with no constants)
    why should it not in parsed once ?
    (If there are differences [spaces for example] of the same sql statement
    why does the sql statement show once?)

    The SharePool is big enough ; currently 464MB
    and according to SharePool Advice
    even almost 1/2 (272 MB) the timed saved factor is the same.

  2. #2
    Join Date
    Oct 2002
    Posts
    807
    "Parse calls" includes hard and soft parses.

  3. #3
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,136
    "Parse calls" in this section indicates "soft parses".
    The sql statement was initially hard parsed when it was first executed. But subsequent sessions sent the same statement to oracle. So Oracle has to do soft parse only - checking privileges etc for the new users.

    Tamil

  4. #4
    Join Date
    Jul 2004
    Posts
    21
    What is the purpose of the Section if the parse and execution will have the same number 99.9% (if parse means that it includes hard and soft) ?

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