session A执行sql的过程中,在session B发出命令:kill -23 4
[oracle@dw1 scripts]$ sqlplus "/as sysdba"SQL*Plus: Release 11.2.0.3.0Production on Mon Oct 2108:59:202013Copyright (c) 1982, 2011, Oracle. All rights reserved.Connected to:Oracle Database 11g Enterprise Edition Release 11.2.0.3.0- 64bit ProductionWith the Partitioning, Automatic Storage Management, Data Mining and Real Application Testing optionsSQL> @myspid2;SPID------------------------4048SQL> select * from dba_objects;OWNER------------------------------OBJECT_NAME--------------------------------------------------------------------------------SUBOBJECT_NAME OBJECT_ID DATA_OBJECT_ID OBJECT_TYPE------------------------------ ---------- -------------- -------------------CREATED LAST_DDL_ TIMESTAMP STATUS T G S NAMESPACE--------- --------- ------------------- ------- - - - ----------EDITION_NAME------------------------------SYSICOL$202TABLEOWNER------------------------------OBJECT_NAME--------------------------------------------------------------------------------SUBOBJECT_NAME OBJECT_ID DATA_OBJECT_ID OBJECT_TYPE------------------------------ ---------- -------------- -------------------CREATED LAST_DDL_ TIMESTAMP STATUS T G S NAMESPACE--------- --------- ------------------- ------- - - - ----------EDITION_NAME------------------------------17-SEP-1117-SEP-112011-09-17:09:46:13VALID N N N 1…………ERROR:ORA-01013: user requested cancel of current operation