RE: Automatic Shared Memory question

  • From: "Allen, Brandon" <Brandon.Allen@xxxxxxxxxxx>
  • To: <Harvinder.Singh@xxxxxxxxxxxxx>, "ORACLE-L" <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 21 Aug 2006 09:29:18 -0700

I have an SR open am still working with Oracle Support on getting an
answer to the same question.  Other related problems I'm seeing are:

1) Large amount of free memory in shared pool, even though cursors are
getting flushed out of the shared pool very quickly
2) Large amount of memory allocated to "KGH: NO ACCESS" in shared pool

I think the solution might be "don't use ASMM", but am waiting for an
official response.

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Harvinder Singh
Sent: Monday, August 21, 2006 8:43 AM
Subject: Automatic Shared Memory question


I am checking the Automatic Shared Memory feature and set the following
2 parameters in init.ora file and recreate the spfile and restarted the

Other related posts: