From oracle-l-bounce@freelists.org Fri Apr 30 14:17:07 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i3UJGpc12722 for ; Fri, 30 Apr 2004 14:17:01 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i3UJGf612676 for ; Fri, 30 Apr 2004 14:16:51 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 9640B72CAF5; Fri, 30 Apr 2004 13:02:47 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 22668-20; Fri, 30 Apr 2004 13:02:47 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id A4F6772CFC7; Fri, 30 Apr 2004 13:02:46 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Fri, 30 Apr 2004 13:01:30 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 5993A72C9CD for ; Fri, 30 Apr 2004 13:01:30 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 19686-95 for ; Fri, 30 Apr 2004 13:01:30 -0500 (EST) Received: from mx1.state.vt.us (ns1.state.vt.us [159.105.23.130]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id A960F72CAF5 for ; Fri, 30 Apr 2004 13:01:29 -0500 (EST) Received: from TAX132 ([159.105.89.132]) by mx1.state.vt.us (Post.Office MTA v3.5.4 release 224 ID# 0-0U10L2S100V35) with SMTP id us for ; Fri, 30 Apr 2004 14:14:31 -0400 From: "Ruth Gramolini" To: Subject: RE: SESSION_CACHED_CURSORS Date: Fri, 30 Apr 2004 14:15:50 -0400 Message-ID: <007001c42edf$2aceb0f0$8459699f@vttaxnet.tax.state.vt.us> MIME-Version: 1.0 Content-type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook 8.5, Build 4.71.2173.0 In-Reply-To: <6362087FB073D41195B800D0B78284BE0621C9E1@mail01.corp.abwf.com> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409 Importance: Normal X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 4118 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: rgramolini@tax.state.vt.us Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org 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@freelists.org [mailto:oracle-l-bounce@freelists.org]On Behalf Of Muqthar Ahmed Sent: Friday, April 30, 2004 1:04 PM To: 'oracle-l@freelists.org' Subject: RE: SESSION_CACHED_CURSORS Hi, Never mind!!! I found the following information: Shared Pool and Library Cache Performance Tuning 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@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Muqthar Ahmed Sent: Friday, April 30, 2004 11:00 AM To: 'oracle-l@freelists.org' 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@freelists.org 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@freelists.org 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@freelists.org 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 -----------------------------------------------------------------