Re: What is the real SGA size?

From: Sheldon Q <sheldonquinny_at_gmail.com>
Date: Wed, 25 Apr 2012 19:26:00 +0000
Message-ID: 2146100988-1335381956-cardhu_decombobulator_blackberry.rim.net-1933667435-_at_b1.c18.bise7.blackberry>

I agree. Show SGA. .

Sent via BlackBerry® from Batelco

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

From: "Lange, Kevin G" <kevin.lange_at_ppoone.com> Sender: oracle-l-bounce_at_freelists.org Date: Wed, 25 Apr 2012 14:15:35
To: <oracle-l_at_freelists.org>
Reply-To: kevin.lange_at_ppoone.com
Subject: RE: What is the real SGA size?

 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

--

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