SAP Table STI_INSTANCE
Oracle monitoring: structure for GV$INSTANCE.
STI_INSTANCE (Oracle monitoring: structure for GV$INSTANCE.) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link STI_INSTANCE to other SAP tables.
STI_INSTANCE table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||
|---|---|---|---|---|---|---|---|---|
| INST_ID | Oracle monitor: Instance ID | ORA_INST_ID | DEC | 22 | 0 | |||
| INSTANCE_NUMBER | Oracle monitoring: instance number | ORA_INSTANCE_NUMBER | DEC | 22 | 0 | |||
| INSTANCE_NAME | Oracle monitoring: instance_name | ORA_INSTANCE_NAME | CHAR | 48 | 0 | |||
| HOST_NAME | Oracle monitoring: host_name | ORA_HOST_NAME | CHAR | 64 | 0 | |||
| VERSION | Oracle monitoring: version | ORA_VERSION | CHAR | 17 | 0 | |||
| STARTUP_DATE | Oracle monitoring: instance startup time (date value) | ORA_STARTUP_DATE | DATS | 8 | 0 | |||
| STARTUP_TIME | Oracle monitoring: instance startup time | ORA_STARTUP_TIME | TIMS | 6 | 0 | |||
| STATUS | Oracle monitoring: instance status | ORA_STATUS_INST | CHAR | 12 | 0 | |||
| PARALLEL | Oracle monitoring: parallel | ORA_PARALLEL | CHAR | 3 | 0 | |||
| THREAD | Oracle monitoring: thread_inst | ORA_THREAD_INST | DEC | 22 | 0 | |||
| ARCHIVER | Oracle monitoring: archiver | ORA_ARCHIVER | CHAR | 7 | 0 | |||
| LOG_SWITCH_WAIT | Oracle monitoring: instance log switch wait | ORA_LOG_SWITCH_WAIT | CHAR | 11 | 0 | |||
| LOGINS | Oracle monitoring: instance logins | ORA_LOGINS | CHAR | 10 | 0 | |||
| SHUTDOWN_PENDING | Oracle monitoring: shutdown_pending | ORA_SHUTDOWN_PENDING | CHAR | 3 | 0 | |||
| DATABASE_STATUS | Oracle monitoring: database status | ORA_DATABASE_STATUS | CHAR | 17 | 0 | |||
| INSTANCE_ROLE | Oracle monitoring: instance role | ORA_INSTANCE_ROLE | CHAR | 18 | 0 | |||
| ACTIVE_STATE | Oracle monitoring: active state | ORA_ACTIVE_STATE | CHAR | 9 | 0 | |||
