Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Cursor Cache and Excessive Parsing
SESSION CACHED CURSORS will only help reduce the time spent on soft
parsing, not hard parsing.
In TKPROF putput, for each SQL, check the value for "Misses in library
cache during parse". Check if this is equal to the PARSE COUNT.
regards
Srivenu
Received on Thu Feb 26 2004 - 02:41:40 CST