eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: SYS.DBA_ROLLING_STATUS

Object Details

Object Name:	DBA_ROLLING_STATUS
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

Overall status of the rolling upgrade

[View Source]

Columns

Name	Datatype	Length	Comments
REVISION	NUMBER		Revision number of the current upgrade plan
STATUS	VARCHAR2	(12)	Readiness of the facility to begin or resume a rolling upgrade
PHASE	VARCHAR2	(14)	Current phase of the rolling upgrade
NEXT_INSTRUCTION	NUMBER		Instruction ID of the next pending instruction
REMAINING_INSTRUCTIONS	NUMBER		Number of remaining instructions to execute in the upgrade plan
COORDINATOR_INSTANCE	NUMBER		Instance number from which the rolling upgrade is being coordinated
COORDINATOR_PID	NUMBER		Process PID in which the rolling upgrade is being coordinated
ORIGINAL_PRIMARY	VARCHAR2	(128)	Database unique name of the original primary
FUTURE_PRIMARY	VARCHAR2	(128)	Database unique name of the future primary
TOTAL_DATABASES	NUMBER		Number of total databases eligible to participate in the rolling upgrade
PARTICIPATING_DATABASES	NUMBER		Number of databases configured to participate in the rolling upgrade
INIT_TIME	TIMESTAMP(6)	(11)	Time of the last call to DBMS_ROLLING.INIT_PLAN
BUILD_TIME	TIMESTAMP(6)	(11)	Time of the last call to DBMS_ROLLING.BUILD
START_TIME	TIMESTAMP(6)	(11)	Time of the last call to DBMS_ROLLING.START_UPGRADE
SWITCH_TIME	TIMESTAMP(6)	(11)	Time of the last call to DBMS_ROLLING.SWITCHOVER
FINISH_TIME	TIMESTAMP(6)	(11)	Time of the last call to DBMS_ROLLING.FINISH

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT REVISION
,      STATUS
,      PHASE
,      NEXT_INSTRUCTION
,      REMAINING_INSTRUCTIONS
,      COORDINATOR_INSTANCE
,      COORDINATOR_PID
,      ORIGINAL_PRIMARY
,      FUTURE_PRIMARY
,      TOTAL_DATABASES
,      PARTICIPATING_DATABASES
,      INIT_TIME
,      BUILD_TIME
,      START_TIME
,      SWITCH_TIME
,      FINISH_TIME
FROM SYS.DBA_ROLLING_STATUS;

Dependencies

[top of page]

SYS.DBA_ROLLING_STATUS references the following:

SYS: DUAL
SYSTEM: ROLLING$DATABASES; ROLLING$PLAN; ROLLING$STATUS

SYS.DBA_ROLLING_STATUS is referenced by following:

PUBLIC: DBA_ROLLING_STATUS