GVD_MANGD_STANBY - copy of GV$MANAGED_STANDBY (currently not provided w. snaps)

copy of GV$MANAGED_STANDBY (currently not provided w. snaps) information is stored in SAP table GVD_MANGD_STANBY.
It is part of development package S_DBMON_ORA_COCKPIT in software component BC-CCM-MON-ORA. This development package consists of objects that can be grouped under "Database Monitor for Oracle in Cockpit Framework".

Fields for table GVD_MANGD_STANBY

Field Name
Description
Is Key
Data Element
Data Type
Length
Check Table
SNAPSHOT_IDOracle monitor: snapshot IDXORA_SNAPSHOT_IDNUMC10*
INST_IDOracle monitor: Instance IDXORA_INST_IDDEC12
PROCESSOracle monitoring: OS Process IdXORA_PROCESSCHAR12
PIDOracle monitoring: PIDXORA_PIDDEC12
STATUSOracle monitoring: Current process statusORA_STATUSCHAR12
CLIENT_PROCESSOracle monitoring: Primary database processORA_CLIENT_PROCESSCHAR8
CLIENT_PIDOracle monitoring: OS process Id of the client processORA_CLIENT_PIDCHAR40
CLIENT_DBIDOracle monitoring: Database identifier of the primary DBORA_CLIENT_DBIDCHAR40
GROUP_NBROracle monitoring: Standby redo log groupORA_GROUPCHAR40
THREADOracle monitoring: Archived redo log thread numberORA_THREADDEC12
SEQUENCEOracle monitoring: Archived redo log sequence numberORA_SEQUENCEDEC12
BLOCKOracle monitoring: Last processed archived redo log block NrORA_BLOCK_NBRDEC12
BLOCKSOracle monitoring: Size of the archived redo log in 512-byteORA_BLOCKSDEC12
DELAY_MINSOracle monitoring: Archived redo log delay interval in minsORA_DELAY_MINSDEC12
KNOWN_AGENTSOracle monitoring: Total number of standby DB agentsORA_KNOWN_AGENTSDEC12
ACTIVE_AGENTSOracle monitoring: Number of active standby db agentsORA_ACTIVE_AGENTSDEC12
Privacy Policy