Oracle job 管理
【IT168技术文档】
Oracle job 管理,介绍job的创建、删除、查看,及其各参数。
SVRMGR> select * from dba_jobs;
初始化相关参数job_queue_processes
alter system set job_queue_processes=39 scope=spfile;//最大值不能超过1000 ;job_queue_interval = 10 //调度作业刷新频率秒为单位
Oracle job 管理,介绍job的创建、删除、查看,及其各参数。
SVRMGR> select * from dba_jobs;
初始化相关参数job_queue_processes
alter system set job_queue_processes=39 scope=spfile;//最大值不能超过1000 ;job_queue_interval = 10 //调度作业刷新频率秒为单位
DBA_JOBS describes all jobs in the database. USER_JOBS describes all jobs owned by the current user 1 select job,what,to_char(last_date,'yyyy-mm-dd HH24:mi:ss'),
to_char(next_date,'yyyy-mm-dd HH24:m),interval from dba_jobs where job in (325,295) 2 select job,what,last_date,next_date,interval from dba_jobs where job in (1,3);
查询job的情况。
show paramter background_dump_dest.
看alter.log 和trace
SVRMGR> select * from dba_jobs;
初始化相关参数job_queue_processes
alter system set job_queue_processes=39 scope=spfile;//最大值不能超过1000
job_queue_interval = 10 //调度作业刷新频率秒为单位
DBA_JOBS describes all jobs in the database. USER_JOBS describes all jobs owned by the current user 1 select job,what,to_char(last_date,'yyyy-mm-dd HH24:mi:ss'),to_char(next_date,'yyyy-mm-dd HH24:m),interval from dba_jobs where job in (325,295) 2 select job,what,last_date,next_date,interval from dba_jobs where job in (1,3);
0
相关文章