GVD_INSTANCE - Copy of GV$INSTANCE
Copy of GV$INSTANCE information is stored in SAP table GVD_INSTANCE.
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_INSTANCE
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 | |
| INSTANCE_NUMBER | Oracle monitoring: instance number | ORA_INSTANCE_NUMBER | DEC | 12 | ||
| INSTANCE_NAME | Oracle monitoring: instance_name | ORA_INSTANCE_NAME | CHAR | 48 | ||
| HOST_NAME | Oracle monitoring: host_name | ORA_HOST_NAME | CHAR | 64 | ||
| VERSION | Oracle monitoring: version | ORA_VERSION | CHAR | 17 | ||
| STARTUP_DATE | Oracle monitoring: instance startup time (date value) | ORA_STARTUP_DATE | DATS | 8 | ||
| STARTUP_TIME | Oracle monitoring: instance startup time | ORA_STARTUP_TIME | TIMS | 6 | ||
| STATUS | Oracle monitoring: instance status | ORA_STATUS_INST | CHAR | 12 | ||
| PARALLEL | Oracle monitoring: parallel | ORA_PARALLEL | CHAR | 3 | ||
| THREAD | Oracle monitoring: thread_inst | ORA_THREAD_INST | DEC | 12 | ||
| ARCHIVER | Oracle monitoring: archiver | ORA_ARCHIVER | CHAR | 7 | ||
| LOG_SWITCH_WAIT | Oracle monitoring: instance log switch wait | ORA_LOG_SWITCH_WAIT | CHAR | 11 | ||
| LOGINS | Oracle monitoring: instance logins | ORA_LOGINS | CHAR | 10 | ||
| SHUTDOWN_PENDING | Oracle monitoring: shutdown_pending | ORA_SHUTDOWN_PENDING | CHAR | 3 | ||
| DATABASE_STATUS | Oracle monitoring: database status | ORA_DATABASE_STATUS | CHAR | 17 | ||
| INSTANCE_ROLE | Oracle monitoring: instance role | ORA_INSTANCE_ROLE | CHAR | 18 | ||
| ACTIVE_STATE | Oracle monitoring: active state | ORA_ACTIVE_STATE | CHAR | 9 |