I have 3 dbs running on linux server . the sga max allocated for each db as follows.
db1 - 19327352832 bytes
db2 - 21474836480 bytes
db3 - 3170893824 bytes
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
8574 oracle10 25 0 18.1g 9.2g 9.2g R 99.9 13.1 26:24.75 oracle
9246 oracle10 17 0 18.1g 7.7g 7.7g R 99.8 10.8 3:52.47 oracle
20071 oracle10 19 0 18.1g 1.7g 1.7g R 99.8 2.4 15:47.87 oracle
21654 oracle10 20 0 18.1g 5.8g 5.8g R 99.8 8.2 3:24.50 oracle
17743 oracle10 18 0 18.1g 11g 11g R 99.5 16.7 8:39.73 oracle
17331 oracle10 19 0 18.1g 9.1g 9.1g R 99.1 12.9 2:49.97 oracle
28654 oracle10 18 0 18.1g 7.6g 7.6g R 99.1 10.7 4:14.28 oracle
12533 oracle10 20 0 18.1g 11g 11g R 98.8 15.6 18:13.35 oracle
5291 oracle10 16 0 18.1g 13g 13g R 91.2 19.8 41:37.81 oracle
22131 oracle10 24 0 18.1g 5.0g 5.0g R 87.9 7.1 318:06.20 oracle
16697 oracle11 15 0 3190m 59m 26m R 45.6 0.1 28:31.88 oracle
29573 oracle10 16 0 18.1g 4.1g 4.1g S 40.6 5.7 1:07.72 oracle
5120 oracle10 15 0 18.5g 12g 12g R 15.9 18.0 6:07.32 oracle
10783 oracle10 16 0 18.1g 971m 966m S 15.5 1.3 22:00.11 oracle
8624 oracle10 16 0 18.1g 8.2g 8.2g S 13.5 11.5 1:29.04 oracle
25943 oracle10 17 0 18.1g 13g 13g R 12.2 19.8 17:17.27 oracle
13165 oracle10 16 0 18.1g 647m 633m S 10.2 0.9 2364:33 oracle
totale memory details
MemTotal: 74165352 kB
MemFree: 128660 kB
Buffers: 127668 kB
Cached: 63194132 kB
SwapCached: 15652 kB
Active: 53759976 kB
Inactive: 13398836 kB
HighTotal: 0 kB
HighFree: 0 kB
LowTotal: 74165352 kB
LowFree: 128660 kB
SwapTotal: 34595896 kB
SwapFree: 32847604 kB
Dirty: 10860 kB
Writeback: 0 kB
Mapped: 41738160 kB
Slab: 669172 kB
CommitLimit: 71678572 kB
Committed_AS: 54083268 kB
PageTables: 5989776 kB
VmallocTotal: 536870911 kB
VmallocUsed: 288356 kB
VmallocChunk: 536582239 kB
HugePages_Total: 0
HugePages_Free: 0
Hugepagesize: 2048 kB
free -m
total used free shared buffers cached
Mem: 72427 72324 102 0 125 61771
-/+ buffers/cache: 10427 61999
Swap: 33785 1707 32077
How do i co-related the oracle memory usage with linux command outputs., as you the free memory 61999 .
what is RES AND SHR in top command in each session why it shows high value for each session. ( in GB ).
I am not able to co-relate the actual memory usage of 3 dbs from OS level.
Can someone help how do i quickly Interprete.