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

Thread: soft pare versus hard parse

Threaded View

  1. #1
    Join Date
    Oct 2003
    Posts
    312

    soft pare versus hard parse

    based on the result below:

    OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTS

    call count cpu elapsed disk query current rows
    ------- ------ -------- ---------- ---------- ---------- ---------- ----------
    Parse 4697 5.01 7.46 0 0 0 0
    Execute 3897 12.96 276.84 457 1490 15037 704
    Fetch 3092 2.00 1.95 0 18592 0 921
    ------- ------ -------- ---------- ---------- ---------- ---------- ----------
    total 11686 19.98 286.25 457 20082 15037 1625

    Misses in library cache during parse: 23


    OVERALL TOTALS FOR ALL RECURSIVE STATEMENTS

    call count cpu elapsed disk query current rows
    ------- ------ -------- ---------- ---------- ---------- ---------- ----------
    Parse 1407 0.04 0.07 0 0 0 0
    Execute 1407 0.21 0.29 0 1404 1409 702
    Fetch 705 5.26 120.24 0 2113 702 704
    ------- ------ -------- ---------- ---------- ---------- ---------- ----------
    total 3519 5.53 120.60 0 3517 2111 1406

    Misses in library cache during parse: 1

    shared pool was aged out and it had to parse from disk which is bad.
    I have too many hard parse, I have been reading some of the post in asktom and he has mentioned that try to increase session_cached_cursor to some positive number, right now, it's =0 on my database.

    Any inputs???

    as always, thanks for everything
    Last edited by learning_bee; 12-15-2004 at 11:28 AM.

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