baidu_25374645的专栏

1.SELECT WHAT,INTERVAL,LAST_DATE,NEXT_DATE,JOB,BROKEN FROM DBA_JOBS ORDER BY 1; 2.如BROKEN=N    BEGIN DBMS_JOB.NEXT_DATE(3, SYSDATE+(5/24/60/60));END;    BEGIN DBMS_JOB.NEXT_DATE(10,SYSDATE+(5/2

1.锁表查询:SELECT object_name, machine, s.sid, s.serial# FROM gv$locked_object l, dba_objects o, gv$session s WHERE l.object_id　= o.object_id AND l.session_id = s.sid; 2.释放SESSION SQL: --alter sy