orcale-查询所有的会话，并返回结束会话语句

SELECT  distinct 'ALTER SYSTEM KILL SESSION '''||sid||','|| serial#||''';' from (
    SELECT s.sid, s.serial#, s.username, s.schemaname, s.osuser, s.process, s.machine,
           s.terminal, s.logon_time, l.type
    FROM v$session s, v$lock l,v$locked_object a, dba_objects b

    WHERE s.SID = l.sid and s.SID=a.SESSION_ID and a.OBJECT_ID=b.OBJECT_ID
      AND s.username IS NOT NULL
    ORDER BY sid);

查询某一时间的数据快照

select *
from APSSC.TMPFK01 as of timestamp to_timestamp('2024-03-18 18:35:41', 'yyyy-mm-dd hh24:mi:ss');