From oracle-l-bounce@freelists.org Wed Mar 16 06:27:01 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j2GCR1lM012940 for ; Wed, 16 Mar 2005 06:27:01 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j2GCR0em012913 for ; Wed, 16 Mar 2005 06:27:00 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id F274272C51; Wed, 16 Mar 2005 06:25:00 -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 13751-09; Wed, 16 Mar 2005 06:25:00 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 7A8D372D8A; Wed, 16 Mar 2005 06:25:00 -0500 (EST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:mime-version:content-type:content-transfer-encoding; b=E4R7wlcZ1q+oB6nlwJbSym0PeBXYSZCuCrbW5JYhjO+AXmqGocVgbTJpjuBgzuMq6aN6BZZRV5JyP1/2rdypSAA5TZliLxwO6YzI3s/7jV0o+AlTf4szr9yagZv8IYCYtAGEmzB05F8pZPrkFen8FP5Kt1GB0EeDQ/+Pt9XPzHE= Message-ID: <49f95bb305031603234c9059b2@mail.gmail.com> Date: Wed, 16 Mar 2005 03:23:13 -0800 From: altay To: oracle-l@freelists.org Subject: Re: session_cached_cursors and ora-07745 Mime-Version: 1.0 Content-type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-archive-position: 17349 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: altay.memioglu@gmail.com Precedence: normal Reply-To: altay.memioglu@gmail.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-Spam-Checker-Version: SpamAssassin 2.60 (1.212-2003-09-23-exp) on air891.startdedicated.com X-Spam-Status: No, hits=0.0 required=5.0 tests=none autolearn=ham version=2.60 X-Spam-Level: Hi all, I have an 9.2.0.4 instance with Shared pool size = 256 MB Total SGA = 1170,710 MB MAX SGA = 1490,972 and I get ora-7445 frequently. After these conversations i started to think that my Open_Cursor setting with 350 is high for this configuration,but also need to this count. It has failed to patch 9.2.0.5 because of difficulties. Should i dedicate some memory in addition to Shared pool? I wish that could be a solution for my problem. Altay -- http://www.freelists.org/webpage/oracle-l