Re: What is the real SGA size?
- From: "Sheldon Q" <sheldonquinny@xxxxxxxxx>
- To: kevin.lange@xxxxxxxxxx,oracle-l@xxxxxxxxxxxxx
- Date: Wed, 25 Apr 2012 19:26:00 +0000
I agree. Show SGA. .
Sent via BlackBerry® 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
Other related posts:
