导入导出
set linesize 200 pagesize 50
column spid_sid_s# format A18 heading 'SPID,SID,SERIAL#'
column operation format A20 word_wrap
column progress format A13
column total format A15
column eta format A8
column message format A30 word_wrap
column username format A10
select c.spid || ',' || a.sid || ',' || a.serial# as spid_sid_s#,
a.opname as operation,
a.totalwork || ' ' || a.units as total,
round(a.sofar/a.totalwork*100) || '% in ' || a.elapsed_seconds || 's' as progress,
decode(a.sofar, 0, 'N/A', round(a.elapsed_seconds * (a.totalwork - a.sofar) / a.sofar / 60, 1) || 'm') as ETA,
a.message,
a.username
from v$session_longops a,
v$session b,
v$process c
where a.sid = b.sid
and a.serial# = b.serial#
and b.paddr = c.addr
and a.sofar < a.totalwork;
索引
set linesize 200 pagesize 50
column spid_sid_s# format A18 heading 'SPID,SID,SERIAL#'
column operation format A20 word_wrap
column progress format A13
column total format A15
column eta format A8
column message format A30 word_wrap
column username format A10
select c.spid || ',' || a.sid || ',' || a.serial# as spid_sid_s#,
a.opname as operation,
a.totalwork || ' ' || a.units as total,
round(a.sofar/a.totalwork*100) || '% in ' || a.elapsed_seconds || 's' as progress,
decode(a.sofar, 0, 'N/A', round(a.elapsed_seconds * (a.totalwork - a.sofar) / a.sofar / 60, 1) || 'm') as ETA,
a.message,
a.username
from v$session_longops a,
v$session b,
v$process c
where a.sid = b.sid
and a.serial# = b.serial#
and b.paddr = c.addr
and a.sofar < a.totalwork;
恢复进度
set linesize 200 pagesize 50
column spid_sid_s# format A18 heading 'SPID,SID,SERIAL#'
column operation format A20 word_wrap
column progress format A13
column total format A15
column eta format A8
column message format A30 word_wrap
column username format A10
select c.spid || ',' || a.sid || ',' || a.serial# as spid_sid_s#,
a.opname as operation,
a.totalwork || ' ' || a.units as total,
round(a.sofar/a.totalwork*100) || '% in ' || a.elapsed_seconds || 's' as progress,
decode(a.sofar, 0, 'N/A', round(a.elapsed_seconds * (a.totalwork - a.sofar) / a.sofar / 60, 1) || 'm') as ETA,
a.message,
a.username
from v$session_longops a,
v$session b,
v$process c
where a.sid = b.sid
and a.serial# = b.serial#
and b.paddr = c.addr
and a.sofar < a.totalwork;
姚昕:
set linesize 200 pagesize 50
column spid_sid_s# format A18 heading 'SPID,SID,SERIAL#'
column operation format A20 word_wrap
column progress format A13
column total format A15
column eta format A8
column message format A30 word_wrap
column username format A10
select c.spid || ',' || a.sid || ',' || a.serial# as spid_sid_s#,
a.opname as operation,
a.totalwork || ' ' || a.units as total,
round(a.sofar/a.totalwork*100) || '% in ' || a.elapsed_seconds || 's' as progress,
decode(a.sofar, 0, 'N/A', round(a.elapsed_seconds * (a.totalwork - a.sofar) / a.sofar / 60, 1) || 'm') as ETA,
a.message,
a.username
from v$session_longops a,
v$session b,
v$process c
where a.sid = b.sid
and a.serial# = b.serial#
and b.paddr = c.addr
and a.sofar < a.totalwork;
姚昕:
select inst_id,sid,serial#,opname,COMPLETE,
trunc(((to_char(last_update_time,'dd')-to_char(start_time,'dd'))*60*24+(to_char(last_update_time,'hh24')-to_char(start_time,'hh24'))*60 +(to_char(last_update_time,'mi')-to_char(start_time,'mi')))*(100-complete)/complete) min from
(
SELECT inst_id,
sid,
serial#,
opname,
ROUND(SOFAR / TOTALWORK * 100, 2) COMPLETE,
LAST_UPDATE_TIME,
START_TIME
FROM gV$SESSION_LONGOPS
WHERE OPNAME LIKE 'RMAN%'
--AND OPNAME NOT LIKE '%aggregate%'
AND TOTALWORK != 0
AND SOFAR <> TOTALWORK
) t;
set linesize 200 pagesize 50
column spid_sid_s# format A18 heading 'SPID,SID,SERIAL#'
column operation format A20 word_wrap
column progress format A13
column total format A15
column eta format A8
column message format A30 word_wrap
column username format A10
select c.spid || ',' || a.sid || ',' || a.serial# as spid_sid_s#,
a.opname as operation,
a.totalwork || ' ' || a.units as total,
round(a.sofar/a.totalwork*100) || '% in ' || a.elapsed_seconds || 's' as progress,
decode(a.sofar, 0, 'N/A', round(a.elapsed_seconds * (a.totalwork - a.sofar) / a.sofar / 60, 1) || 'm') as ETA,
a.message,
a.username
from v$session_longops a,
v$session b,
v$process c
where a.sid = b.sid
and a.serial# = b.serial#
and b.paddr = c.addr
and a.sofar < a.totalwork;
索引
set linesize 200 pagesize 50
column spid_sid_s# format A18 heading 'SPID,SID,SERIAL#'
column operation format A20 word_wrap
column progress format A13
column total format A15
column eta format A8
column message format A30 word_wrap
column username format A10
select c.spid || ',' || a.sid || ',' || a.serial# as spid_sid_s#,
a.opname as operation,
a.totalwork || ' ' || a.units as total,
round(a.sofar/a.totalwork*100) || '% in ' || a.elapsed_seconds || 's' as progress,
decode(a.sofar, 0, 'N/A', round(a.elapsed_seconds * (a.totalwork - a.sofar) / a.sofar / 60, 1) || 'm') as ETA,
a.message,
a.username
from v$session_longops a,
v$session b,
v$process c
where a.sid = b.sid
and a.serial# = b.serial#
and b.paddr = c.addr
and a.sofar < a.totalwork;
恢复进度
set linesize 200 pagesize 50
column spid_sid_s# format A18 heading 'SPID,SID,SERIAL#'
column operation format A20 word_wrap
column progress format A13
column total format A15
column eta format A8
column message format A30 word_wrap
column username format A10
select c.spid || ',' || a.sid || ',' || a.serial# as spid_sid_s#,
a.opname as operation,
a.totalwork || ' ' || a.units as total,
round(a.sofar/a.totalwork*100) || '% in ' || a.elapsed_seconds || 's' as progress,
decode(a.sofar, 0, 'N/A', round(a.elapsed_seconds * (a.totalwork - a.sofar) / a.sofar / 60, 1) || 'm') as ETA,
a.message,
a.username
from v$session_longops a,
v$session b,
v$process c
where a.sid = b.sid
and a.serial# = b.serial#
and b.paddr = c.addr
and a.sofar < a.totalwork;
姚昕:
set linesize 200 pagesize 50
column spid_sid_s# format A18 heading 'SPID,SID,SERIAL#'
column operation format A20 word_wrap
column progress format A13
column total format A15
column eta format A8
column message format A30 word_wrap
column username format A10
select c.spid || ',' || a.sid || ',' || a.serial# as spid_sid_s#,
a.opname as operation,
a.totalwork || ' ' || a.units as total,
round(a.sofar/a.totalwork*100) || '% in ' || a.elapsed_seconds || 's' as progress,
decode(a.sofar, 0, 'N/A', round(a.elapsed_seconds * (a.totalwork - a.sofar) / a.sofar / 60, 1) || 'm') as ETA,
a.message,
a.username
from v$session_longops a,
v$session b,
v$process c
where a.sid = b.sid
and a.serial# = b.serial#
and b.paddr = c.addr
and a.sofar < a.totalwork;
姚昕:
select inst_id,sid,serial#,opname,COMPLETE,
trunc(((to_char(last_update_time,'dd')-to_char(start_time,'dd'))*60*24+(to_char(last_update_time,'hh24')-to_char(start_time,'hh24'))*60 +(to_char(last_update_time,'mi')-to_char(start_time,'mi')))*(100-complete)/complete) min from
(
SELECT inst_id,
sid,
serial#,
opname,
ROUND(SOFAR / TOTALWORK * 100, 2) COMPLETE,
LAST_UPDATE_TIME,
START_TIME
FROM gV$SESSION_LONGOPS
WHERE OPNAME LIKE 'RMAN%'
--AND OPNAME NOT LIKE '%aggregate%'
AND TOTALWORK != 0
AND SOFAR <> TOTALWORK
) t;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/30317998/viewspace-2122453/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/30317998/viewspace-2122453/