V$DATAPUMP_PROCESS_INFO

V$DATAPUMP_PROCESS_INFO displays information about currently active Oracle Data Pump processes.

Column Datatype Description
CUR_DATE VARCHAR2(19) Date and time at which process information was gathered
PROGRAM VARCHAR2(84) Operating system program name
SESSIONID NUMBER Session identifier
STATUS VARCHAR2(8)

Status of the session:

  • ACTIVE - Session currently executing SQL

  • INACTIVE - Session which is inactive and either has no configured limits or has not yet exceeded the configured limits

  • KILLED - Session marked to be terminated

  • CACHED - Session temporarily cached for use by Oracle*XA

  • SNIPED - An inactive session that has exceeded some configured limits (for example, resource limits specified for the resource manager consumer group or idle_time specified in the user's profile). Such sessions will not be allowed to become active again.

USERNAME VARCHAR2(128) Oracle user name
JOBNAME VARCHAR2(128) User-supplied name for the job (or the default name generated by the server)
SPID VARCHAR2(24)

Operating system process identifier

The Oracle multiprocess/multithread feature is available for UNIX systems.

When the Oracle multiprocess/multithread feature is enabled, RDBMS processes are mapped to threads running in operating system processes, and the SPID identifier is not unique for RDBMS processes.

When the Oracle multiprocess/multithread feature is not enabled on UNIX systems, the SPID identifier is unique for RDBMS processes.

SERIALNUMBER NUMBER Session serial number
PROCESSID NUMBER Oracle process identifier
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.