RE: Automatic Shared Memory question

Thanks a lot for the info. Keep me posted on this issue, if they have consider this as a bug please forward me the bug number.

-----Original Message-----

From: Allen, Brandon [mailto:Brandon.Allen_at_OneNeck.com] Sent: Monday, August 21, 2006 12:29 PM
To: Harvinder Singh; ORACLE-L
Subject: RE: Automatic Shared Memory question

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Harvinder Singh Sent: Monday, August 21, 2006 8:43 AM
To: ORACLE-L
Subject: Automatic Shared Memory question

Hi,

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 oracle:
sga_max_size=943718400
sga_target=629145600

Privileged/Confidential Information may be contained in this message or attachments hereto. Please advise immediately if you or your employer do not consent to Internet email for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of this company shall be understood as neither given nor endorsed by it.

--
http://www.freelists.org/webpage/oracle-l