The DBA_DATAPUMP_SESSIONS view identifies the user sessions that are attached to a job. The information in this view is useful for determining why a stopped operation has not gone away.
The DBA_DATAPUMP_SESSIONS View
| Column | Datatype | Description |
|---|---|---|
OWNER_NAME | VARCHAR2(30) | User who initiated the job. |
JOB_NAME | VARCHAR2(30) | User-supplied name for the job (or the default name generated by the server). |
SADDR | RAW(4) (RAW(8) on 64-bit systems) | Address of session attached to the job. Can be used with V$SESSION view. |
No comments:
Post a Comment