SAP Table GVD_SESSION
Oracle monitoring: Snapshot table for GV$SESSION
Recommended Now
Fire TV Stick Lite Essentials Bundle
This bundle contains Amazon Fire TV Stick Lite and Mission USB Power Cable. The USB power cable eliminates the need to find an AC outlet near your TV by powering Amazon Fire TV directly from your TV's USB port. Includes special power management circuitry that enhances the peak power capability of the USB port by storing excess energy and then releasing it as needed.
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 |