查找CPU 过高

AIX Version 5
(C) Copyrights by IBM and by others 1982, 2005.
login: oracle
oracle's Password:
*******************************************************************************
*                                                                             *
*                                                                             *
*  Welcome to AIX Version 5.3!                                                *
*                                                                             *
*                                                                             *
*  Please see the README file in /usr/lpp/bos for information pertinent to    *
*  this release of the AIX Operating System.                                  *
*                                                                             *
*                                                                             *
*******************************************************************************
Last unsuccessful login: Mon Apr  2 16:12:18 BEIST 2007 on /dev/pts/0 from 10.158.250.123
Last login: Sun Sep  2 04:38:28 BEIST 2007 on ftp from ::ffff:10.158.250.56

qdyxora01:/oracle$ cd shell
qdyxora01:/oracle/shell$ /check_lock.sh
ksh: /check_lock.sh:  not found.
qdyxora01:/oracle/shell$ ./check_lock.sh

Session altered.


USER_NA OWNER  OBJECT_NAME       OBJECT_TYPE           SID    SERIAL# LOGON_TIME          SQL_TEXT
------- ------ ----------------- ----------------- ------- ---------- ------------------- ----------------------------------------------------------------
YYKF    DLYX   B_BSDLXX          TABLE                 199      46396 2007-09-02 15:08:34 SELECT * FROM B_DLXX WHERE LJBM LIKE :B2 ||'_' AND GLCDBH=:B1 AN
YYKF    DLYX   B_BSDLXX          TABLE                 199      46396 2007-09-02 15:08:34 D JFLX='??'
YYKF    DLYX   B_CBCZT           TABLE                 199      46396 2007-09-02 15:08:34 SELECT * FROM B_DLXX WHERE LJBM LIKE :B2 ||'_' AND GLCDBH=:B1 AN
YYKF    DLYX   B_CBCZT           TABLE                 199      46396 2007-09-02 15:08:34 D JFLX='??'
YYKF    DLYX   B_DFLC            TABLE                 199      46396 2007-09-02 15:08:34 SELECT * FROM B_DLXX WHERE LJBM LIKE :B2 ||'_' AND GLCDBH=:B1 AN
YYKF    DLYX   B_DFLC            TABLE                 199      46396 2007-09-02 15:08:34 D JFLX='??'
YYKF    DLYX   B_DFXX            TABLE                 199      46396 2007-09-02 15:08:34 SELECT * FROM B_DLXX WHERE LJBM LIKE :B2 ||'_' AND GLCDBH=:B1 AN
YYKF    DLYX   B_DFXX            TABLE                 199      46396 2007-09-02 15:08:34 D JFLX='??'
YYKF    DLYX   B_DLXX            TABLE                 199      46396 2007-09-02 15:08:34 SELECT * FROM B_DLXX WHERE LJBM LIKE :B2 ||'_' AND GLCDBH=:B1 AN
YYKF    DLYX   B_DLXX            TABLE                 199      46396 2007-09-02 15:08:34 D JFLX='??'
YYKF    DLYX   B_ERRLOG          TABLE                 199      46396 2007-09-02 15:08:34 SELECT * FROM B_DLXX WHERE LJBM LIKE :B2 ||'_' AND GLCDBH=:B1 AN
YYKF    DLYX   B_ERRLOG          TABLE                 199      46396 2007-09-02 15:08:34 D JFLX='??'
YYKF    DLYX   B_JBDFJSXX        TABLE                 199      46396 2007-09-02 15:08:34 SELECT * FROM B_DLXX WHERE LJBM LIKE :B2 ||'_' AND GLCDBH=:B1 AN
YYKF    DLYX   B_JBDFJSXX        TABLE                 199      46396 2007-09-02 15:08:34 D JFLX='??'
YYKF    DLYX   B_JLZZXX          TABLE                 199      46396 2007-09-02 15:08:34 SELECT * FROM B_DLXX WHERE LJBM LIKE :B2 ||'_' AND GLCDBH=:B1 AN
YYKF    DLYX   B_JLZZXX          TABLE                 199      46396 2007-09-02 15:08:34 D JFLX='??'

16 rows selected.


alter system kill session '199,46396';

Sun Sep 2 15:10:23 BEIST 2007                                          2007-09-02 15:10:23

qdyxora01:/oracle/shell$ r
./check_lock.sh

Session altered.


