VIEW: SYS.DBA_ROLLING_PLAN

Source

View Text - Preformatted

select p.revision, p.batchid, p.instid, d.dbun source, d2.dbun target,
         decode(p.phase, 1, 'NONE', 2, 'INIT', 3, 'BUILD PENDING',
                4, 'BUILD', 5, 'START PENDING', 6, 'START',
                7, 'SWITCH PENDING', 8, 'SWITCH', 9, 'FINISH PENDING',
                10, 'FINISH', 11, 'ROLLBACK', 12, 'DONE', 13, 'DESTROY',
                'UNKNOWN') phase,
         decode(p.status, 1, 'PENDING', 2, 'SUCCESS', 3, 'ERROR',
                          4, 'WARNING', 'UNKNOWN') status,
         decode(p.progress, 1, 'PENDING', 2, 'REQUESTING', 3, 'EXECUTING',
                            4, 'REPLYING', 5, 'POSTING', 6, 'COMPLETE',
                            7, 'ABORTING', 'UNKNOWN') progress,
         p.description, p.exec_status, p.exec_info, p.exec_time, p.finish_time
       from system.rolling$plan p, system.rolling$databases d,
            system.rolling$databases d2
      where p.source = d.rdbid and p.target = d2.rdbid
        and p.revision = d.revision and p.revision = d2.revision
    order by p.revision, p.instid

View Text - HTML Formatted

SELECT P.REVISION
, P.BATCHID
, P.INSTID
, D.DBUN SOURCE
, D2.DBUN TARGET
, DECODE(P.PHASE
, 1
, 'NONE'
, 2
, 'INIT'
, 3
, 'BUILD PENDING'
, 4
, 'BUILD'
, 5
, 'START PENDING'
, 6
, 'START'
, 7
, 'SWITCH PENDING'
, 8
, 'SWITCH'
, 9
, 'FINISH PENDING'
, 10
, 'FINISH'
, 11
, 'ROLLBACK'
, 12
, 'DONE'
, 13
, 'DESTROY'
, 'UNKNOWN') PHASE
, DECODE(P.STATUS
, 1
, 'PENDING'
, 2
, 'SUCCESS'
, 3
, 'ERROR'
, 4
, 'WARNING'
, 'UNKNOWN') STATUS
, DECODE(P.PROGRESS
, 1
, 'PENDING'
, 2
, 'REQUESTING'
, 3
, 'EXECUTING'
, 4
, 'REPLYING'
, 5
, 'POSTING'
, 6
, 'COMPLETE'
, 7
, 'ABORTING'
, 'UNKNOWN') PROGRESS
, P.DESCRIPTION
, P.EXEC_STATUS
, P.EXEC_INFO
, P.EXEC_TIME
, P.FINISH_TIME
FROM SYSTEM.ROLLING$PLAN P
, SYSTEM.ROLLING$DATABASES D
, SYSTEM.ROLLING$DATABASES D2
WHERE P.SOURCE = D.RDBID
AND P.TARGET = D2.RDBID
AND P.REVISION = D.REVISION
AND P.REVISION = D2.REVISION ORDER BY P.REVISION
, P.INSTID