Hi,
I have a memory problem in my linux machine, and i dont know if its related to oracle or to the o.s
Its a linux machine(Linux 2.6.18-8.el5PAE #1 i686) with 8 GB memory:
free -t
total used free shared buffers cached
Mem: 8310164 8205900 104264 0 661248 6965220
-/+ buffers/cache: 579432 7730732
Swap: 8388576 52752 8335824
Total: 16698740 8258652 8440088
As you can see 99% of the memory is in use.
But my SGA+PGA totally togther not more than 2GB
SQL> show parameter sga
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
lock_sga boolean FALSE
pre_page_sga boolean FALSE
sga_max_size big integer 1536M
sga_target big integer 1536M
SQL> show parameter pga
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
pga_aggregate_target big integer 565M
I runned "./rda.sh -dT hcve" and all the kernel parameters are OK.
Top shows that oracle process (pmon/smon/dbwr/ etc) are the main consumer .
How come that oracle is all the 8GB when the SGA+PGA size is only about 2 GB .
Its may related to O.S problem ?
top - 22:20:04 up 10 days, 23:45, 2 users, load average: 0.18, 0.11, 0.09
Tasks: 168 total, 1 running, 167 sleeping, 0 stopped, 0 zombie
Cpu(s): 4.7%us, 1.1%sy, 0.0%ni, 94.2%id, 0.1%wa, 0.0%hi, 0.0%si, 0.0%st
Mem: 8310164k total, 8206776k used, 103388k free, 661168k buffers
Swap: 8388576k total, 52752k used, 8335824k free, 6965216k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
12023 oracle 15 0 1631m 715m 714m S 0 8.8 0:06.27 oracle
12025 oracle 15 0 1635m 609m 605m S 0 7.5 0:11.77 oracle
12031 oracle 18 0 1634m 224m 220m S 0 2.8 0:32.75 oracle
12037 oracle 15 0 1636m 202m 197m S 0 2.5 0:26.39 oracle
12035 oracle 15 0 1636m 154m 148m S 0 1.9 0:22.68 oracle
6268 oracle RT 0 145m 144m 19m S 0 1.8 0:29.83 ocssd.bin
12669 oracle 15 0 1636m 129m 124m S 0 1.6 0:06.93 oracle
12106 oracle 15 0 1634m 101m 98m S 0 1.3 0:01.62 oracle
12027 oracle 15 0 1654m 50m 47m S 0 0.6 0:18.27 oracle
12033 oracle 15 0 1633m 49m 46m S 0 0.6 0:00.12 oracle
12029 oracle 15 0 1633m 47m 44m S 0 0.6 0:36.61 oracle
4769 oracle 16 0 109m 38m 9832 S 0 0.5 10:05.60 emagent
12039 oracle 15 0 1633m 30m 28m S 0 0.4 0:00.10 oracle
12061 oracle 19 0 1647m 29m 17m S 0 0.4 0:11.82 oracle
12059 oracle 15 0 1647m 29m 17m S 0 0.4 0:01.99 oracle
12046 oracle 18 0 1631m 17m 16m S 0 0.2 0:07.80 oracle
13128 oracle 15 0 1631m 16m 15m S 0 0.2 0:00.01 oracle