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

本站中文解释

Oracle视图 `DBA_DATAPUMP_SESSIONS` 是一个数据字典视图,用于跟踪Data Pump会话(作业)的状态和进度。它可以用来查看正在运行的Data Pump 会话和运行状态、时间和结果。

使用此视图的可以查询会话的`SESSION_NO`和`AUTH_ID`来查询出正在运行的Data Pump会话,也可以用`STATE`字段查询Data Pump会话的运行状态。 `STATE` 取值包括:EXECUTING、WAITING、COMPLETED、KILLED和STOPPED。

另外,可以使用此视图来跟踪作业的进度和执行时间,同时从DATA_BYTES和RECORDS_WRITTEN字段查看正在导出的记录总数。 也可以从此视图知道哪些Data Pump会话或作业发生了错误,可以查看`ERROR_COUNT`字段来获取错误的统计信息。

官方英文解释

DBA_DATAPUMP_SESSIONS identifies the user sessions that are attached to a Data Pump job. The information in this view is useful for determining why a stopped Data Pump operation has not gone away.

Column Datatype NULL Description

OWNER_NAME

VARCHAR2(128)

User that initiated the job

JOB_NAME

VARCHAR2(128)

User-supplied name for the job (or the default name generated by the server)

INSTANCE_ID

NUMBER

Instance ID

SADDR

RAW(4 | 8)

Address of the session attached to the job. Can be used with V$SESSION view.

SESSION_TYPE

VARCHAR2(14)

Data Pump session type:

  • DBMS_DATAPUMP – Data Pump interface process (one for each active instantiation of DBMS_DATAPUMP.OPEN and DBMS_DATAPUMP.ATTACH per job.)

  • MASTER – master control process (one per job)

  • WORKER – worker process (1 to n per job, depending on degree of parallelism)

  • EXTERNAL TABLE – external table data access process (1 to n, depending on degree of parallelism, for jobs that use external tables as the data access method for some tables)

  • OTHER

See Also:

Oracle Database PL/SQL
Packages and Types Reference
for more information about the DBMS_DATAPUMP package


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