SAP Table GVD_SESSION
Oracle monitoring: Snapshot table for GV$SESSION
Recommended Now
All-new Echo Dot Smart speaker with Alexa
This bundle includes Echo Dot (3rd Gen) Charcoal and Philips Hue White A19 Medium Lumen Smart Bulb, 1100 Lumens. Built in Smart Home hub. Ask Alexa to control Zigbee-compatible devices. No additional Philips Hue hub required. Two choices for easy smart lighting - Start setting the mood with Hue Smart bulbs and your Echo device, supporting up to 5 Hue Bluetooth & Zigbee smart bulbs. Add the Hue Hub for whole-home smart lighting (up to 50 light points) and bonus features.
Check it out on amazon.com →
The table GVD_SESSION (Oracle monitoring: Snapshot table for GV$SESSION) is a standard table in SAP ERP. It belongs to the package STUN.
Technical Information
| Table | GVD_SESSION |
| Short Text | Oracle monitoring: Snapshot table for GV$SESSION |
| Package | STUN |
| Table Type | Transparent Table |
Fields for Table GVD_SESSION
| Field Name | Key | Description | Data Element | Type | Length | Check Table |
|---|---|---|---|---|---|---|
| SNAPSHOT_ID | ✔ | Oracle monitor: snapshot ID | ORA_SNAPSHOT_ID | NUMC | 10 | * |
| INST_ID | ✔ | Oracle monitor: Instance ID | ORA_INST_ID | DEC | 22 | |
| SADDR | ✔ | Oracle monitoring: Session address | ORA_SADDR | RAW | 8 | |
| SID | ✔ | Oracle monitoring: SID (Session) | ORA_SID | DEC | 22 | |
| SERIAL | Oracle monitoring: SERIAL#: Session serial number | ORA_SERIAL | DEC | 22 | ||
| AUDSID | Oracle monitoring: AUDSID: Auditing session ID | ORA_AUDSID | DEC | 22 | ||
| PADDR | Oracle monitoring: PADDR: Address of proc. owning the sess. | ORA_PADDR | RAW | 8 | ||
| OUSER | Oracle monitoring: USER#: Oracle user identifier | ORA_USER | DEC | 22 | ||
| USERNAME | Oracle monitoring: USERNAME: Oracle username | ORA_USERNAME | CHAR | 30 | ||
| COMMAND | Oracle monitoring: COMMAND: Command in progress | ORA_COMMAND | DEC | 22 | ||
| OWNERID | Oracle monitoring: OWNERID: session owner | ORA_OWNERID | DEC | 22 | ||
| 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 | 22 | ||
| 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 | 22 | ||
| 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 | 22 | ||
| 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 | 22 | ||
| ACTION | Oracle monitoring: ACTION: Currently executing action | ORA_ACTION | CHAR | 32 | ||
| ACTION_HASH | Oracle monitoring: ACTION: Currently executing action hash | ORA_ACTION_HASH | DEC | 22 | ||
| 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 | 22 | ||
| ROW_WAIT_OBJ | Oracle monitoring: ROW_WAIT_OBJ | ORA_ROW_WAIT_OBJ | DEC | 22 | ||
| ROW_WAIT_FILE | Oracle monitoring: ROW_WAIT_FILE | ORA_ROW_WAIT_FILE | DEC | 22 | ||
| ROW_WAIT_BLOCK | Oracle monitoring: ROW_WAIT_BLOCK | ORA_ROW_WAIT_BLOCK | DEC | 22 | ||
| ROW_WAIT_ROW | Oracle monitoring: ROW_WAIT_ROW | ORA_ROW_WAIT_ROW | DEC | 22 | ||
| 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 | 22 | ||
| 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 | 22 | ||
| CLIENT_IDENTIFIE | Oracle monitoring: ORA_CLIENT_IDENTIFIER | ORA_CLIENT_IDENTIFIER | CHAR | 64 |