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 AI Database 26ai.