set lines 150 pages 100 numwidth 7
col program for a38
col username for a10
col spid for a7
select to_char(sysdate,'YYYY-MM-DD HH24:MI:SS') "DATE", s.program, s.sid,
s.status, s.username, d.job_name, p.spid, s.serial#, p.pid
from v$session s, v$process p, dba_datapump_sessions d
where p.addr=s.paddr and s.saddr=d.saddr;
Code: Select all
DATE PROGRAM SID STATUS USERNAME JOB_NAME SPID SERIAL# PID
------------------- -------------------------------------- ------- -------- ---------- ------------------------------ ------- ------- -------
2012-04-27 16:48:08 udi@caldev7 (TNS V1-V3) 274 ACTIVE SYS SYS_IMPORT_SCHEMA_02 5684 4397 17
2012-04-27 16:48:08 oracle@caldev7 (DM00) 116 ACTIVE SYS SYS_IMPORT_SCHEMA_02 5916 5818 32
2012-04-27 16:48:08 oracle@caldev7 (DW01) 260 ACTIVE SYS SYS_IMPORT_SCHEMA_02 6055 4539 19