Which view would you query to determine the name and status of the stopped job?

While exporting data by using Data Pump, you find that the export runs for long period. Because this action is being performed during peak hours, you decide to stop the job and restart it during off-peak hours.
Which view would you query to determine the name and status of the stopped job?

While exporting data by using Data Pump, you find that the export runs for long period. Because this action is being performed during peak hours, you decide to stop the job and restart it during off-peak hours.
Which view would you query to determine the name and status of the stopped job?

A.
DBA_JOBS

B.
V$SESSION

C.
V$SESSION_LONGOPS

D.
DBA_DATAPUMP_JOBS

E.
DBA_DATAPUMP_SESSIONS

Explanation:
When a Datapump Export or Import session is launched, a Datapump Job is automatically started. This way, we can:
* detach from and reattach to long-running jobs without affecting the job itself.
* monitor jobs from multiple locations
* stop a job: suspend it temporarily to leave other applications requesting more resources to get them restart itlater
* kill any Datapump job anytime
* see the progress of the import or export operations

REF: Metalink Note: 262557.1



Leave a Reply 1

Your email address will not be published. Required fields are marked *


seenagape

seenagape

Correct answer is