GVD_SESSION - Oracle monitoring: Snapshot table for GV$SESSION
Oracle monitoring: Snapshot table for GV$SESSION information is stored in SAP table GVD_SESSION.
It is part of development package STUN in software component BC-CCM-MON-TUN. This development package consists of objects that can be grouped under "SAP Monitoring Tools".
It is part of development package STUN in software component BC-CCM-MON-TUN. This development package consists of objects that can be grouped under "SAP Monitoring Tools".
Fields for table GVD_SESSION
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 | |
| SADDR | Oracle monitoring: Session address | X | ORA_SADDR | RAW | 8 | |
| SID | Oracle monitoring: SID (Session) | X | ORA_SID | DEC | 12 | |
| SERIAL | Oracle monitoring: SERIAL#: Session serial number | ORA_SERIAL | DEC | 12 | ||
| AUDSID | Oracle monitoring: AUDSID: Auditing session ID | ORA_AUDSID | DEC | 12 | ||
| PADDR | Oracle monitoring: PADDR: Address of proc. owning the sess. | ORA_PADDR | RAW | 8 | ||
| OUSER | Oracle monitoring: USER#: Oracle user identifier | ORA_USER | DEC | 12 | ||
| USERNAME | Oracle monitoring: USERNAME: Oracle username | ORA_USERNAME | CHAR | 30 | ||
| COMMAND | Oracle monitoring: COMMAND: Command in progress | ORA_COMMAND | DEC | 12 | ||
| OWNERID | Oracle monitoring: OWNERID: session owner | ORA_OWNERID | DEC | 12 | ||
| TADDR | Oracle monitoring: TADDR: Address of transaction state obj. | ORA_TADDR | CHAR | 16 | ||
| LOCKWAIT | Oracle monitoring: LOCKWAIT: Address of lock waiting for | ORA_LOCKWAIT | CHAR | 16 | ||
| STATUS | Oracle monitoring: STATUS: Status of the session | ORA_SSTATUS | CHAR | 8 | ||
| SERVER | Oracle monitoring: SERVER: Server type | ORA_SERVER | CHAR | 9 | ||
| OSCHEMA | Oracle monitoring: SCHEMA#: Schema user identifier | ORA_SCHEMA | DEC | 12 | ||
| SCHEMANAME | Oracle monitoring: SCHEMANAME: Schema user name | ORA_SCHEMANAME | CHAR | 30 | ||
| OSUSER | Oracle monitoring: OSUSER: Operating system client user name | ORA_OSUSER | CHAR | 30 | ||
| PROCESS | Oracle monitoring: OS Process Id | ORA_PROCESS | CHAR | 12 | ||
| MACHINE | Oracle monitoring: MACHINE: Operating system machine name | ORA_MACHINE | CHAR | 64 | ||
| TERMINAL | Oracle monitoring: MACHINE: Operating system machine name | ORA_TERMINAL | CHAR | 30 | ||
| OPROGRAM | Oracle monitoring: PROGRAM: Operating system program name | ORA_PROGRAM | CHAR | 48 | ||
| TYPE | Oracle monitoring: TYPE: Session type | ORA_STYPE | CHAR | 10 | ||
| SQL_ADDRESS | Oracle monitoring: SQL_ADDRESS: SQL Statement ID | ORA_SQL_ADDRESS | RAW | 8 | ||
| SQL_HASH_VALUE | Oracle monitoring: SQL_HASH_VALUE: SQL statement hash | ORA_SQL_HASH_VALUE | DEC | 12 | ||
| PREV_SQL_ADDR | Oracle monitoring: PREV_SQL_ADDR: Prev. SQL Statement ID | ORA_PREV_SQL_ADDR | RAW | 8 | ||
| PREV_HASH_VALUE | Oracle monitoring: PREV_HASH_VALUE: Prev. SQL Statement hash | ORA_PREV_HASH_VALUE | DEC | 12 | ||
| OMODULE | Oracle monitoring: MODULE: currently executing module | ORA_MODULE | CHAR | 48 | ||
| MODULE_HASH | Oracle monitoring: MODULE_HASH: curr. executing module hash | ORA_MODULE_HASH | DEC | 12 | ||
| ACTION | Oracle monitoring: ACTION: Currently executing action | ORA_ACTION | CHAR | 32 | ||
| ACTION_HASH | Oracle monitoring: ACTION: Currently executing action hash | ORA_ACTION_HASH | DEC | 12 | ||
| CLIENT_INFO | Oracle monitoring: CLIENT_INFO | ORA_CLIENT_INFO | CHAR | 64 | ||
| FIXED_TABLE_SEQU | Oracle monitoring: ORA_FIXED_TABLE_SEQUENCE | ORA_FIXED_TABLE_SEQUENCE | DEC | 12 | ||
| ROW_WAIT_OBJ | Oracle monitoring: ROW_WAIT_OBJ | ORA_ROW_WAIT_OBJ | DEC | 12 | ||
| ROW_WAIT_FILE | Oracle monitoring: ROW_WAIT_FILE | ORA_ROW_WAIT_FILE | DEC | 12 | ||
| ROW_WAIT_BLOCK | Oracle monitoring: ROW_WAIT_BLOCK | ORA_ROW_WAIT_BLOCK | DEC | 12 | ||
| ROW_WAIT_ROW | Oracle monitoring: ROW_WAIT_ROW | ORA_ROW_WAIT_ROW | DEC | 12 | ||
| LOGON_TIME | Oracle monitoring: LOGON_TIME (Time): Time of logon | ORA_LOGON_TIME | TIMS | 6 | ||
| LAST_CALL_ET | Oracle monitoring:LAST_CALL_ET: The last call | ORA_LAST_CALL_ET | DEC | 12 | ||
| PDML_ENABLED | Oracle monitoring: PDML_ENABLED | ORA_PDML_ENABLED | CHAR | 3 | ||
| FAILOVER_TYPE | Oracle monitoring: FAILOVER_TYPE: Failover type for session | ORA_FAILOVER_TYPE | CHAR | 13 | ||
| FAILOVER_METHOD | Oracle monitoring: FAILOVER_METHO: Failover method for sess. | ORA_FAILOVER_METHOD | CHAR | 10 | ||
| FAILED_OVER | Oracle monitoring: FAILED_OVER: Sess. in Failover Mode | ORA_FAILED_OVER | CHAR | 3 | ||
| RESOURCE_CONSUME | Oracle monitoring: RESOURCE_CONSUMER_GROUP | ORA_RESOURCE_CONSUMER_GROUP | CHAR | 32 | ||
| PDML_STATUS | Oracle monitoring: PDML_STATUS: Parallel DML status | ORA_PDML_STATUS | CHAR | 8 | ||
| PDDL_STATUS | Oracle monitoring: PDML_STATUS: Parallel DDL status | ORA_PDDL_STATUS | CHAR | 8 | ||
| PQ_STATUS | Oracle monitoring: PDML_STATUS: Parallel QUERY status | ORA_PQ_STATUS | CHAR | 8 | ||
| CURRENT_QUEUE_DU | Oracle monitoring: CURRENT_QUEUE_DURATION | ORA_CURRENT_QUEUE_DURATION | DEC | 12 | ||
| CLIENT_IDENTIFIE | Oracle monitoring: ORA_CLIENT_IDENTIFIER | ORA_CLIENT_IDENTIFIER | CHAR | 64 |