一起学习网 一起学习网

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.

ColumnDatatypeNULLDescription

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

See Also:

“USER_PARALLEL_EXECUTE_CHUNKS”