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]