Oracle教程 2023-03-24

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

视图

DBA_PARALLEL_EXECUTE_CHUNKS视图是Oracle提供的用于显示与并行执行相关的信息的动态系统视图之一。可以使用它来检查当前正在执行的并行任务，以及它们的令牌、进程ID和进度状态。

通常情况下，使用该视图可以帮助DBA定位影响数据库性能的任务，以及哪些任务在无缝地运行。

使用步骤：

（1）登录SQL*Plus并切换到用户：

sqlplus / as sysdba

（2）执行以下查询，以显示并行执行任务的信息：

SELECT * FROM DBA_PARALLEL_EXECUTE_CHUNKS;

（3）使用问号（“？”）显示每列的示例值，然后使用该值筛选出必要的行：

SELECT * FROM DBA_PARALLEL_EXECUTE_CHUNKS WHERE INSTANCE_NUMBER=?;

（4）根据需要，修改过滤条件，以显示满足条件的并行执行任务：

SELECT * FROM DBA_PARALLEL_EXECUTE_CHUNKS WHERE START_TIME > SYSDATE-6;

DBA_PARALLEL_EXECUTE_CHUNKS displays the chunks for all tasks in the database.

Related View

USER_PARALLEL_EXECUTE_CHUNKS displays the chunks for tasks created by the current user. This view does not display the TASK_OWNER column.

Column	Datatype	NULL	Description
`CHUNK_ID`	`NUMBER`	`NOT NULL`	Unique ID for the chunk
`TASK_OWNER`	`VARCHAR2(128)`	`NOT NULL`	Owner of the task
`TASK_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the task
`STATUS`	`VARCHAR2(20)`		Status of the chunk: `UNASSIGNED` `ASSIGNED` `PROCESSED` `PROCESSED_WITH_ERROR`
`START_ROWID`	`ROWID`		Rowid for the first row in the chunk
`END_ROWID`	`ROWID`		Rowid for the last row in the chunk
`START_ID`	`NUMBER`		Number column value of the first row in the chunk
`END_ID`	`NUMBER`		Number column value of the last row in the chunk
`JOB_NAME`	`VARCHAR2(128)`		Name of the job which processed this chunk
`START_TS`	`TIMESTAMP(6)`		Processing start time for the chunk
`END_TS`	`TIMESTAMP(6)`		Processing end time for the chunk
`ERROR_CODE`	`NUMBER`		Error code returned during the execution of the chunk if the `STATUS` column is `PROCESSED_WITH_ERROR`
`ERROR_MESSAGE`	`VARCHAR2(4000)`		Error message returned during the execution of the chunk if the `STATUS` column is `PROCESSED_WITH_ERROR`