今天发现ORACLE主机的CPU比较高,登上主机查看下,发现大量的oracle 进程总是在new和died,
不知道是什么原因?
1、Oracle 版本
SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bi
PL/SQL Release 10.2.0.2.0 - Production
CORE10.2.0.2.0Production
TNS for HPUX: Version 10.2.0.2.0 - Production
NLSRTL Version 10.2.0.2.0 - Production
2、抓的oracle的进程情况
oraclebl1
11479 oracle 37.9 1 0.3 8.0mb 11.8mbdied
oraclebl1
11551 oracle 35.4 1 0.088.3mb 88.3mbdied
oraclebl1
11461 oracle 30.7 1 0.3 1.3mb2.6mbdied
oraclebl1
11569 oracle 29.5 1 0.0 8.1mb 11.9mb new
oraclebl1
11559 oracle 27.4 150.088.6mb 88.6mb new
oraclebl1
11553 oracle 24.4 1 0.088.3mb 88.3mbdied
oraclebl1
11471 oracle 23.4 1 0.0 2.6mb3.3mbdied
oraclebl1
11507 oracle 23.2 1 0.3 8.0mb 11.8mbdied
oraclebl1
11565 oracle 23.2 1 0.3 2.5mb2.6mbdied
oraclebl1
11547 oracle 23.2 1 0.388.3mb 88.3mbdied
oraclebl1
11485 oracle 23.2 1 0.0 8.0mb 11.8mbdied
oraclebl1
11541 oracle 23.0 1 0.388.3mb 88.3mbdied
oraclebl1
11545 oracle 23.0 1 0.388.3mb 88.3mbdied
oraclebl1
11584 oracle 20.2 1 0.0 8.0mb 11.8mb new
oraclebl1
11458 oracle 18.5 1 0.3 8.0mb 11.8mbdied
oraclebl1
11430 oracle 16.2 1 0.0 2.6mb2.6mbdied
oraclebl1
10787 oracle 15.8 155.393.2mb 93.7mb STRMS
oraclebl1
11452 oracle 11.8 1 0.0 1.5mb2.6mbdied
3、通过下面语句,想抓下这些进程的相关信息,可惜总是抓不到
SELECT b.sid,a.pid, a.spid, a.username, b.machine, b.user#, b.username
FROM v$process a
JOIN v$session b
ON a.addr = b.paddr
WHERE a.spid = (&pid);
|