各位好:
今天有个关于oracle的问题想请教一下大家。
两台DB,后面连磁盘阵列。
都是linux as3的操作系统
上面装的是9.2.0.7.0
现在出现了很多ora_p000_sid的进程,并且占据了很多的内存空间。
具体信息如下
DB1:
[root@hostname1 root]# top
21:32:14 up 101 days, 23:53, 2 users, load average: 0.93, 1.08, 1.08
139 processes: 138 sleeping, 1 running, 0 zombie, 0 stopped
CPU states: cpu user nice system irq softirq iowait idle
total 4.9% 0.0% 0.8% 0.1% 0.3% 22.2% 71.3%
cpu00 0.7% 0.0% 0.7% 0.0% 0.0% 17.9% 80.4%
cpu01 5.0% 0.0% 0.4% 0.0% 2.4% 11.6% 80.6%
cpu02 9.2% 0.0% 2.6% 0.0% 0.2% 22.4% 65.6%
cpu03 2.2% 0.0% 0.4% 1.0% 0.2% 38.8% 57.4%
cpu04 7.1% 0.0% 0.5% 0.0% 0.0% 16.7% 75.4%
cpu05 1.7% 0.0% 0.3% 0.0% 0.0% 11.7% 86.0%
cpu06 8.4% 0.0% 1.6% 0.0% 0.0% 22.8% 67.2%
cpu07 5.3% 0.0% 0.1% 0.0% 0.0% 36.1% 58.2%
Mem: 8047604k av, 6250692k used, 1796912k free, 0k shrd, 174636k buff
3610732k actv, 1042784k in_d, 205828k in_c
Swap: 10482404k av, 0k used, 10482404k free 4660600k cached
PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME CPU COMMAND
16846 oracle 16 0 1375M 1.3G 1256M S 0.9 17.4 65:44 5 oracle
16850 oracle 16 0 1004M 1.0G 885M S 0.8 12.7 63:28 4 oracle
16852 oracle 16 0 1110M 1.1G 992M S 0.8 14.1 60:31 6 oracle
16848 oracle 16 0 1058M 1.0G 939M S 0.7 13.4 65:04 3 oracle
16854 oracle 16 0 1075M 1.0G 957M S 0.7 13.6 62:59 0 oracle
1 root 17 0 524 524 452 S 0.0 0.0 11:14 0 init
2 root RT 0 0 0 0 SW 0.0 0.0 0:00 0 migration/0
3 root RT 0 0 0 0 SW 0.0 0.0 0:00 1 migration/1
4 root RT 0 0 0 0 SW 0.0 0.0 0:00 2 migration/2
5 root RT 0 0 0 0 SW 0.0 0.0 0:00 3 migration/3
6 root RT 0 0 0 0 SW 0.0 0.0 0:00 4 migration/4
7 root RT 0 0 0 0 SW 0.0 0.0 0:00 5 migration/5
8 root RT 0 0 0 0 SW 0.0 0.0 0:00 6 migration/6
9 root RT 0 0 0 0 SW 0.0 0.0 0:00 7 migration/7
10 root 15 0 0 0 0 SW 0.0 0.0 0:00 2 keventd
11 root 34 19 0 0 0 SWN 0.0 0.0 0:00 0 ksoftirqd/0
12 root 34 19 0 0 0 SWN 0.0 0.0 0:06 1 ksoftirqd/1
[root@hostname1 root]# ps -ef | grep oracle
root 4595 4549 0 Jun19 tty1 00:00:00 su - oracle
oracle 4596 4595 0 Jun19 tty1 00:00:00 -bash
oracle 5453 1 0 Jun19 ? 00:53:43 ora_pmon_iptv1
oracle 5455 1 0 Jun19 ? 02:49:42 ora_diag_iptv1
oracle 5459 1 0 Jun19 ? 01:38:53 ora_lmon_iptv1
oracle 5461 1 0 Jun19 ? 02:56:52 ora_lmd0_iptv1
oracle 5463 1 0 Jun19 ? 09:45:52 ora_lms0_iptv1
oracle 5465 1 0 Jun19 ? 09:50:42 ora_lms1_iptv1
oracle 5467 1 0 Jun19 ? 00:10:08 ora_dbw0_iptv1
oracle 5469 1 0 Jun19 ? 00:18:43 ora_lgwr_iptv1
oracle 5471 1 0 Jun19 ? 00:30:35 ora_ckpt_iptv1
oracle 5473 1 0 Jun19 ? 00:04:38 ora_smon_iptv1
oracle 5475 1 0 Jun19 ? 00:00:04 ora_reco_iptv1
oracle 5488 1 0 Jun19 ? 00:26:21 ora_lck0_iptv1
oracle 5584 1 0 Jun19 ? 03:54:38 /oracle/product/9.2/bin/tnslsnr LISTENER -inherit
oracle 11634 1 0 Sep14 ? 00:04:26 oracleiptv1 (LOCAL=NO)
oracle 12922 1 0 Sep14 ? 00:00:49 oracleiptv1 (LOCAL=NO)
oracle 12578 1 0 Sep17 ? 00:16:38 oracleiptv1 (LOCAL=NO)
oracle 17157 1 0 Sep18 ? 00:45:31 oracleiptv1 (LOCAL=NO)
oracle 3922 1 0 Sep19 ? 00:00:00 oracleiptv1 (LOCAL=NO)
oracle 22164 1 0 Sep24 ? 00:02:48 oracleiptv1 (LOCAL=NO)
oracle 16846 1 0 Sep25 ? 01:05:45 ora_p000_iptv1
oracle 16848 1 0 Sep25 ? 01:05:05 ora_p001_iptv1
oracle 16850 1 0 Sep25 ? 01:03:29 ora_p002_iptv1
oracle 16852 1 0 Sep25 ? 01:00:32 ora_p003_iptv1
oracle 16854 1 0 Sep25 ? 01:03:01 ora_p004_iptv1
oracle 3713 1 0 Sep25 ? 00:00:11 oracleiptv1 (LOCAL=NO)
oracle 29225 1 0 Sep26 ? 00:01:18 oracleiptv1 (LOCAL=NO)
oracle 30257 1 0 Sep28 ? 00:00:00 oracleiptv1 (LOCAL=NO)
oracle 30299 1 0 Sep28 ? 00:00:00 oracleiptv1 (LOCAL=NO)
oracle 17721 1 0 Sep28 ? 00:00:18 oracleiptv1 (LOCAL=NO)
oracle 18949 1 0 Sep28 ? 00:00:00 oracleiptv1 (LOCAL=NO)
oracle 20623 1 0 Sep28 ? 00:00:00 oracleiptv1 (LOCAL=NO)
oracle 20679 1 0 Sep28 ? 00:00:00 oracleiptv1 (LOCAL=NO)
oracle 22900 1 0 Sep28 ? 00:00:03 oracleiptv1 (LOCAL=NO)
oracle 10465 1 0 Sep28 ? 00:00:08 oracleiptv1 (LOCAL=NO)
oracle 11367 1 0 Sep28 ? 00:00:01 oracleiptv1 (LOCAL=NO)
oracle 12426 1 0 Sep28 ? 00:00:00 oracleiptv1 (LOCAL=NO)
oracle 29468 1 0 09:57 ? 00:00:00 oracleiptv1 (LOCAL=NO)
oracle 31551 1 0 12:58 ? 00:00:52 oracleiptv1 (LOCAL=NO)
oracle 31577 1 0 12:58 ? 00:00:00 oracleiptv1 (LOCAL=NO)
oracle 8261 1 0 15:16 ? 00:00:00 oracleiptv1 (LOCAL=NO)
oracle 9594 1 0 15:18 ? 00:00:00 oracleiptv1 (LOCAL=NO)
oracle 15049 1 0 18:12 ? 00:00:00 oracleiptv1 (LOCAL=NO)
oracle 31665 1 0 18:28 ? 00:00:00 oracleiptv1 (LOCAL=NO)
oracle 8077 1 0 18:45 ? 00:00:00 oracleiptv1 (LOCAL=NO)
oracle 9428 1 0 18:46 ? 00:00:00 oracleiptv1 (LOCAL=NO)
oracle 23150 1 0 21:17 ? 00:00:00 oracleiptv1 (LOCAL=NO)
oracle 23308 1 0 21:24 ? 00:00:04 oracleiptv1 (LOCAL=NO)
oracle 23316 1 1 21:24 ? 00:00:06 oracleiptv1 (LOCAL=NO)
oracle 23573 1 10 21:33 ? 00:00:00 oracleiptv1 (LOCAL=NO)
root 23575 22574 0 21:33 pts/1 00:00:00 grep oracle
DB2:
[root@hostname2 root]#top
96 processes: 95 sleeping, 1 running, 0 zombie, 0 stopped
CPU states: cpu user nice system irq softirq iowait idle
total 2.3% 0.0% 0.0% 0.0% 0.0% 5.1% 92.4%
cpu00 3.2% 0.0% 0.0% 0.0% 0.2% 0.6% 96.0%
cpu01 1.6% 0.0% 0.0% 0.0% 0.0% 0.8% 97.6%
cpu02 4.0% 0.0% 0.0% 0.0% 0.0% 19.6% 76.4%
cpu03 2.2% 0.0% 0.2% 0.0% 0.0% 0.4% 97.2%
cpu04 0.0% 0.0% 0.0% 0.0% 0.0% 0.6% 99.4%
cpu05 0.0% 0.0% 0.0% 0.0% 0.0% 0.6% 99.4%
cpu06 4.0% 0.0% 0.2% 0.0% 0.0% 18.2% 77.6%
cpu07 3.4% 0.0% 0.0% 0.0% 0.0% 0.4% 96.2%
Mem: 8047604k av, 7667408k used, 380196k free, 0k shrd, 173684k buff
5299640k active, 1478336k inactive
Swap: 10482404k av, 0k used, 10482404k free 4336632k cached
PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME CPU COMMAND
26114 oracle 16 0 891M 889M 717M S 0.4 11.3 146:47 2 oracle
26116 oracle 16 0 1027M 1.0G 858M S 0.4 13.0 146:35 5 oracle
26118 oracle 16 0 918M 915M 745M S 0.4 11.6 144:37 6 oracle
26110 oracle 16 0 1077M 1.1G 907M S 0.3 13.6 148:42 0 oracle
26112 oracle 16 0 953M 951M 780M S 0.3 12.1 148:10 7 oracle
1 root 15 0 524 524 452 S 0.0 0.0 1:11 3 init
2 root RT 0 0 0 0 SW 0.0 0.0 0:00 0 migration/0
3 root RT 0 0 0 0 SW 0.0 0.0 0:00 1 migration/1
4 root RT 0 0 0 0 SW 0.0 0.0 0:00 2 migration/2
5 root RT 0 0 0 0 SW 0.0 0.0 0:00 3 migration/3
6 root RT 0 0 0 0 SW 0.0 0.0 0:00 4 migration/4
7 root RT 0 0 0 0 SW 0.0 0.0 0:00 5 migration/5
8 root RT 0 0 0 0 SW 0.0 0.0 0:00 6 migration/6
9 root RT 0 0 0 0 SW 0.0 0.0 0:00 7 migration/7
10 root 15 0 0 0 0 SW 0.0 0.0 0:00 6 keventd
11 root 34 19 0 0 0 SWN 0.0 0.0 0:02 0 ksoftirqd/0
12 root 34 19 0 0 0 SWN 0.0 0.0 0:30 1 ksoftirqd/1
[root@hostname2 root]# ps -ef | grep oracle
oracle 10538 1 0 Jun19 ? 00:43:08 ora_pmon_iptv2
oracle 10540 1 0 Jun19 ? 02:42:22 ora_diag_iptv2
oracle 10544 1 0 Jun19 ? 01:27:49 ora_lmon_iptv2
oracle 10546 1 0 Jun19 ? 23:07:28 ora_lmd0_iptv2
oracle 10548 1 6 Jun19 ? 6-11:32:08 ora_lms0_iptv2
oracle 10550 1 6 Jun19 ? 6-10:56:10 ora_lms1_iptv2
oracle 10552 1 0 Jun19 ? 00:07:54 ora_dbw0_iptv2
oracle 10554 1 0 Jun19 ? 00:05:47 ora_lgwr_iptv2
oracle 10556 1 0 Jun19 ? 00:29:46 ora_ckpt_iptv2
oracle 10558 1 0 Jun19 ? 00:03:32 ora_smon_iptv2
oracle 10560 1 0 Jun19 ? 00:00:03 ora_reco_iptv2
oracle 10573 1 0 Jun19 ? 00:23:31 ora_lck0_iptv2
oracle 10684 1 0 Jun19 ? 00:03:37 /oracle/product/9.2/bin/tnslsnr LISTENER -inherit
oracle 26110 1 2 Sep25 ? 02:28:45 ora_p000_iptv2
oracle 26112 1 2 Sep25 ? 02:28:12 ora_p001_iptv2
oracle 26114 1 2 Sep25 ? 02:26:50 ora_p002_iptv2
oracle 26116 1 2 Sep25 ? 02:26:38 ora_p003_iptv2
oracle 26118 1 2 Sep25 ? 02:24:39 ora_p004_iptv2
root 29175 29120 0 21:32 pts/1 00:00:00 grep oracle