User Tools

Site Tools


oracle:import_and_export

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
oracle:import_and_export [2018/08/29 17:16]
dodger [List what is doing each job]
oracle:import_and_export [2019/07/18 09:17] (current)
Line 35: Line 35:
 WHERE p.addr = s.paddr AND s.saddr = d.saddr; WHERE p.addr = s.paddr AND s.saddr = d.saddr;
 </​code>​ </​code>​
 +Same but with sqltext
 +<code sql>
 +
 +col program format a50
 +COL ACTUALDATE FORMAT A20
 +COL SPID FORMAT A10
 +col username format a20
 +SELECT s.program,
 +     ​S.SQL_ID,​
 +     ​s.status,​
 +     ​s.username,​
 +     ​d.job_name,​
 +     ​SQA.SQL_TEXT
 +FROM V$SESSION s, V$PROCESS p, DBA_DATAPUMP_SESSIONS d,  V$SQLAREA SQA
 +WHERE p.addr = s.paddr AND s.saddr = d.saddr
 +AND S.SQL_ID=SQA.SQL_ID;​
 +</​code>​
 +
  
 and: and:
oracle/import_and_export.txt · Last modified: 2019/07/18 09:17 (external edit)