Oracle常用存过与作业操作

PROCEDURE操作

• 调用指定PROCEDURE

EXEC 存过名(参数)

• 查看正在运行PROCEDURE

SELECT NAME,LOCKS,PINS
FROM V$DB_OBJECT_CACHE
WHERE LOCKS > 0 AND PINS > 0 AND TYPE='PROCEDURE';

• 强制关闭PROCEDURE

SELECT SID,SERIAL#,USERNAME,PROGRAM,MACHINE,STATUS FROM V$SESSION;
ALTER SYSTEM KILL SESSION 'SID,SERIAL#' ;

JOB操作

• 查询当前用户JOB

SELECT * FROM USER_JOBS;

• 查询正在运行JOB

SELECT SID,JOB FROM DBA_JOBS_RUNNING;

• 查询JOB运行日志

SELECT * FROM USER_SCHEDULER_JOB_LOG WHERE JOB_NAME = JOB名 ORDER BY LOG_ID DESC;

SELECT * FROM USER_SCHEDULER_JOB_RUN_DETAILS WHERE LOG_ID = JOB的LOG_ID;