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 |