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