Oracleのcommitが終わらない sql*plussql1000table500commit1commit tableblob commit dba table osdatabase commit commitcommit 100commit * * * windows server 2008R2 Oracle Database 11gR2

sqlplus
...

* * *

sqlplussqlplus


SQL> SELECT * FROM V$SESSION WHERE PROGRAM='sqlplus.exe';




SQL...


SQL> SELECT S.*, Q.SQL_TEXT FROM V$SESSION S, V$SQL Q WHERE PROGRAM = 'sqlplus.exe' AND S.SQL_ID = Q.SQL_ID;


sqlplus

SQLSIDSERIAL#


SQL> ALTER SYSTEM KILL SESSION 'SID,SERIAL#';







SQL> SELECT * FROM V$SESSION WHERE PROGRAM='sqlplus.exe';


...



* * *