5:01pm up 6:04, 1 user, load average: 9.99, 9.73, 9.80
209 processes: 190 sleeping, 19 running, 0 zombie, 0 stopped
CPU0 states: 96.1% user, 3.3% system, 0.0% nice, 0.0% idle
CPU1 states: 94.3% user, 5.2% system, 0.0% nice, 0.0% idle
Mem: 3089788K av, 3084688K used, 5100K free, 299000K shrd, 58312K buff
Swap: 2096440K av, 0K used, 2096440K free 2466988K cachedPID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME COMMAND
1300 oracle 17 0 122M 121M 120M S 25.4 4.0 3:23 oracle
1141 root 39 0 130M 130M 30328 S 22.1 4.3 3:17 java
1288 oracle 23 0 122M 122M 120M S 20.3 4.0 3:10 oracle
1246 oracle 18 0 121M 120M 119M S 19.8 3.9 3:10 oracle
1298 oracle 18 0 121M 121M 119M S 15.4 4.0 3:10 oracle
1296 oracle 16 0 122M 121M 120M S 9.6 4.0 3:14 oracle
1292 oracle 15 0 120M 120M 118M S 8.1 3.9 3:06 oracle
1311 oracle 15 0 121M 120M 119M S 7.9 3.9 3:06 oracle
1303 oracle 15 0 122M 121M 120M S 7.8 4.0 3:10 oracle
1307 oracle 17 0 122M 121M 120M S 7.1 4.0 3:15 oracle
1217 oracle 16 0 38976 37M 37340 S 3.4 1.2 0:09 oracle
1286 oracle 15 0 120M 120M 118M S 3.3 3.9 3:26 oracle
1761 root 15 0 130M 130M 30328 S 2.8 4.3 0:05 java
1795 root 15 0 130M 130M 30328 S 2.4 4.3 0:04 java
1857 root 15 0 130M 130M 30328 S 2.4 4.3 0:04 java
2012 root 15 0 130M 130M 30328 S 2.3 4.3 0:00 java
1770 root 15 0 130M 130M 30328 S 2.1 4.3 0:07 java
1901 root 15 0 130M 130M 30328 S 1.9 4.3 0:05 java
1700 root 15 0 130M 130M 30328 S 1.8 4.3 0:05 java
1735 root 15 0 130M 130M 30328 S 1.6 4.3 0:05 java
1783 root 15 0 130M 130M 30328 S 1.6 4.3 0:06 java
1356 oracle 16 0 49280 47M 47700 S 1.4 1.5 0:10 oracle
1791 root 15 0 130M 130M 30328 S 1.4 4.3 0:07 java
1883 root 16 0 130M 130M 30328 R 1.4 4.3 0:04 java
1680 root 15 0 130M 130M 30328 S 1.3 4.3 0:06 java
1632 root 15 0 130M 130M 30328 S 1.1 4.3 0:06 java
1841 root 15 0 130M 130M 30328 S 1.1 4.3 0:04 java
1768 root 15 0 130M 130M 30328 S 0.9 4.3 0:06 java
1875 root 15 0 130M 130M 30328 S 0.9 4.3 0:05 java
1895 root 15 0 130M 130M 30328 S 0.9 4.3 0:04 java
1927 root 15 0 130M 130M 30328 S 0.9 4.3 0:04 java
2032 root 15 0 130M 130M 30328 S 0.9 4.3 0:00 java
1881 root 15 0 130M 130M 30328 S 0.8 4.3 0:05 java
........
ORACLE
Total System Global Area 1074862160 bytes
Fixed Size 452688 bytes
Variable Size 939524096 bytes
Database Buffers 134217728 bytes
Redo Buffers 667648 bytes
打开服务的页面很快,但查询结果很慢,过了比较长的时间后,JAVA占用了大部分CPU,页面其本打不开.
请高手帮我分析一下,这到底是怎么回事(用户数比较多)
209 processes: 190 sleeping, 19 running, 0 zombie, 0 stopped
CPU0 states: 96.1% user, 3.3% system, 0.0% nice, 0.0% idle
CPU1 states: 94.3% user, 5.2% system, 0.0% nice, 0.0% idle
Mem: 3089788K av, 3084688K used, 5100K free, 299000K shrd, 58312K buff
Swap: 2096440K av, 0K used, 2096440K free 2466988K cachedPID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME COMMAND
1300 oracle 17 0 122M 121M 120M S 25.4 4.0 3:23 oracle
1141 root 39 0 130M 130M 30328 S 22.1 4.3 3:17 java
1288 oracle 23 0 122M 122M 120M S 20.3 4.0 3:10 oracle
1246 oracle 18 0 121M 120M 119M S 19.8 3.9 3:10 oracle
1298 oracle 18 0 121M 121M 119M S 15.4 4.0 3:10 oracle
1296 oracle 16 0 122M 121M 120M S 9.6 4.0 3:14 oracle
1292 oracle 15 0 120M 120M 118M S 8.1 3.9 3:06 oracle
1311 oracle 15 0 121M 120M 119M S 7.9 3.9 3:06 oracle
1303 oracle 15 0 122M 121M 120M S 7.8 4.0 3:10 oracle
1307 oracle 17 0 122M 121M 120M S 7.1 4.0 3:15 oracle
1217 oracle 16 0 38976 37M 37340 S 3.4 1.2 0:09 oracle
1286 oracle 15 0 120M 120M 118M S 3.3 3.9 3:26 oracle
1761 root 15 0 130M 130M 30328 S 2.8 4.3 0:05 java
1795 root 15 0 130M 130M 30328 S 2.4 4.3 0:04 java
1857 root 15 0 130M 130M 30328 S 2.4 4.3 0:04 java
2012 root 15 0 130M 130M 30328 S 2.3 4.3 0:00 java
1770 root 15 0 130M 130M 30328 S 2.1 4.3 0:07 java
1901 root 15 0 130M 130M 30328 S 1.9 4.3 0:05 java
1700 root 15 0 130M 130M 30328 S 1.8 4.3 0:05 java
1735 root 15 0 130M 130M 30328 S 1.6 4.3 0:05 java
1783 root 15 0 130M 130M 30328 S 1.6 4.3 0:06 java
1356 oracle 16 0 49280 47M 47700 S 1.4 1.5 0:10 oracle
1791 root 15 0 130M 130M 30328 S 1.4 4.3 0:07 java
1883 root 16 0 130M 130M 30328 R 1.4 4.3 0:04 java
1680 root 15 0 130M 130M 30328 S 1.3 4.3 0:06 java
1632 root 15 0 130M 130M 30328 S 1.1 4.3 0:06 java
1841 root 15 0 130M 130M 30328 S 1.1 4.3 0:04 java
1768 root 15 0 130M 130M 30328 S 0.9 4.3 0:06 java
1875 root 15 0 130M 130M 30328 S 0.9 4.3 0:05 java
1895 root 15 0 130M 130M 30328 S 0.9 4.3 0:04 java
1927 root 15 0 130M 130M 30328 S 0.9 4.3 0:04 java
2032 root 15 0 130M 130M 30328 S 0.9 4.3 0:00 java
1881 root 15 0 130M 130M 30328 S 0.8 4.3 0:05 java
........
ORACLE
Total System Global Area 1074862160 bytes
Fixed Size 452688 bytes
Variable Size 939524096 bytes
Database Buffers 134217728 bytes
Redo Buffers 667648 bytes
打开服务的页面很快,但查询结果很慢,过了比较长的时间后,JAVA占用了大部分CPU,页面其本打不开.
请高手帮我分析一下,这到底是怎么回事(用户数比较多)
就一条这个就占了21.5%的CPU
java_pool_size big integer 16777216
large_pool_size big integer 134217728
这Variable Size 的值和上面三个相加的值相差太大了
SQL> @ ORACLE_HOME/rdbms/admin/spcreate
我换成了LINUX下的实际路径:@ opt/ora9/product/9.2/rdbms/admin/spcreate.sql
或@ opt/ora9/product/9.2/rdbms/admin/spcreate
我都试过了,都不行.....
SP2-0310: 无法打开文件"/opt/ora9/product/9.2/rdbms/admin/spcreate.sql"
SQL>