TA的每日心情 | 开心 2023-8-9 11:05 |
---|
|
- CLEAR COLUMNS BREAKS COMPUTES
- COLUMN owner_name FORMAT a15 HEADING 'Owner Name'
- COLUMN job_name FORMAT a25 HEADING 'Job Name'
- COLUMN session_type FORMAT a50 HEADING 'Session Type'
- COLUMN start_time FORMAT a20 HEADING 'Start Time'
- COLUMN time_remaining FORMAT 9,999,999,999,999 HEADING 'Time Remaining (min.)'
- COLUMN sofar FORMAT 9,999,999,999,999 HEADING 'Bytes So Far'
- COLUMN totalwork FORMAT 9,999,999,999,999 HEADING 'Total for Job'
- COLUMN pct_completed HEADING '% Completed'
- BREAK ON report ON instance_name_print ON owner_name ON job_name
- SELECT
- dj.owner_name owner_name
- , dj.job_name job_name
- , TO_CHAR(sl.start_time,'mm/dd/yyyy HH24:MI:SS') start_time
- , ROUND(sl.time_remaining/60,0) time_remaining
- , sl.sofar sofar
- , sl.totalwork totalwork
- , TRUNC(ROUND((sl.sofar/sl.totalwork) * 100, 1)) pct_completed
- FROM
- gv$datapump_job dj
- , gv$datapump_session ds
- , gv$session s
- , gv$instance i
- , gv$session_longops sl
- WHERE
- s.inst_id = i.inst_id
- AND ds.inst_id = i.inst_id
- AND dj.inst_id = i.inst_id
- AND sl.inst_id = i.inst_id
- AND s.saddr = ds.saddr
- AND dj.job_id = ds.job_id
- AND sl.sid = s.sid
- AND sl.serial# = s.serial#
- AND ds.type = 'MASTER'
- ORDER BY
- i.instance_name
- , dj.owner_name
- , dj.job_name
- , ds.type
- ;
复制代码
|
|