select * from user_jobs;

참고 : https://tnsgud.tistory.com/38

배치성으로 돌리것들은 로그를 남기시는게 편합니다.

예) 시작시간 , 종료시간, 에러 로그 등등

간접 확인 

SELECT O.OBJECT_NAME
      ,S.PARSING_SCHEMA_NAME AS SCHEMA
      ,S.MODULE
      ,S.SQL_ID
      ,S.HASH_VALUE
      ,SUBSTR(S.SQL_TEXT,1,100) AS SQLTEXT
      ,S.EXECUTIONS
      ,S.BUFFER_GETS
      ,S.DISK_READS
      ,ROUND(S.ROWS_PROCESSED/S.EXECUTIONS,1) AS "ROWS"
      ,ROUND(S.BUFFER_GETS/S.EXECUTIONS,1) AS LIO
      ,ROUND(S.ELAPSED_TIME/S.EXECUTIONS/1000,1) AS ELPASED_MS
      ,ROUND(S.CPU_TIME/S.EXECUTIONS/1000,1) AS CPU_MS
      ,ROUND(S.ELAPSED_TIME/S.EXECUTIONS,1) AS ELPASED_TIME
FROM   ( SELECT OBJECT_ID, OBJECT_NAME FROM DBA_OBJECTS WHERE OBJECT_NAME ='패키지명' AND OWNER ='쥔장' ) O
       , V$SQLAREA S
WHERE O.OBJECT_ID = S.PROGRAM_ID
ORDER BY ROUND(S.ELAPSED_TIME/S.EXECUTIONS/1000,1) DESC, ELAPSED_TIME DESC   ;