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