FreeLists / oracle-l / RE: SESSION_CACHED_CURSORS

["Ruth Gramolini" <rgramolini@xxxxxxxxxxxxxxx>]

If you send your bstat/estat or statspack report to YAPP, they will give you
a suggested number for this parameter.  They suggested 100 for one of  my
production databases.

Ruth

  -----Original Message-----
  From: oracle-l-bounce@xxxxxxxxxxxxx
  [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Muqthar Ahmed
  Sent: Friday, April 30, 2004 1:04 PM
  To: 'oracle-l@xxxxxxxxxxxxx'
  Subject: 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
  -----------------------------------------------------------------


----------------------------------------------------------------
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
-----------------------------------------------------------------