$ sqlplus user/password@192.168.1.xxx:1521/sid
SQL> SELECT s.sid,s.serial#, s.username, s.program FROM V$SESSION s where s.username='ARCSDBSS' and s.program='python36@buffy3 (TNS V1-V3)';
SQL> select s.sid, s.serial#, s.username, s.osuser, s.machine, s.terminal, s.program, o.object_name from v$session s, v$locked_object l, dba_objects o where s.sid = l.session_id and l.object_id = o.object_id;
SQL> alter system kill session 'sid, serial#'
killedになったが切れない。
ORA-00031: session marked for kill
ALTER SYSTEM DISCONNECT SESSION 'sid,serialNo' {POST_TRANSACTION | IMMEDIATE};
ERROR at line 1:
ORA-00031: session marked for kill
すぐ返って来るけど同じだ!!!!
select spid, s.sid, s.serial#, s.status , osuser, s.program,s.username, s.event from
v$process p, v$session s where p.addr=s.paddr and s.status = 'KILLED';
列幅調整
COLUMN spid FORMAT a5 TRUNCATE
v$process p, v$session s where p.addr=s.paddr and s.status = 'KILLED';
列幅調整
COLUMN spid FORMAT a5 TRUNCATE
0 件のコメント:
コメントを投稿