Oracle教程 2023-02-23

Oracle 视图 ALL_SCHEDULER_RUNNING_JOBS 官方解释，作用，如何使用详细说明

本站中文解释

Oracle视图ALL_SCHEDULER_RUNNING_JOBS是SCHEDULER中现在正在运行的作业视图，其中包含有关这些作业的详细信息，例如：

*JOB_NAME：当前正在运行的作业名称
*SCHEMA_USER：运行这个作业的数据库用户的姓名
*INITIAL_START_DATE：作业的初始开始时间
*END_DATE：作业的结束时间
*ELAPSED_TIME：作业实际运行的时间
*SLAVE_PID：在运行时启动的子进程的进程ID

这个视图可以用来查询给定作业当前正在运行的信息，也可以用来了解特定作业在指定时间段内正在正在运行的详细情况，这有助于我们更好地管理作业和解决作业中出现的问题。

使用这个视图可以通过执行一个查询来检索信息：

SELECT * FROM all_scheduler_running_jobs
WHERE job_name=’JOB1′ AND schema_user=’SCOTT’;

这个查询会返回与指定作业和用户的所有当前正在运行的信息。

官方英文解释

ALL_SCHEDULER_RUNNING_JOBS displays information about the running Scheduler jobs accessible to the current user.

Related Views

DBA_SCHEDULER_RUNNING_JOBS displays information about all running Scheduler jobs in the database.
USER_SCHEDULER_RUNNING_JOBS displays information about the running Scheduler jobs owned by the current user. This view does not display the OWNER column.

Column	Datatype	Description
`OWNER`	`VARCHAR2(128)`	Owner of the running Scheduler job
`JOB_NAME`	`VARCHAR2(128)`	Name of the running Scheduler job
`JOB_SUBNAME`	`VARCHAR2(128)`	Subname of the running Scheduler job (for a job running a chain step)
`JOB_STYLE`	`VARCHAR2(17)`	Job style: `REGULAR` `LIGHTWEIGHT` `IN_MEMORY_RUNTIME` `IN_MEMORY_FULL`
`DETACHED`	`VARCHAR2(5)`	Indicates whether the detached attribute is set for the job (`TRUE`) or not (`FALSE`). If the detached attribute is set, then the job will remain running even after the job action has completed.
`SESSION_ID`	`NUMBER`	Identifier of the session running the Scheduler job
`SLAVE_PROCESS_ID`	`NUMBER`	Process number of the slave process running the Scheduler job
`SLAVE_OS_PROCESS_ID`	`VARCHAR2(12)`	Process number of the operating system slave process running the scheduler job
`RUNNING_INSTANCE`	`NUMBER`	Database instance number of the slave process running the Scheduler job
`RESOURCE_CONSUMER_GROUP`	`VARCHAR2(32)`	Resource consumer group of the session in which the Scheduler job is running
`ELAPSED_TIME`	`INTERVAL DAY(3) TO SECOND(2)`	Elapsed time since the Scheduler job was started
`CPU_USED`	`INTERVAL DAY(3) TO SECOND(2)`	CPU time consumed by the running Scheduler job, if available
`DESTINATION_OWNER`	`VARCHAR2(261)`	Owner of the destination object (if used), else NULL
`DESTINATION`	`VARCHAR2(261)`	Destination that this job is running on
`CREDENTIAL_OWNER`	`VARCHAR2(128)`	Owner of the login credential used for this running job, if any
`CREDENTIAL_NAME`	`VARCHAR2(128)`	Name of the login credential used for this running job, if any
`LOG_ID`	`NUMBER`	Log ID used for this running job. This column maps to the `LOG_ID` column of the `_SCHEDULER_JOB_LOG` and `_SCHEDULER_JOB_RUN_DETAILS` views.

本站中文解释

官方英文解释

相关推荐