Re: How can I see the SGA sizes with auto shared memory management
- From: "Finn Jorgensen" <finn.oracledba@xxxxxxxxx>
- To: genegurevich@xxxxxxxxxxxx
- Date: Wed, 16 Apr 2008 15:36:30 -0400
select name,bytes from v$sgainfo order by 1;
Finn
On 4/16/08, genegurevich@xxxxxxxxxxxx <genegurevich@xxxxxxxxxxxx> 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
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
Other related posts:
