 | | | Forcing ASMM component to shrink | Forcing ASMM component to shrink 2007-12-01 - By Vishal Gupta
Back
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
<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: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;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-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;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;}
@(protected) Section1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
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=EN-GB link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal>Hi,<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>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></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>Cheers,<o:p></o:p></p>
<p class=MsoNormal>Vishal<o:p></o:p></p>
</div>
</body>
</html>
|
|
|