What is the real SGA size?

From: Orlando L <oralrnr_at_gmail.com>
Date: Wed, 25 Apr 2012 14:08:16 -0500
Message-ID: <CAL8Ae75JpjrkwXLzP8hjpwUoALNyS7oVDK3CC2C==tMk+Aqq3A_at_mail.gmail.com>

Hi all,
This is an instance in v11.

SQL> sho parameter memory

NAME                                 TYPE        VALUE


------------------------------------ -----------

------------------------------

hi_shared_memory_address             integer     0
memory_max_target                    big integer 1072M
memory_target                        big integer 1072M
shared_memory_address                integer     0

SQL>
SQL> sho parameter sga

NAME                                 TYPE        VALUE


------------------------------------ -----------

------------------------------

lock_sga                             boolean     FALSE
pre_page_sga                         boolean     FALSE
sga_max_size                         big integer 1072M
sga_target                           big integer 0

SQL>
SQL> select * from v$sga;

NAME                                                    VALUE


-------------------------------------------------- ----------

Fixed Size                                            2212616
Variable Size                                       855641336
Database Buffers                                    251658240
Redo Buffers                                          9531392

SQL> What is the actual SGA being used now?

Orlando.

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Apr 25 2012 - 14:08:16 CDT