Re: session_cached_cursors and ora-07745

From: altay <altay.memioglu_at_gmail.com>
Date: Wed, 16 Mar 2005 03:23:13 -0800
Message-ID: <49f95bb305031603234c9059b2@mail.gmail.com>

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

Received on Wed Mar 16 2005 - 06:27:01 CST