RE: Forcing ASMM component to shrink
- From: "Yasin Baskan" <yasin.baskan@xxxxxxxxxxxxxxxx>
- To: <finn.oracledba@xxxxxxxxx>, <vishal@xxxxxxxxxxxxxxxxx>
- Date: Sun, 2 Dec 2007 01:24:41 +0200
That may not shrink the shared pool. That just sets a lower limit for
shared pool, does not shrink it to that value immediately.
http://download.oracle.com/docs/cd/B19306_01/server.102/b14231/create.ht
m#sthref391
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Finn Jorgensen
Sent: Sunday, December 02, 2007 12:02 AM
To: vishal@xxxxxxxxxxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: Forcing ASMM component to shrink
alter system set shared_pool_size=500M scope=memory;
alter system set db_cache_size=600M scope=memory;
Finn
On Dec 1, 2007 11:59 AM, Vishal Gupta <vishal@xxxxxxxxxxxxxxxxx> wrote:
Hi,
Does anyone know if there is any way to force ASMM memory component to
shrink. Eg. Instance has just been bounced and say shared pool is using
1GB and db_cache is using only 100MB. If one wanted to forcibly shrink
shared pool without bouncing the instance, is there any way to do this?
Cheers,
Vishal
Bu mesaj ve onunla iletilen tum ekler gonderildigi kisi ya da kuruma ozel ve
Bankalar Kanunu geregince, gizlilik yukumlulugu tasiyor olabilir. Bu mesaj,
hicbir sekilde, herhangi bir amac icin cogaltilamaz, yayinlanamaz ve para
karsiligi satilamaz; mesajin yetkili alicisi veya alicisina iletmekten sorumlu
kisi degilseniz, mesaj icerigini ya da eklerini kopyalamayiniz, yayinlamayiniz,
baska kisilere yonlendirmeyiniz ve mesaji gonderen kisiyi derhal uyararak bu
mesaji siliniz. Bu mesajin iceriginde ya da eklerinde yer alan bilgilerin
dogrulugu, butunlugu ve guncelligi Bankamiz tarafindan garanti edilmemektedir
ve bilinen viruslere karsi kontrolleri yapilmis olarak yollanan mesajin
sisteminizde yaratabilecegi zararlardan Bankamiz sorumlu tutulamaz.
This message and the files attached to it are under the privacy liability in
accordance with the Banking Law and confidential to the use of the individual
or entity to whom they are addressed. This message cannot be copied, disclosed
or sold monetary consideration for any purpose. If you are not the intended
recipient of this message, you should not copy, distribute, disclose or forward
the information that exists in the content and in the attachments of this
message; please notify the sender immediately and delete all copies of this
message. Our Bank does not warrant the accuracy, integrity and currency of the
information transmitted with this message. This message has been detected for
all known computer viruses thence our Bank is not liable for the occurrence of
any system corruption caused by this message
Other related posts:
