2010年4月27日
大港-范德军(26517309) 16:47:47
刚才，哪位仁兄让我杀进程了（大港）
兰马-高宇(56611638) 16:48:42
大港的数据库 死进程 杀完后，请给我个消息
大港-范德军(26517309) 16:48:59
已经杀完了
大港-范德军(26517309) 16:49:05
你现在试试
兰马-高宇(56611638) 16:49:36
谢谢
SQL> select username,sid,serial# from v$session;
USERNAME SID SERIAL#
------------------------------ ---------- ----------
1 1
2 1
3 1
4 1
5 1
6 1
EDMADMIN 7 12
9 1
10 1
EDMADMIN 12 38599
SYN_INT 15 280
USERNAME SID SERIAL#
------------------------------ ---------- ----------
SYS 16 25180
EDMADMIN 17 52410
EDMADMIN 23 42645
SYN_INT 25 58311
EDMADMIN 26 33260
SYN_INT 27 21105
SYN_INT 29 64648
SYNUSER 30 25890
SYN_INT 31 46010
EDMADMIN 32 56242
SYN_INT 36 31390
22 rows selected.
SQL> alter system kill session 15,280;
alter system kill session 15,280
*
ERROR at line 1:
ORA-00026: missing or invalid session ID
SQL> select pro.spid from v$session ses,v$process pro where ses.sid=15 and ses.paddr=pro.addr;
SPID
------------
111016
SQL> select pro.spid from v$session ses,v$process pro where ses.sid=25 and ses.paddr=pro.addr;
SPID
------------
136666
SQL> select username,sid,serial# from v$session;
USERNAME SID SERIAL#
------------------------------ ---------- ----------
1 1
2 1
3 1
4 1
5 1
6 1
EDMADMIN 7 12
9 1
10 1
SYS 16 25180
EDMADMIN 17 52410
USERNAME SID SERIAL#
------------------------------ ---------- ----------
EDMADMIN 23 42645
EDMADMIN 26 33260
SYN_INT 27 21105
SYN_INT 29 64648
SYNUSER 30 25890
SYN_INT 31 46010
EDMADMIN 32 56242
18 rows selected.
SQL> select pro.spid from v$session ses,v$process pro where ses.sid=27 and ses.paddr=pro.addr;
SPID
------------
116438
SQL> select pro.spid from v$session ses,v$process pro where ses.sid=29 and ses.paddr=pro.addr;
SPID
------------
137654
SQL> select pro.spid from v$session ses,v$process pro where ses.sid=31 and ses.paddr=pro.addr;
SPID
------------
131690
SQL> select username,sid,serial# from v$session;
USERNAME SID SERIAL#
------------------------------ ---------- ----------
1 1
2 1
3 1
4 1
5 1
6 1
EDMADMIN 7 12
9 1
10 1
SYS 16 25180
EDMADMIN 17 52410
USERNAME SID SERIAL#
------------------------------ ---------- ----------
EDMADMIN 23 42645
EDMADMIN 26 33260
SYNUSER 30 25890
14 rows selected.
SQL> startup
ORA-01081: cannot start already-running ORACLE - shut it down first
SQL>
阅读(483) | 评论(0) | 转发(0) |
