Pages
Home
Basic
Linux/Unix
Interview Questions
Scripts
Real Time Scenarios
Fresher Alerts Monitoring job
RAC
Patching
Metalink Id's
Installations
Presentation
About Conc Manager
RMAN/DATAPUMP
Sysadmin
Weblogic/SOA
Postclone steps
Links
Saturday, 18 January 2025
Monitoring Data pump Jobs
select sid, serial#, sofar, totalwork, dp.owner_name, dp.state, dp.job_mode
from gv$session_longops sl, gv$datapump_job dp
where sl.opname = dp.job_name and sofar != totalwork;
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment