17,377
社区成员
发帖
与我相关
我的任务
分享
SQL> select * from v$parameter where name like '%job%';
NUM NAME TYPE VALUE DISPLAY_VALUE ISDEFAULT ISSES_MODIFIABLE ISSYS_MODIFIABLE ISINSTANCE_MODIFIABLE ISMODIFIED ISADJUSTED ISDEPRECATED DESCRIPTION UPDATE_COMMENT HASH
---------- -------------------------------------------------------------------------------- ---------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- --------- ---------------- ---------------- --------------------- ---------- ---------- ------------ -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- ----------
704 job_queue_processes 3 10 10 FALSE FALSE IMMEDIATE TRUE FALSE FALSE FALSE number of job queue slave processes 1663833312
SQL>
SQL> select * from user_jobs where job='87';
JOB LOG_USER PRIV_USER SCHEMA_USER LAST_DATE LAST_SEC THIS_DATE THIS_SEC NEXT_DATE NEXT_SEC TOTAL_TIME BROKEN INTERVAL FAILURES WHAT NLS_ENV MISC_ENV INSTANCE
---------- ------------------------------ ------------------------------ ------------------------------ ----------- ---------------- ----------- ---------------- ----------- ---------------- ---------- ------ -------------------------------------------------------------------------------- ---------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- ---------------------------------------------------------------- ----------
87 FAQ FAQ FAQ 2009-06-18 08:34:25 2009-06-19 01:38:26 5 N to_date('2009-06-16 00:00:00','yyyy-mm-dd hh24:mi:ss') + 1 10 update t_repository set status='0',update_time=sysdate where ceil(valid_time-sy NLS_LANGUAGE='SIMPLIFIED CHINESE' NLS_TERRITORY='CHINA' NLS_CURRENCY='¥' NLS_IS 0102000200000000 0
SQL>