RE: What is the real SGA size?

From: Lange, Kevin G <kevin.lange_at_ppoone.com>
Date: Wed, 25 Apr 2012 14:15:35 -0500
Message-ID: <F077F09A0E11504D9E720358BEE994D10A0C8093_at_APSW0553EVS.ms.ds.uhc.com>

 I have mostly just used the command

Show sga

Total System Global Area 314572800 bytes

Fixed Size                  2040312 bytes
Variable Size             184557064 bytes
Database Buffers          125829120 bytes
Redo Buffers                2146304 bytes

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Orlando L Sent: Wednesday, April 25, 2012 2:08 PM
To: oracle-l_at_freelists.org
Subject: What is the real SGA size?

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

This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately.

--

http://www.freelists.org/webpage/oracle-l Received on Wed Apr 25 2012 - 14:15:35 CDT