RMAN progress and what it is waiting for scripts
Link From :
REM RMAN Progress
alter session set nls_date_format='dd/mm/yy hh24:mi:ss'
/
select SID, START_TIME,TOTALWORK, sofar, (sofar/totalwork) * 100 done,
sysdate + TIME_REMAINING/3600/24 end_at
from v$session_longops
where totalwork > sofar
AND opname NOT LIKE '%aggregate%'
AND opname like 'RMAN%'
/
REM RMAN wiats
set lines 120
column sid format 9999
column spid format 99999
column client_info format a25
column event format a30
column secs format 9999
SELECT SID, SPID, CLIENT_INFO, event, seconds_in_wait secs, p1, p2, p3
FROM V$PROCESS p, V$SESSION s
WHERE p.ADDR = s.PADDR
and CLIENT_INFO like 'rman channel=%'
/
[@more@]來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/10599713/viewspace-1003694/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Rman Scripts (Linux)Linux
- DP rman backup scripts
- RMAN 備份策略 scripts
- shell scripts
- Sql scriptsSQL
- Server shutdown in progressServer
- Progress語法
- Oracle OCP 1Z0-053 Q307(Rman execute global scripts)Oracle
- Oracle OCP IZ0-053 Q311(Rman catalog stored scripts)Oracle
- GoldenGate - What is supported and what is not ....Go
- Oracle DBA ScriptsOracle
- Tuning Scripts
- Data Server ScriptsServer
- What is it?
- 神奇的npm -- scriptsNPM
- 清理日誌 scripts
- dba_dependencies scripts
- oracle cold backup scriptsOracle
- HTML <progress> 進度條HTML
- [Angular] Progress HTTP Events with 'HttpRequest'AngularHTTP
- What is WebpackWeb
- What is Babel?Babel
- What is MySQL?MySql
- What is Gravity
- what is life?
- npm scripts 使用指南NPM
- Oracle EBS Monitoring ScriptsOracle
- 使用elasticsearch,Elasticsearch Scripts disabledElasticsearch
- linux_root_scriptsLinux
- CSS 設定 <progress>樣式CSS
- How to move progress database to different OSDatabase
- mysqld: Sort aborted: Server shutdown in progressMySqlServer
- What is an SQL relation?SQL
- What time is it on Mars?
- what the fuck java is?Java
- What is tradebit?
- What is functor in Haskell ?Haskell
- What is Scalability?