自动杀执行时间超过1小时的会话
--CREATE LOG TABLE
CREATE TABLE KILL_SESS_HIST AS SELECT S.*,T.START_TIME
FROM V$TRANSACTION T,V$SESSION S
WHERE S.TADDR=T.ADDR AND T.START_TIME
--CREATE LOG TABLE
CREATE TABLE KILL_SESS_HIST AS SELECT S.*,T.START_TIME
FROM V$TRANSACTION T,V$SESSION S
WHERE S.TADDR=T.ADDR AND T.START_TIME