USER_NA OWNER  OBJECT_NAME       OBJECT_TYPE           SID    SERIAL# LOGON_TIME          SQL_TEXT
------- ------ ----------------- ----------------- ------- ---------- ------------------- ----------------------------------------------------------------
YYKF    DLYX   B_BSDLXX          TABLE                 199      46396 2007-09-02 15:08:34 SELECT * FROM B_DLXX WHERE LJBM LIKE :B2 ||'_' AND GLCDBH=:B1 AN
YYKF    DLYX   B_BSDLXX          TABLE                 199      46396 2007-09-02 15:08:34 D JFLX='??'
YYKF    DLYX   B_CBCZT           TABLE                 199      46396 2007-09-02 15:08:34 SELECT * FROM B_DLXX WHERE LJBM LIKE :B2 ||'_' AND GLCDBH=:B1 AN
YYKF    DLYX   B_CBCZT           TABLE                 199      46396 2007-09-02 15:08:34 D JFLX='??'
YYKF    DLYX   B_DFLC            TABLE                 199      46396 2007-09-02 15:08:34 SELECT * FROM B_DLXX WHERE LJBM LIKE :B2 ||'_' AND GLCDBH=:B1 AN
YYKF    DLYX   B_DFLC            TABLE                 199      46396 2007-09-02 15:08:34 D JFLX='??'
YYKF    DLYX   B_DFXX            TABLE                 199      46396 2007-09-02 15:08:34 SELECT * FROM B_DLXX WHERE LJBM LIKE :B2 ||'_' AND GLCDBH=:B1 AN
YYKF    DLYX   B_DFXX            TABLE                 199      46396 2007-09-02 15:08:34 D JFLX='??'
YYKF    DLYX   B_DLXX            TABLE                 199      46396 2007-09-02 15:08:34 SELECT * FROM B_DLXX WHERE LJBM LIKE :B2 ||'_' AND GLCDBH=:B1 AN
YYKF    DLYX   B_DLXX            TABLE                 199      46396 2007-09-02 15:08:34 D JFLX='??'
YYKF    DLYX   B_ERRLOG          TABLE                 199      46396 2007-09-02 15:08:34 SELECT * FROM B_DLXX WHERE LJBM LIKE :B2 ||'_' AND GLCDBH=:B1 AN
YYKF    DLYX   B_ERRLOG          TABLE                 199      46396 2007-09-02 15:08:34 D JFLX='??'
YYKF    DLYX   B_JBDFJSXX        TABLE                 199      46396 2007-09-02 15:08:34 SELECT * FROM B_DLXX WHERE LJBM LIKE :B2 ||'_' AND GLCDBH=:B1 AN
YYKF    DLYX   B_JBDFJSXX        TABLE                 199      46396 2007-09-02 15:08:34 D JFLX='??'
YYKF    DLYX   B_JLZZXX          TABLE                 199      46396 2007-09-02 15:08:34 SELECT * FROM B_DLXX WHERE LJBM LIKE :B2 ||'_' AND GLCDBH=:B1 AN
YYKF    DLYX   B_JLZZXX          TABLE                 199      46396 2007-09-02 15:08:34 D JFLX='??'

16 rows selected.


alter system kill session '199,46396';

Sun Sep 2 15:10:36 BEIST 2007                                          2007-09-02 15:10:36

qdyxora01:/oracle/shell$ r
./check_lock.sh

Session altered.


no rows selected


no rows selected

Sun Sep 2 15:11:03 BEIST 2007                                          2007-09-02 15:11:03

qdyxora01:/oracle/shell$ topas

Topas Monitor for host:    qdyxora01            EVENTS/QUEUES    FILE/TTY
Sun Sep  2 15:11:21 2007   Interval:  2         Cswitch          Readch
                                                Syscall          Writech
Kernel          |                            |  Reads            Rawin
User            |                            |  Writes           Ttyout
Wait            |                            |  Forks            Igets
Idle            |                            |  Execs            Namei
                                                Runqueue         Dirblk
Network  KBPS   I-Pack  O-Pack   KB-In  KB-Out  Waitqueue

                                                PAGING           MEMORY
                                                Faults           Real,MB
                                                Steals           % Comp
Disk    Busy%     KBPS     TPS KB-Read KB-Writ  PgspIn           % Noncomp
                                                PgspOut          % Client
                                                PageIn
                                                PageOut          PAGING SPACE
                                                Sios             Size,MB
                                                                 % Used
                                                NFS (calls/sec)  % Free
                                                ServerV2
                                                ClientV2           Press:
                                                ServerV3           "h" for help
                                                ClientV3           "q" to quit

 

 

 

 

 

 

 

 

 

 

 

Topas Monitor for host:    qdyxora01            EVENTS/QUEUES    FILE/TTY
Sun Sep  2 15:11:49 2007   Interval:  2         Cswitch    2218  Readch  1009.4K
                                                Syscall   18284  Writech    4945
