Oracle教程 2023-03-22

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

Oracle 视图DBA_PARALLEL_EXECUTE_TASKS显示了当前用户的并行操作的任务信息，如块的大小和工作单元处理的情况，还能监视每个任务的完成时间和失败信息，通过这个视图可以进行性能监视，排错以及获取用户有关并行操作的信息。

使用Oracle视图DBA_PARALEL_EXECUTE_TASKS的步骤如下：

1）连接到Oracle数据库。

2）创建一个Oracle查询并运行它，以查看当前用户执行并行操作的任务信息，以收集有关并行操作的信息：

SELECT * FROM DBA_PARALLEL_EXECUTE_TASKS;

3）解析查询结果以检索任务的相关信息，根据需要执行其他操作。

DBA_PARALLEL_EXECUTE_TASKS displays all tasks in the database.

Related View

USER_PARALLEL_EXECUTE_TASKS displays the tasks created by the current user. This view does not display the TASK_OWNER column.

Column	Datatype	NULL	Description
`TASK_OWNER`	`VARCHAR2(128)`	`NOT NULL`	Owner of the task
`TASK_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the task
`CHUNK_TYPE`	`VARCHAR2(12)`		Type of parallel update: `UNDELARED` `ROWID_RANGE` `NUMBER_RANGE`
`STATUS`	`VARCHAR2(19)`		Status of the task: `CREATED` `CHUNKING` `CHUNKING_FAILED` `CHUNKED` `PROCESSING` `FINISHED` `FINISHED_WITH_ERROR` `CRASHED`
`TABLE_OWNER`	`VARCHAR2(128)`		Owner of the table to be chunked
`TABLE_NAME`	`VARCHAR2(128)`		Name of the table to be chunked
`NUMBER_COLUMN`	`VARCHAR2(128)`		Name of the column holding IDs (only applicable to `NUMBER_RANGE` chunking type)
`TASK_COMMENT`	`VARCHAR2(4000)`		Comment field
`JOB_PREFIX`	`VARCHAR2(128)`		Prefix of the job name executing this task
`SQL_STMT`	`CLOB`		Argument used in the previous `DBMS_PARALLEL_EXECUTE.RUN_TASK`
`LANGUAGE_FLAG`	`NUMBER`		Argument used in the previous `DBMS_PARALLEL_EXECUTE.RUN_TASK`
`EDITION`	`VARCHAR2(130)`		Argument used in the previous `DBMS_PARALLEL_EXECUTE.RUN_TASK`
`APPLY_CROSSEDITION_TRIGGER`	`VARCHAR2(130)`		Argument used in the previous `DBMS_PARALLEL_EXECUTE.RUN_TASK`
`FIRE_APPLY_TRIGGER`	`VARCHAR2(10)`		Argument used in the previous `DBMS_PARALLEL_EXECUTE.RUN_TASK`
`PARALLEL_LEVEL`	`NUMBER`		Argument used in the previous `DBMS_PARALLEL_EXECUTE.RUN_TASK`
`JOB_CLASS`	`VARCHAR2(128)`		Argument used in the previous `DBMS_PARALLEL_EXECUTE.RUN_TASK`