Hi All,
My Oracle version is 11.2.0.4 64 Bit
And Linux version is : SUSE Linux Enterprise Server 11 SP3 (x86_64).
Memory utilization in the server is too high.
AP-SGS-SP713:orasop 55> free -m -t
total used free shared buffers cached
Mem: 258341 257482 859 43775 8 219455
-/+ buffers/cache: 38018 220322
Swap: 65535 3919 61616
Total: 323877 261401 62475
AP-SGS-SP713:orasop 56>
TOP 10 process consuming highest memory is below-
AP-SGS-SP713:orasop 56> ps aux | sort -nk +4 | tail
orasop 15385 0.0 3.7 30937152 9916440 ? Ss Nov23 1:40 ora_dbw2_SOP
orasop 15408 0.0 3.7 30933376 9809912 ? Ss Nov23 1:39 ora_dbw5_SOP
orasop 35335 0.6 3.8 30932204 10316356 ? Ss 04:32 3:00 oracleSOP (LOCAL=NO)
orasop 7121 0.1 3.8 30932164 10296904 ? Ss Nov24 1:51 oracleSOP (LOCAL=NO)
orasop 10997 0.3 3.9 30928188 10457696 ? Ss Nov24 3:34 oracleSOP (LOCAL=NO)
orasop 15371 0.0 3.9 30937024 10399132 ? Ss Nov23 1:44 ora_dbw1_SOP
orasop 7216 0.8 4.7 30929072 12475216 ? Ss 05:08 3:55 oracleSOP (LOCAL=NO)
orasop 14793 0.6 5.0 30940416 13390616 ? Ss Nov24 6:29 oracleSOP (LOCAL=NO)
orasop 18524 0.7 5.0 30928112 13329416 ? Ss Nov24 7:08 oracleSOP (LOCAL=NO)
orasop 31019 11.2 5.9 30926108 15609268 ? Rs 06:14 42:21 oracleSOP (LOCAL=NO)
AP-SGS-SP713:orasop 57>
Memory setting in the oracle is :
SQL> select decode(pool,null,name,pool),round(sum(bytes)/1024/1024,4) MB from v$sgastat group by decode(pool,null,name,pool) order by 2 desc;
DECODE(POOL,NULL,NAME,POOL MB
-------------------------- ----------
buffer_cache 15360
shared pool 13952
java pool 448
log_buffer 56.9688
fixed_sga 2.1634
Please suggest if the memory needs to be increased and also i can see dynamic memory management is not enable in the server.
SQL> show parameter sga_target
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
sga_target big integer 0
SQL> show parameter memory_target
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
memory_target big integer 0
SQL>
SQL> show parameter sga_max_size
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
sga_max_size big integer 29952M
SQL>
Please suggest.
Thanks before you act.
Regards
Monoj