RE: What is the real SGA size?
Date: Wed, 25 Apr 2012 19:34:39 +0000
Message-ID: <D18D6513433DF04394041EA42B53E91C596B8812_at_ICATMAIL1.ICAT.com>
Ditto but here is an additional query that seems to give one a little more fine-grained answer...
SYS_at_qa1> col name format a35
SYS_at_qa1> select * from v$sgainfo;
NAME BYTES RESIZEABL
----------------------------------- ---------- ---------
Fixed SGA Size 2230768 No Redo Buffers 16932864 No Buffer Cache Size 973078528 Yes Shared Pool Size 1644167168 Yes Large Pool Size 16777216 Yes Java Pool Size 16777216 Yes Streams Pool Size 33554432 Yes Shared IO Pool Size 0 Yes Granule Size 16777216 No Maximum SGA Size 3206836224 No Startup overhead in Shared Pool 134217728 No NAME BYTES RESIZEABL
----------------------------------- ---------- ---------
Free SGA Memory Available 503316480
12 rows selected.
-joe
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Sheldon Q
Sent: Wednesday, April 25, 2012 1:26 PM
To: kevin.lange_at_ppoone.com; oracle-l_at_freelists.org
Subject: Re: What is the real SGA size?
I agree. Show SGA. .
Sent via BlackBerry(r) 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 VALUESQL>
------------------------------------ -----------
------------------------------
hi_shared_memory_address integer 0 memory_max_target big integer 1072M memory_target big integer 1072M shared_memory_address integer 0
SQL> sho parameter sga
NAME TYPE VALUESQL>
------------------------------------ -----------
------------------------------
lock_sga boolean FALSE pre_page_sga boolean FALSE sga_max_size big integer 1072M sga_target big integer 0
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
Confidentiality Note: This message contains information that may be confidential and/or privileged. If you are not the intended recipient, you should not use, copy, disclose, distribute or take any action based on this message. If you have received this message in error, please advise the sender immediately by reply email and delete this message. Although ICAT Managers, LLC, Underwriters at Lloyd's, Syndicate 4242, scans e-mail and attachments for viruses, it does not guarantee that either are virus-free and accepts no liability for any damage sustained as a result of viruses. Thank you.
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Apr 25 2012 - 14:34:39 CDT