8.168 V$DATAPUMP_SESSIONWAIT_INFO

V$DATAPUMP_SESSIONWAIT_INFO displays information about the current or last wait for each session attached to a Data Pump job.

Column Datatype Description

WAITING_SESSION

NUMBER

Session identifier; maps to V$SESSION.SID

SERIAL_NUMBER

NUMBER

Session serial number (used to uniquely identify a session's objects); maps to V$SESSION.SERIAL#

SEQ_NUMBER

NUMBER

A number that uniquely identifies the current or last wait (incremented for each wait)

EVENT

VARCHAR2(64)

If the session is currently waiting, then the resource or event for which the session is waiting. If the session is not in a wait, then the resource or event for which the session most recently waited.

See Also: "Oracle Wait Events"

DP_WAITTIME

NUMBER

If the session is currently waiting, then the value is 0. If the session is not in a wait, then the value is as follows:

  • > 0 - Value is the duration of the last wait in hundredths of a second

  • -1 - Duration of the last wait was less than a hundredth of a second

  • -2 - Parameter TIMED_STATISTICS was set to false

DP_SECONDS_IN_WAIT

NUMBER

If the session is currently waiting, then the value is the amount of time waited for the current wait. If the session is not in a wait, then the value is the amount of time since the start of the last wait.

DP_STATE_IN_WAIT

VARCHAR2(19)

Wait state of the Data Pump session:

  • WAITING - Session is currently waiting

  • WAITED UNKNOWN TIME - Duration of the last wait is unknown; this is the value when the parameter TIMED_STATISTICS is set to false

  • WAITED SHORT TIME - Last wait was less than a hundredth of a second

  • WAITED KNOWN TIME - Duration of the last wait is specified in the DP_WAITTIME column

DP_P1TEXT

VARCHAR2(64)

Description of the first wait event parameter

DP_P1

NUMBER

First wait event parameter (in decimal)

DP_P2TEXT

VARCHAR2(64)

Description of the second wait event parameter

DP_P2

NUMBER

Second wait event parameter (in decimal)

DP_P3TEXT

VARCHAR2(64)

Description of the third wait event parameter

DP_P3

NUMBER

Third wait event parameter (in decimal)

CON_ID

NUMBER

The ID of the container to which the data pertains. Possible values include:

  • 0: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs.

  • 1: This value is used for rows containing data that pertain to only the root

  • n: Where n is the applicable container ID for the rows containing data

Note:

This view is available starting with Oracle Database 23ai.