Oracle教程 2023-02-26

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

本站中文解释

ALL_SCHEDULER_RUNNING_CHAINS 视图是 Oracle 的一个数据字典视图。它显示有关正在运行的管道的信息，其中包括此管道的状态、管道步骤的状态，以及由此管道创建的作业的信息。索引的主要由CHAIN_NAME，SESSION_ID，INSTANCE_ID和OWNER来识别，其他两列CHAIN_TYPE和START_TIME也可以用来识别索引。

用法:

1、以下查询语句用于检索正在运行的链信息：

SELECT *
FROM all_scheduler_running_chains;

2、可以用以下语句检索特定用户的正在运行的链信息：

SELECT *
FROM all_scheduler_running_chains
WHERE owner = ‘用户名’;

官方英文解释

ALL_SCHEDULER_RUNNING_CHAINS displays information about the chain steps of the running chains accessible to the current user (that is, those chains that the user has ALTER privileges for). In the case of nested chains, this view also enables you to traverse the hierarchy of the chain with a SQL statement that contains a CONNECT BY clause linking up the JOB_SUBNAME and STEP_JOB_SUBNAME columns.

Related Views

DBA_SCHEDULER_RUNNING_CHAINS displays information about the chain steps of all running chains in the database.
USER_SCHEDULER_RUNNING_CHAINS displays information about the chain steps of the running chains owned by the current user. This view does not display the OWNER column.

Column	Datatype	NULL	Description
`OWNER`	`VARCHAR2(128)`	`NOT NULL`	Owner of the job which is running the chain
`JOB_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the job which is running the chain
`JOB_SUBNAME`	`VARCHAR2(128)`		Subname of the job which is running the chain (for a nested chain), else NULL
`CHAIN_OWNER`	`VARCHAR2(128)`	`NOT NULL`	Owner of the chain being run
`CHAIN_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the chain being run
`STEP_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the step of the running chain
`STATE`	`VARCHAR2(15)`		State of the running chain step: `NOT_STARTED` `RUNNING` `SUCCEEDED` `STOPPED` `FAILED` `SCHEDULED` `RETRY SCHEDULED` `PAUSED` `STALLED`
`ERROR_CODE`	`NUMBER`		Error code with which the step completed (if it has completed)
`COMPLETED`	`VARCHAR2(5)`		Indicates whether the running chain step has completed (`TRUE`) or not (`FALSE`)
`START_DATE`	`TIMESTAMP(6) WITH TIME ZONE`		Date when the running chain step started (if it has started)
`END_DATE`	`TIMESTAMP(6) WITH TIME ZONE`		Date when the running chain step stopped (if it has stopped)
`DURATION`	`INTERVAL DAY(9) TO SECOND(6)`		Amount of time it took the chain step to complete (if it has completed)
`SKIP`	`VARCHAR2(5)`		Indicates whether the chain step should be skipped (`TRUE`) or not (`FALSE`)
`PAUSE`	`VARCHAR2(5)`		Indicates whether the chain step should be paused after running (`TRUE`) or not (`FALSE`)
`PAUSE_BEFORE`	`VARCHAR2(5)`		Indicates whether the chain step should be paused before running (`TRUE`) or not (`FALSE`)
`RESTART_ON_RECOVERY`	`VARCHAR2(5)`		Indicates whether the chain step will be restarted on database recovery (`TRUE`) or not (`FALSE`)
`RESTART_ON_FAILURE`	`VARCHAR2(5)`		Indicates whether the chain step will be restarted on application failure (`TRUE`) or not (`FALSE`)
`STEP_JOB_SUBNAME`	`VARCHAR2(128)`		Subname of the job running the step
`STEP_JOB_LOG_ID`	`NUMBER`		Log ID of the job running the step

本站中文解释

官方英文解释

相关推荐