Re: session_cached_cursors and ora-07745

  • From: altay <altay.memioglu@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Wed, 16 Mar 2005 03:23:13 -0800

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
--
//www.freelists.org/webpage/oracle-l

Other related posts: