RE: Automatic Shared Memory question
- To: "Allen, Brandon" <Brandon.Allen@xxxxxxxxxxx>, "ORACLE-L" <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 21 Aug 2006 13:27:43 -0400
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@xxxxxxxxxxx]
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
