RE: What is the real SGA size?
- From: "Sweetser, Joe" <JSweetser@xxxxxxxx>
- To: "sheldonquinny@xxxxxxxxx" <sheldonquinny@xxxxxxxxx>, "kevin.lange@xxxxxxxxxx" <kevin.lange@xxxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 25 Apr 2012 19:34:39 +0000
Ditto but here is an additional query that seems to give one a little more
fine-grained answer...
SYS@qa1> col name format a35
SYS@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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Sheldon Q
Sent: Wednesday, April 25, 2012 1:26 PM
To: kevin.lange@xxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxx>
Sender: oracle-l-bounce@xxxxxxxxxxxxx
Date: Wed, 25 Apr 2012 14:15:35
To: <oracle-l@xxxxxxxxxxxxx>
Reply-To: kevin.lange@xxxxxxxxxx
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Orlando L
Sent: Wednesday, April 25, 2012 2:08 PM
To: oracle-l@xxxxxxxxxxxxx
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.
--
//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.
--
//www.freelists.org/webpage/oracle-l
--
//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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
