 | | | Forcing ASMM component to shrink | Forcing ASMM component to shrink 2007-12-01 - By Yasin Baskan
Back
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@(protected)
[mailto:oracle-l-bounce@(protected)] On Behalf Of Finn Jorgensen
Sent: Sunday, December 02, 2007 12:02 AM
To: vishal@(protected)
Cc: oracle-l@(protected)
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@(protected)> 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
<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft
-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:x="urn
:schemas-microsoft-com:office:excel" xmlns:m="http://schemas.microsoft.com
/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<style>
<!--
/* Font Definitions */
@(protected)
{font-family:"Cambria Math";
panose-1 (See http://ose-1.ora-code.com):2 4 5 3 5 4 6 3 2 4;}
@(protected)
{font-family:Calibri;
panose-1 (See http://ose-1.ora-code.com):2 15 5 2 2 2 4 3 2 4;}
@(protected)
{font-family:Tahoma;
panose-1 (See http://ose-1.ora-code.com):2 11 6 4 3 5 4 4 2 4;}
@(protected)
{font-family:Consolas;
panose-1 (See http://ose-1.ora-code.com):2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
p.code, li.code, div.code
{mso-style-name:code;
mso-style-link:"code Char";
margin:0cm;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";}
span.codeChar
{mso-style-name:"code Char";
mso-style-link:code;
font-family:"Courier New";}
span.EmailStyle20
{mso-style-type:personal-reply;
font-family:Consolas;
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;}
@(protected) Section1
{size:612.0pt 792.0pt;
margin:70.85pt 70.85pt 70.85pt 70.85pt;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=TR link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:Consolas;
color:#1F497D'>That may not shrink the shared pool. That just sets a lower
limit for shared pool, does not shrink it to that value immediately.<o:p></o:p>
</span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:Consolas;
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:Consolas;
color:#1F497D'><a
href="http://download.oracle.com/docs/cd/B19306_01/server.102/b14231/create.htm
#sthref391">http://download.oracle.com/docs/cd/B19306_01/server.102/b14231
/create.htm#sthref391</a><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:Consolas;
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:Consolas;
color:#1F497D'><o:p> </o:p></span></p>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm
0cm'>
<p class=MsoNormal><b><span lang=EN-US style='font-size:10.0pt;font-family:
"Tahoma","sans-serif"'>From:</span></b><span lang=EN-US style='font-size:10.0pt;
font-family:"Tahoma","sans-serif"'> oracle-l-bounce@(protected)
[mailto:oracle-l-bounce@(protected)] <b>On Behalf Of </b>Finn Jorgensen<br>
<b>Sent:</b> Sunday, December 02, 2007 12:02 AM<br>
<b>To:</b> vishal@(protected)<br>
<b>Cc:</b> oracle-l@(protected)<br>
<b>Subject:</b> Re: Forcing ASMM component to shrink<o:p></o:p></span></p>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<div>
<p class=MsoNormal>alter system set shared_pool_size=500M scope=memory;<o:p></o
:p></p>
</div>
<div>
<p class=MsoNormal>alter system set db_cache_size=600M scope=memory;<o:p></o:p>
</p>
</div>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal style='margin-bottom:12.0pt'>Finn<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal>On Dec 1, 2007 11:59 AM, Vishal Gupta <<a
href="mailto:vishal@(protected)">vishal@(protected)</a>> wrote:
<o:p></o:p></p>
<div>
<div>
<p><span lang=EN-GB>Hi,<o:p></o:p></span></p>
<p><span lang=EN-GB> <o:p></o:p></span></p>
<p><span lang=EN-GB>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? <o:p><
/o:p></span></p>
<p><span lang=EN-GB> <o:p></o:p></span></p>
<p><span lang=EN-GB>Cheers,<o:p></o:p></span></p>
<p><span lang=EN-GB>Vishal<o:p></o:p></span></p>
</div>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
</div>
</body>
</html>
<table><tr><td bgcolor=#ffffff><font color=#000000><br>
<br>
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.<br>
</font></td></tr></table>
<table><tr><td bgcolor=#ffffff><font color=#000000>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<br>
</font></td></tr></table>
|
|
|