SQL Script DataPump Monitor

Updated: 19-Mar-2005
Version: 2.0

Description

This script displays active 10g Data Pump Sessions

Parameters

None

SQL Source

REM Copyright (C) Think Forward.com 1998- 2005. All rights reserved. 

col owner_name form a10
col job_name form a20
col operation form a10
col state form a10

spool dp.lst

select s.sid
      ,s.serial#
      ,d.owner_name
      ,d.job_name
      ,j.operation
      ,j.state
from v$session s 
         JOIN dba_datapump_sessions d ON (s.saddr = d.saddr)
         JOIN dba_datapump_jobs j ON (d.job_name = j.job_name)
/

spool off

Return to Index of SQL Scripts

Site Map

General Information : Home | Company Profile | Contact Us | Legal
Database Support : Proactive Support | Pay Per Incident Support
Expert Services : High Availability | Creative Solutions | Training
Build Services : Oracle Installations | Revive your Oracle Setup | Low Cost Development
Free Oracle Resources: DBA Scripts | Oracle Links