Linux SGA size increasing automatically.
divNov 26 2010 — edited Nov 27 2010Posted: Nov 26, 2010 8:57 AM Edit Reply
Hi
I have oracle 11g installed on linux.I had initially configured the sga_target to be 1.5gb. and pga to be 0.5gb
However after running some load testing data through load runner, the sga target bumped up to around 3GB at the end.
Below are some queries that I ran against the databae. I'm trying to figure why it jumped up and how I can restrict it from doing so.
Thanks in advance.
Oracle Database 11g Release 11.1.0.6.0 - 64bit Production
PL/SQL Release 11.1.0.6.0 - Production
CORE 11.1.0.6.0 Production
TNS for Linux: Version 11.1.0.6.0 - Production
NLSRTL Version 11.1.0.6.0 - Production
NAME TYPE VALUE
--------------------------------------------------------------------------------
-----------
--------------------------------------------------------------------------------
lock_sga boolean FALSE
pre_page_sga boolean FALSE
sga_max_size big integer 3664M
sga_target big integer 3648M
show sga
Total System Global Area 3824893952 bytes
Fixed Size 2150120 bytes
Variable Size 2483028248 bytes
Database Buffers 1325400064 bytes
Redo Buffers 14315520 byte
SQL> show parameter memory
NAME TYPE VALUE
--------------------------------------------------------------------------------
-----------
--------------------------------------------------------------------------------
hi_shared_memory_address integer 0
memory_max_target big integer 0
memory_target big integer 0
shared_memory_address integer 0
Edited by: user8952784 on Nov 26, 2010 10:31 AM