RE: SESSION_CACHED_CURSORS

Hi,

Never mind!!! I found the following information:

Shared Pool and Library Cache Performance Tuning  <Note:62143.1> 
If you do not have this parameter set already then it is advisable to set it to 
a starting value of about 50. The statistics section of the bstat/estat report 
includes a value for 'session cursor cache hits' which shows if the cursor 
cache is giving any benefit. 

Muqthar
DBA

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of Muqthar Ahmed
Sent: Friday, April 30, 2004 11:00 AM
To: 'oracle-l@xxxxxxxxxxxxx'
Subject: SESSION_CACHED_CURSORS


Hi,
 
How to find out the optimal value for SESSION_CACHED_CURSORS parameter?
 
Thanks
Muqthar Ahmed
Database Administrator
DecorateToday.com
 
 
                *       *       *       *       *       *       *       *       
*

The information contained in this E-mail message is privileged, confidential, 
and may be protected from disclosure; please be aware that any other use, 
printing,copying, 
disclosure or dissemination of this communication may be subject to legal 
restriction or sanction. If you think that you have received this E-mail 
message in error, please 
reply to the sender and delete it from your computer. Thank you. 

----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
                *       *       *       *       *       *       *       *       
*

The information contained in this E-mail message is privileged, confidential, 
and may be protected from disclosure; please be aware that any other use, 
printing,copying, 
disclosure or dissemination of this communication may be subject to legal 
restriction or sanction. If you think that you have received this E-mail 
message in error, please 
reply to the sender and delete it from your computer. Thank you. 
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: