-
Oracle used all my ram, why?
os: Oracle enterprise linux
oracle: 10.2.0.3
ram:16 gig
Situation:
I have 3 instances on my machine.
They should take maximum 2 gig of ram all together.
But my ram is all used up by oracle anyway.
Anyone has an idea?
SQL> select instance_name from v$instance;
INSTANCE_NAME
----------------
juk_dev
SQL> show parameter sga;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
lock_sga boolean FALSE
pre_page_sga boolean FALSE
sga_max_size big integer 272M
sga_target big integer 272M
SQL> show parameter pga;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
pga_aggregate_target big integer 90M
SQL> select instance_name from v$instance;
INSTANCE_NAME
----------------
mus_dev
SQL> show parameter sga;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
lock_sga boolean FALSE
pre_page_sga boolean FALSE
sga_max_size big integer 272M
sga_target big integer 272M
SQL> show parameter pga;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
pga_aggregate_target big integer 90M
SQL> select instance_name from v$instance;
INSTANCE_NAME
----------------
crn_dev
SQL> show parameter sga;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
lock_sga boolean FALSE
pre_page_sga boolean FALSE
sga_max_size big integer 272M
sga_target big integer 272M
SQL> show parameter pga;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
pga_aggregate_target big integer 90M
top - 11:00:26 up 7 days, 14:26, 2 users, load average: 0.24, 0.06, 0.02
Tasks: 194 total, 1 running, 193 sleeping, 0 stopped, 0 zombie
Cpu(s): 0.1% us, 0.1% sy, 0.0% ni, 99.8% id, 0.0% wa, 0.0% hi, 0.0% si
Mem: 16633368k total, 15852732k used, 780636k free, 86796k buffers
Swap: 4096532k total, 72892k used, 4023640k free, 15103816k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
31627 oracle 16 0 393m 222m 192m S 0 1.4 0:46.10 oracle
31633 oracle 16 0 363m 221m 217m S 0 1.4 0:11.73 oracle
26416 oracle 16 0 384m 213m 192m S 0 1.3 14:51.40 oracle
24175 oracle 16 0 363m 167m 163m S 0 1.0 0:23.89 oracle
31103 oracle 16 0 362m 156m 153m S 0 1.0 0:07.07 oracle
11659 oracle 15 0 363m 149m 147m S 0 0.9 0:30.59 oracle
449 oracle 16 0 363m 146m 143m S 0 0.9 0:04.64 oracle
8641 oracle 15 0 362m 142m 139m S 0 0.9 0:03.57 oracle
443 oracle 16 0 376m 141m 128m S 0 0.9 5:38.09 oracle
31109 oracle 15 0 362m 138m 135m S 0 0.9 0:09.41 oracle
24152 oracle 16 0 363m 115m 112m S 0 0.7 0:51.03 oracle
31639 oracle 16 0 363m 115m 111m S 0 0.7 0:03.79 oracle
24162 oracle 16 0 363m 115m 111m S 0 0.7 0:36.68 oracle
453 oracle 16 0 362m 97m 94m S 0 0.6 0:01.39 oracle
31625 oracle 16 0 361m 86m 85m S 0 0.5 0:00.15 oracle
31637 oracle 16 0 362m 86m 83m S 0 0.5 0:04.66 oracle
455 oracle 16 0 363m 83m 79m S 0 0.5 0:01.36 oracle
31101 oracle 16 0 361m 82m 81m S 0 0.5 0:00.17 oracle
3093 oracle 16 0 363m 73m 70m S 0 0.5 0:00.75 oracle
31115 oracle 16 0 363m 71m 67m S 0 0.4 0:03.34 oracle
20028 oracle 16 0 362m 68m 65m S 0 0.4 0:04.47 oracle
24192 oracle 16 0 362m 62m 60m S 0 0.4 0:00.61 oracle
441 oracle 16 0 361m 60m 59m S 0 0.4 0:00.06 oracle
18002 oracle 16 0 363m 60m 57m S 0 0.4 0:43.23 oracle
31725 oracle 16 0 362m 57m 55m S 0 0.4 0:00.72 oracle
24196 oracle 16 0 362m 56m 52m S 0 0.3 0:00.58 oracle
31113 oracle 16 0 362m 55m 52m S 0 0.3 0:04.52 oracle
19241 oracle 16 0 362m 55m 52m S 0 0.3 0:03.08 oracle
24194 oracle 17 0 362m 51m 48m S 0 0.3 0:00.62 oracle
2252 oracle 16 0 363m 50m 47m S 0 0.3 0:00.26 oracle
20379 oracle 15 0 362m 41m 38m S 0 0.3 0:00.09 oracle
15572 oracle 16 0 362m 37m 35m S 0 0.2 0:00.12 oracle
8510 oracle 15 0 362m 37m 34m S 0 0.2 0:00.14 oracle
20422 oracle 16 0 362m 36m 33m S 0 0.2 0:00.08 oracle
8370 oracle 15 0 362m 33m 30m S 0 0.2 0:00.11 oracle
20524 oracle 15 0 362m 32m 30m S 0 0.2 0:00.09 oracle
4943 oracle 16 0 362m 28m 26m S 0 0.2 0:00.06 oracle
2276 oracle 16 0 362m 28m 25m S 0 0.2 0:00.04 oracle
12036 oracle 16 0 362m 27m 25m S 0 0.2 0:00.06 oracle
24125 oracle 25 0 144m 26m 9032 S 0 0.2 0:53.03 emagent
14517 oracle 15 0 361m 26m 24m S 0 0.2 0:00.03 oracle
31670 oracle 16 0 362m 26m 23m S 0 0.2 0:00.05 oracle
3088 oracle 15 0 361m 25m 24m S 0 0.2 0:00.07 oracle
14095 oracle 16 0 361m 25m 23m S 0 0.2 0:00.03 oracle
31635 oracle 16 0 361m 24m 22m S 0 0.2 0:00.03 oracle
457 oracle 16 0 361m 23m 22m S 0 0.1 0:00.30 oracle
551 oracle 16 0 362m 23m 21m S 0 0.1 0:00.04 oracle
559 oracle 16 0 362m 23m 21m S 0 0.1 0:00.04 oracle
31631 oracle 16 0 365m 23m 20m S 0 0.1 0:06.77 oracle
31158 oracle 16 0 361m 23m 21m S 0 0.1 0:00.03 oracle
2272 oracle 16 0 361m 22m 21m S 0 0.1 0:00.02 oracle
31107 oracle 16 0 365m 22m 19m S 0 0.1 0:05.52 oracle
-
why do you think all your memory is being used up by Oracle?
Jeff Hunter
-
The top command.
top - 12:23:22 up 7 days, 15:49, 2 users, load average: 0.04, 0.03, 0.00
Tasks: 197 total, 1 running, 196 sleeping, 0 stopped, 0 zombie
Cpu(s): 0.1% us, 0.1% sy, 0.0% ni, 99.8% id, 0.0% wa, 0.0% hi, 0.0% si
Mem: 16633368k total, 15957772k used, 675596k free, 95200k buffers
Swap: 4096532k total, 72768k used, 4023764k free, 15206652k cached
see the detail in my post
-
Can you confirm again with vmstat?
"What is past is PROLOGUE"
-
[oracle@dbdev bdump]$ vmstat
procs -----------memory---------- ---swap-- -----io---- --system-- ----cpu----
r b swpd free buff cache si so bi bo in cs us sy id wa
0 0 72076 194316 96752 15679120 0 0 100 744 15 11 4 1 95 1
-
you need to learn about shared memory and how top misrepresents it
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|