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

本站中文解释

Oracle视图DBA_WI_JOBS是外部表源收集中的一个视图,它存储有关最近作业请求的信息,可以查看要求的任务和数据的迒回情况等,方便用户查看任务的状态,进而采取行动。可以使用以下查询来查看视图:

SELECT * FROM DBA_WI_JOBS;

官方英文解释

Each row in DBA_WI_JOBS describes a Workload Intelligence job, that is, a task that applies the algorithms of Workload Intelligence on a given capture directory.

Column Datatype NULL Description

JOB_ID

NUMBER

NOT NULL

The job identifier

JOB_NAME

VARCHAR2(128)

NOT NULL

A name that uniquely identifies the given job

CAPTURE_DIRECTORY

VARCHAR2(4000)

NOT NULL

Path to the capture directory on which the given job has been applied

MODEL_ORDER

NUMBER

The order of the markov model that describes the workload associated with the current job. If NULL, the corresponding order has not been calculated yet.

THRESHOLD

NUMBER

A number in the range [0, 1] that represents the threshold that the user has given as an input parameter to the current job of Workload Intelligence for the identification of significant patterns. If NULL, the process of pattern identification has not been initiated yet.


数据运维技术 » Oracle 视图 DBA_WI_JOBS 官方解释,作用,如何使用详细说明