|
L_HASH_VALUE from v$session where sid =''''&sid'''')
new 3: (select SQL_HASH_VALUE from v$session where sid =''''71'''')
SQL_TEXT
----------------------------------------------------------------
INSERT INTO WAP_AUTHPRICE_USER_SP_RD (LOCATIONID,ICPID,SUBSCAT
,ICPATTR,ICPCODE,COUNTS,PERIOD,STAT_TIME) VALUES (:LOCATIONID,:I
CPID,:SUBSCAT,:ICPATTR,:ICPCODE,:COUNTS,:PERIOD,TO_DATE(:STAT_TI
ME,''''yyyy-mm-dd hh24:mi:ss''''))
于是想到，首先kill这个sid，试试看：
SQL> alter system kill session ''''71,20979'''';
alter system kill session ''''71,20979''''
*
ERROR at line 1:
ORA-00030: User session ID does not exist.
SQL> select sid,serial# from v$session where sid=71;
SID SERIAL#
------ -------
71 20986
SQL> /
SID SERIAL#
------ -------
71 20986
SQL> /
SID SERIAL#
------ -------
71 20986
SQL> alter system kill session ''''71,20986'''';
alter system kill session ''''71,20986''''
*
ERROR at line 1:
ORA-00030: User session ID does not exist.
SQL> select sid,serial# from v$session where sid=71;
SID SERIAL#
------ -------
71 20988
SQL> alter system kill session ''''71,20988'''';
alter system kill session ''''71,20988''''
*
ERROR at line 1:
ORA-00030: User session ID does not exist.
SQL>
可见，这个sid根本就不是一个正常的会话，不能被kill。
上一页 [1] [2]
没有相关教程
| 
注：本站部分文章源于互联网，版权归原作者所有！如有侵权，请原作者与本站联系，本站将立即删除！ 本站文章除特别注明外均可转载，但需注明出处！ [MinTao学以致用网] 
