Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Cursor Cache and Excessive Parsing

Re: Cursor Cache and Excessive Parsing

From: srivenu <srivenu_at_hotmail.com>
Date: 26 Feb 2004 00:41:40 -0800
Message-ID: <1a68177.0402260041.1731493a@posting.google.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US