Kernel    2.2   |#                           |  Reads       313  Rawin         0
User     12.3   |####                        |  Writes       54  Ttyout     1151
Wait      6.4   |##                          |  Forks        14  Igets         0
Idle     79.2   |#######################     |  Execs        14  Namei       609
                                                Runqueue    1.0  Dirblk        0
Network  KBPS   I-Pack  O-Pack   KB-In  KB-Out  Waitqueue   0.0
en5     146.8    319.8   260.5    66.1    80.7
en4      16.0     32.9    32.9    10.9     5.1  PAGING           MEMORY
lo0       0.3      4.0     4.0     0.1     0.1  Faults     2825  Real,MB    7744
                                                Steals        0  % Comp     55.0
Disk    Busy%     KBPS     TPS KB-Read KB-Writ  PgspIn        0  % Noncomp  45.6
hdisk2   52.3   1470.0   103.1   870.7   599.3  PgspOut       0  % Client   46.5
dac0      0.0   1470.0   103.1   870.7   599.3  PageIn        0
dac0-utm  0.0      0.0     0.0     0.0     0.0  PageOut       0  PAGING SPACE
hdisk1    0.0      0.0     0.0     0.0     0.0  Sios          0  Size,MB    8192
hdisk0    0.0      0.0     0.0     0.0     0.0                   % Used     37.5
cd0       0.0      0.0     0.0     0.0     0.0  NFS (calls/sec)  % Free     62.4
hdisk3    0.0      0.0     0.0     0.0     0.0  ServerV2       0
hdisk4    0.0      0.0     0.0     0.0     0.0  ClientV2       0   Press:
                                                ServerV3       0   "h" for help
Name            PID  CPU%  PgSp Owner           ClientV3       0   "q" to quit
oracle      1204678  11.6   5.3 oracle
oracle       925784   0.2  19.8 oracle
topas        995534   0.2   2.5 oracle
topas        250128   0.2   4.1 root 
oracle       950396   0.1  18.3 oracle
oracle      1503576   0.1  18.2 oracle
oracle      1507598   0.1  17.8 oracle
oracle      1487292   0.1  18.2 oracle
gil           28972   0.0   0.1 root 
ocssd.bi    1364214   0.0  26.6 oracle
sh           655414   0.0   0.5 root 
oracle       827588   0.0   4.6 oracle
racgimon     790710   0.0  53.8 oracle
oracle      1515944   0.0  59.8 oracle
oracle      1302640   0.0   4.1 oracle
hats_rs2     303568   0.0   1.7 root 
oracle      1187876   0.0   3.9 oracle
sched          4384   0.0   0.1 root 
oracle      1306754   0.0  18.8 oracle
oclsomon     258416   0.0   6.9 oracle
oracle      1544700   0.0   8.9 oracle
oracle      1040436   0.0   4.1 oracle
clcomd       147650   0.0   1.9 root 
Signal 2 received

qdyxora01:/oracle/shell$ ./check_lock.sh

Session altered.


USER_NA OWNER  OBJECT_NAME       OBJECT_TYPE           SID    SERIAL# LOGON_TIME          SQL_TEXT
------- ------ ----------------- ----------------- ------- ---------- ------------------- ----------------------------------------------------------------
CTI     CTI    O_3_OBJ_DIM       TABLE                 254      42161 2007-09-02 15:11:02 delete from T_18_TIME_DIM where TIME_KEY between :1 and :2
CTI     CTI    R_18_STAT_RES     TABLE                 254      42161 2007-09-02 15:11:02 delete from T_18_TIME_DIM where TIME_KEY between :1 and :2
CTI     CTI    T_18_TIME_DIM     TABLE                 254      42161 2007-09-02 15:11:02 delete from T_18_TIME_DIM where TIME_KEY between :1 and :2


no rows selected

Sun Sep 2 15:11:58 BEIST 2007                                          2007-09-02 15:11:58

qdyxora01:/oracle/shell$ r
./check_lock.sh

Session altered.


no rows selected


no rows selected

Sun Sep 2 15:12:09 BEIST 2007                                          2007-09-02 15:12:09

qdyxora01:/oracle/shell$ r
./check_lock.sh

Session altered.


no rows selected


no rows selected

Sun Sep 2 15:12:17 BEIST 2007                                          2007-09-02 15:12:17

qdyxora01:/oracle/shell$ r
./check_lock.sh

Session altered.


no rows selected


no rows selected

Sun Sep 2 15:16:02 BEIST 2007                                          2007-09-02 15:16:02

qdyxora01:/oracle/shell$
qdyxora01:/oracle/shell$  

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值