RE: 9i Parsing Optimization

  • From: "Laimutis Nedzinskas" <Laimutis.Nedzinskas@xxxxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 31 Aug 2006 16:31:47 -0000

>If I understand correctly, session_cached_cursors causes a "softer" parse, but 
>a parse would still show up as a parse in the 10046 output 
 
 
so far the best desciption of shared pool and parsing I know is here:
 
http://download-uk.oracle.com/oowsf2005/003wp.pdf#search=%22understanding%20shared%20pool%20memory%20structures%22
 
It indirectly confirms the "softer parse" notion.
 
 
 
 


________________________________

From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of Allen, Brandon
Sent: 31. ágúst 2006 16:17
To: Polarski, Bernard; anjo.kolk@xxxxxxxxxxx; ax.mount@xxxxxxxxx; 
oracle-l@xxxxxxxxxxxxx
Subject: RE: 9i Parsing Optimization


If I understand correctly, session_cached_cursors causes a "softer" parse, but 
a parse would still show up as a parse in the 10046 output so I don't believe 
this parameter could be responsible for the 50% reduction in parse count.  
Someone please correct me if I'm wrong.
 
________________________________

 

Fyrirvari/Disclaimer
http://www.landsbanki.is/disclaimer

Other related posts: