TA的每日心情 | 开心 2023-8-9 11:05 |
---|
|
- SET ECHO OFF
- SET FEEDBACK 6
- SET HEADING ON
- SET LINESIZE 180
- SET PAGESIZE 50000
- SET TERMOUT ON
- SET TIMING OFF
- SET TRIMOUT ON
- SET TRIMSPOOL ON
- SET VERIFY OFF
- CLEAR COLUMNS
- CLEAR BREAKS
- CLEAR COMPUTES
- COLUMN instance_name FORMAT a10 HEADING 'Instance'
- COLUMN sid HEADING 'Oracle|SID'
- COLUMN serial_num HEADING 'Serial|#'
- COLUMN opname FORMAT a30 HEADING 'RMAN|Operation'
- COLUMN start_time FORMAT a18 HEADING 'Start|Time'
- COLUMN totalwork HEADING 'Total|Work'
- COLUMN units FORMAT a10 HEADING 'units'
- COLUMN sofar HEADING 'So|Far'
- COLUMN pct_done HEADING 'Percent|Done'
- COLUMN elapsed_seconds HEADING 'Elapsed|Seconds'
- COLUMN time_remaining HEADING 'Seconds|Remaining'
- COLUMN done_at FORMAT a18 HEADING 'Done|At'
- break on report
- COMPUTE sum OF totalwork ON report
- SELECT
- i.instance_name instance_name
- , sid sid
- , serial# serial_num
- , b.opname opname
- , TO_CHAR(b.start_time, 'mm/dd/yy HH24:MI:SS') start_time
- , b.totalwork totalwork
- , units units
- , b.sofar sofar
- , ROUND( (b.sofar/DECODE( b.totalwork
- , 0
- , 0.001
- , b.totalwork)*100),0) pct_done
- , b.elapsed_seconds elapsed_seconds
- , b.time_remaining time_remaining
- , DECODE( b.time_remaining
- , 0
- , TO_CHAR((b.start_time + b.elapsed_seconds/3600/24), 'mm/dd/yy HH24:MI:SS')
- , TO_CHAR((SYSDATE + b.time_remaining/3600/24), 'mm/dd/yy HH24:MI:SS')
- ) done_at
- FROM
- gv$session a
- JOIN gv$session_longops b USING (sid,serial#)
- JOIN gv$instance i ON ( i.inst_id = a.inst_id
- AND i.inst_id = b.inst_id)
- WHERE
- a.program LIKE 'rman%'
- AND b.opname LIKE 'RMAN%'
- AND b.opname NOT LIKE '%aggregate%'
- AND b.totalwork > 0
- ORDER BY
- i.instance_name
- , b.start_time
- /
复制代码
|
|