-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|