Oracle Database Discussions

It is a 9.2.0.8 RAC system, two nodes.

from the top command I got a tns v3-v1 process used 8G memory. It is terrible.

top
top - 18:01:36 up 5 days, 12:48, 6 users, load average: 1.65, 1.51, 1.38
Tasks: 429 total, 2 running, 427 sleeping, 0 stopped, 0 zombie
Cpu(s): 5.4% us, 0.1% sy, 0.0% ni, 94.2% id, 0.3% wa, 0.0% hi, 0.0% si
Mem: 16434664k total, 16385160k used, 49504k free, 45916k buffers
Swap: 32764556k total, 178796k used, 32585760k free, 14819044k cached

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
*25547 oracle 16 0 10.1g 8.0g 8.0g S 0.0 51.2 102:56.77 oracle*
14226 oracle 15 0 10.1g 7.8g 7.8g S 0.3 50.0 24:00.35 oracle
14220 oracle 15 0 10.1g 7.8g 7.8g S 0.0 50.0 23:46.18 oracle
14222 oracle 15 0 10.1g 7.8g 7.8g S 0.0 49.9 23:58.01 oracle
14224 oracle 15 0 10.1g 7.8g 7.8g S 0.3 49.9 23:34.31 oracle
14256 oracle 16 0 10.1g 6.7g 6.7g S 0.0 42.5 102:21.68 oracle
14228 oracle 16 0 10.1g 4.5g 4.5g S 0.0 28.6 20:57.93 oracle
14230 oracle 16 0 10.1g 4.5g 4.5g S 0.0 28.6 20:08.78 oracle
29176 oracle 16 0 10.1g 3.1g 3.1g S 0.0 19.9 3:18.72 oracle
13955 oracle 16 0 10.1g 2.6g 2.6g S 0.0 16.8 3:34.84 oracle
17937 oracle 16 0 10.1g 2.1g 2.1g S 0.0 13.2 3:12.43 oracle
13639 oracle 15 0 10.1g 2.0g 2.0g S 0.0 12.6 2:36.38 oracle
15604 oracle 16 0 10.1g 2.0g 2.0g R 70.2 12.5 1031:47 oracle
15606 oracle 16 0 10.1g 1.9g 1.9g S 0.0 12.0 4:36.14 oracle
32638 oracle 15 0 10.1g 1.9g 1.9g S 0.0 11.8 2:16.91 oracle
27077 oracle 15 0 10.1g 1.8g 1.8g S 10.3 11.6 246:07.85 oracle
32744 oracle 15 0 10.1g 1.5g 1.5g S 0.0 9.8 3:27.26 oracle
25757 oracle 15 0 10.1g 1.4g 1.4g S 0.3 8.9 1:33.38 oracle
1567 oracle 15 0 10.1g 1.3g 1.3g S 0.3 8.3 0:41.01 oracle
1563 oracle 15 0 10.1g 1.2g 1.2g S 0.0 8.0 0:43.20 oracle
1559 oracle 15 0 10.1g 1.2g 1.2g S 0.0 7.8 1:15.43 oracle
1565 oracle 15 0 10.1g 1.1g 1.1g S 4.6 7.2 82:49.04 oracle
29473 oracle 15 0 10.1g 1.0g 1.0g S 0.0 6.3 0:40.38 oracle

from the top 'M' command I got the ps list order by memory usage.
There is a process 25547 use 50% of the physical memory 8G.

but from the V$PROCESS
SELECT * FROM v$process where spid=25547;

ADDR PID SPID USERNAME SERIAL# TERMINAL PROGRAM
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
00000017D7C956B0 134 25547 oracle 9 UNKNOWN oracle@Ora01 (TNS V1-V3)


and the program name is (TNS v1-v3)

the memory it use in PGA

PGA_USED_MEM PGA_ALLOC_MEM PGA_FREEABLE_MEM PGA_MAX_MEM
-----------------------------------------------------------------------------------------------------
0 1106749 131072 1106749

is not as much as I saw in the top output.

So how to identify the problem? Is it bind to a session?

And why the PGA_USED_MEM is so little.

Thanks.

Edited by: James yan on Dec 27, 2008 7:32 AM

Edited by: James yan on Dec 27, 2008 7:34 AM