DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references;
        b=i2kIN8gVSBnyBQrDJ91RE/TGOcmo5MR3uQTY0Otkv9ZiMXi13zDVRURvPWCXk4N3PnPmxeOkQ+YvcEG/AXX1JVKEcAtM2zK0HasDM46RwvQKejHcibCpvh4L66mx82aZCO/9MQkEGSNYtZjCFSstdIpY8BkfiZlbDB+nknu5iLY=
Message-ID: <74f79c6b0804161236o2ece367cyd221aaa12cbbe36@mail.gmail.com>
Date: Wed, 16 Apr 2008 15:36:30 -0400
From: "Finn Jorgensen" <finn.oracledba@gmail.com>
To: genegurevich@discover.com
Subject: Re: How can I see the SGA sizes with auto shared memory management
Cc: oracle-l@freelists.org
In-Reply-To: <OF4F119AD3.E8522554-ON8625742D.006504E0-8625742D.0065575C@discover.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="----=_Part_3291_6134169.1208374590528"
References: <667C10D184B2674A82068E06A78382B51DDE792B@AAPQMAILBX01V.proque.st>
	 <OF4F119AD3.E8522554-ON8625742D.006504E0-8625742D.0065575C@discover.com>
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-to: finn.oracledba@gmail.com
------=_Part_3291_6134169.1208374590528
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

select name,bytes from v$sgainfo order by 1;

Finn


On 4/16/08, genegurevich@discover.com <genegurevich@discover.com> wrote:
>
> Hi everybody:
>
> I am a little confused as to how to see the real values of the SGA parts
> when auto memory management is available.
> I currently have SGA_TARGET set to 3648M (under oracle 10.2.0.2). When I
> enter
> show parameter shared_pool, the output is 304M - this is the value that I
> have set manually before turning on the auto memory management.
>
> When I look at OEM, it shows the size of shared_pool being 1568M.  This
> does makes sense - oracle adjusting
> the memory parameters on the fly, but is there a way for me to see the
> same
> value from the SQL*Plus command line?
>
> thank you
>
> Gene Gurevich
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

------=_Part_3291_6134169.1208374590528
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

<div>select name,bytes from v$sgainfo order by 1;<br>&nbsp;</div>
<div>Finn<br><br>&nbsp;</div>
<div><span class="gmail_quote">On 4/16/08, <b class="gmail_sendername"><a href="mailto:genegurevich@discover.com">genegurevich@discover.com</a></b> &lt;<a href="mailto:genegurevich@discover.com">genegurevich@discover.com</a>&gt; wrote:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">Hi everybody:<br><br>I am a little confused as to how to see the real values of the SGA parts<br>when auto memory management is available.<br>
I currently have SGA_TARGET set to 3648M (under oracle <a href="http://10.2.0.2">10.2.0.2</a>). When I<br>enter<br>show parameter shared_pool, the output is 304M - this is the value that I<br>have set manually before turning on the auto memory management.<br>
<br>When I look at OEM, it shows the size of shared_pool being 1568M.&nbsp;&nbsp;This<br>does makes sense - oracle adjusting<br>the memory parameters on the fly, but is there a way for me to see the same<br>value from the SQL*Plus command line?<br>
<br>thank you<br><br>Gene Gurevich<br><br><br>--<br><a href="http://www.freelists.org/webpage/oracle-l">http://www.freelists.org/webpage/oracle-l</a><br><br><br></blockquote></div><br>

------=_Part_3291_6134169.1208374590528--
--
http://www.freelists.org/webpage/oracle-l