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".
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_ID | Oracle monitor: snapshot ID | X | ORA_SNAPSHOT_ID | NUMC | 10 | * |
INST_ID | Oracle monitor: Instance ID | X | ORA_INST_ID | DEC | 12 | |
PROCESS | Oracle monitoring: OS Process Id | X | ORA_PROCESS | CHAR | 12 | |
PID | Oracle monitoring: PID | X | ORA_PID | DEC | 12 | |
STATUS | Oracle monitoring: Current process status | ORA_STATUS | CHAR | 12 | ||
CLIENT_PROCESS | Oracle monitoring: Primary database process | ORA_CLIENT_PROCESS | CHAR | 8 | ||
CLIENT_PID | Oracle monitoring: OS process Id of the client process | ORA_CLIENT_PID | CHAR | 40 | ||
CLIENT_DBID | Oracle monitoring: Database identifier of the primary DB | ORA_CLIENT_DBID | CHAR | 40 | ||
GROUP_NBR | Oracle monitoring: Standby redo log group | ORA_GROUP | CHAR | 40 | ||
THREAD | Oracle monitoring: Archived redo log thread number | ORA_THREAD | DEC | 12 | ||
SEQUENCE | Oracle monitoring: Archived redo log sequence number | ORA_SEQUENCE | DEC | 12 | ||
BLOCK | Oracle monitoring: Last processed archived redo log block Nr | ORA_BLOCK_NBR | DEC | 12 | ||
BLOCKS | Oracle monitoring: Size of the archived redo log in 512-byte | ORA_BLOCKS | DEC | 12 | ||
DELAY_MINS | Oracle monitoring: Archived redo log delay interval in mins | ORA_DELAY_MINS | DEC | 12 | ||
KNOWN_AGENTS | Oracle monitoring: Total number of standby DB agents | ORA_KNOWN_AGENTS | DEC | 12 | ||
ACTIVE_AGENTS | Oracle monitoring: Number of active standby db agents | ORA_ACTIVE_AGENTS | DEC | 12 |