oracle 怎么查找job,查找oracle的数据库job任务的命令

select * from dba_scheduler_job_run_details

where JOB_NAME='JOB_NHM_PPM_WLAN_AP_PERF'

order by log_date

select job, last_date, next_date, broken, failures

from user_jobs

查询job

select LOG_ID,

TO_CHAR(LOG_DATE, 'yyyy-mm-dd hh24:mi:ss') LOG_DATE,

OWNER,

JOB_NAME,

JOB_SUBNAME,

STATUS,

ERROR#,

TO_CHAR(REQ_START_DATE, 'yyyy-mm-dd hh24:mi:ss') REQ_START_DATE,

TO_CHAR(ACTUAL_START_DATE, 'yyyy-mm-dd hh24:mi:ss') ACTUAL_START_DATE,

RUN_DURATION,

INSTANCE_ID,

SESSION_ID,

SLAVE_PID,

CPU_USED,

ADDITIONAL_INFO

from DBA_SCHEDULER_JOB_RUN_DETAILS

where OWNER in ('FM', 'NHM', 'RM')

order by LOG_DATE

job的查询完善：

select LOG_ID,

TO_CHAR(LOG_DATE, 'yyyy-mm-dd hh24:mi:ss') LOG_DATE,

OWNER,

JOB_NAME,

JOB_SUBNAME,

STATUS,

ERROR#,

TO_CHAR(REQ_START_DATE, 'yyyy-mm-dd hh24:mi:ss') REQ_START_DATE,

TO_CHAR(ACTUAL_START_DATE, 'yyyy-mm-dd hh24:mi:ss') ACTUAL_START_DATE,

RUN_DURATION,

INSTANCE_ID,

SESSION_ID,

SLAVE_PID,

CPU_USED,

ADDITIONAL_INFO

from DBA_SCHEDULER_JOB_RUN_DETAILS

where LOG_DATE > TRUNC(sysdate)

and OWNER in ('FM', 'NHM', 'RM')

order by LOG_ID

根据job查到的session_id来查找对应的日志

比如以上的语句查出来session_id为2196.48567

就要按以下的格式来查询

select count(*), B.OBJECT_NAME, http://www.doczj.com/doc/58c20e5527284b73f3425016.html EVENT_NAME

from SYS.WRH$_ACTIVE_SESSION_HISTORY A, DBA_OBJECTS B, V$EVENT_NAME C

where A.CURRENT_OBJ# = B.DATA_OBJECT_ID and A.EVENT_ID=C.EVENT_ID

and A.SESSION_ID = 2196

and A.SESSION_SERIAL# = 48567

and A.SAMPLE_TIME >= TRUNC(sysdate-1)

group by B.OBJECT_NAME, http://www.doczj.com/doc/58c20e5527284b73f3425016.html;

完善的：

select count(*), B.OBJECT_NAME, http://www.doczj.com/doc/58c20e5527284b73f3425016.html EVENT_NAME

from SYS.WRH$_ACTIVE_SESSION_HISTORY A, DBA_OBJECTS B, V$EVENT_NAME C

where A.CURRENT_OBJ# = B.DATA_OBJECT_ID(+) and A.EVENT_ID=C.EVENT_ID(+)

and A.SESSION_ID = 1950

and A.SESSION_SERIAL# = 21082

/*and A.SAMPLE_TIME >= TRUNC(sysdate)*/

group by B.OBJECT_NAME, http://www.doczj.com/doc/58c20e5527284b73f3425016.html;