linux5 +oracle10g,主要是跑数据库
最近在Pl/sql上执行创建表空间都很慢,请大家给我找找原因,分析一下。
1在Linux free -m 虚拟机分配的内存为4G
free -m
total used free shared buffers cached
Mem: 3433 3414 19 0 134 2629
-/+ buffers/cache: 650 2782
Swap: 2047 0 2047
2用top命令查看,内存使用率耗得比较大。
top - 12:08:00 up 2 days, 0 min, 1 user, load average: 4.54, 7.04, 6.94
Tasks: 181 total, 2 running, 178 sleeping, 0 stopped, 1 zombie
Cpu(s): 36.3%us, 4.0%sy, 0.0%ni, 55.7%id, 3.3%wa, 0.0%hi, 0.7%si, 0.0%st
Mem: 3515872k total, 3415076k used, 100796k free, 134564k buffers
Swap: 2097144k total, 72k used, 2097072k free, 2625356k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
18982 oracle 15 0 1108m 45m 32m S 2.3 1.3 29:41.58 oracle
13617 oracle 15 0 1108m 46m 34m S 2.0 1.3 31:18.51 oracle
7536 oracle 15 0 1110m 58m 40m S 1.0 1.7 35:02.56 oracle
1 root 15 0 2176 644 552 S 0.0 0.0 0:02.72 init
2 root RT -5 0 0 0 S 0.0 0.0 0:00.00 migration/0
3 root 34 19 0 0 0 S 0.0 0.0 0:00.12 ksoftirqd/0
4 root RT -5 0 0 0 S 0.0 0.0 0:00.00 watchdog/0
5 root 10 -5 0 0 0 S 0.0 0.0 0:26.51 events/0
6 root 10 -5 0 0 0 S 0.0 0.0 0:00.05 khelper
7 root 11 -5 0 0 0 S 0.0 0.0 0:00.00 kthread
9 root 20 -5 0 0 0 S 0.0 0.0 0:00.00 xenwatch
10 root 20 -5 0 0 0 S 0.0 0.0 0:00.00 xenbus
12 root 10 -5 0 0 0 S 0.0 0.0 0:02.97 kblockd/0
13 root 20 -5 0 0 0 S 0.0 0.0 0:00.00 kacpid
173 root 20 -5 0 0 0 S 0.0 0.0 0:00.00 cqueue/0
177 root 20 -5 0 0 0 S 0.0 0.0 0:00.00 khubd
179 root 16 -5 0 0 0 S 0.0 0.0 0:00.00 kseriod
241 root 21 0 0 0 0 S 0.0 0.0 0:00.00 khungtaskd
242 root 15 0 0 0 0 S 0.0 0.0 0:36.13 pdflush