Menu

SAP Table GVD_SQLAREA

Copy of GV$SQLAREA (currently not provided with snapshots)

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_SQLAREA (Copy of GV$SQLAREA (currently not provided with snapshots)) is a standard table in SAP ERP. It belongs to the package STUN.

Technical Information

Table GVD_SQLAREA
Short Text Copy of GV$SQLAREA (currently not provided with snapshots)
Package STUN
Table Type Transparent Table

Fields for Table GVD_SQLAREA

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
ADDRESS Oracle monitoring: ADDR ORA_ADDR RAW 8
HASH_VALUE Oracle Monitoring: HASH_VALUE: Hash Value of Parent Statment ORA_HASH_VALUE DEC 22
SHARABLE_MEM Oracle Monitoring: SHARABLE_MEM: Shared Memory Used ORA_SHARABLE_MEM DEC 22
PERSISTENT_MEM Oracle Monitoring: PERSISTENT_MEM: Fixed Mem used in lifetim ORA_PERSISTENT_MEM DEC 22
RUNTIME_MEM Oracle Monitoring: RUNTIME_MEM: Mem required during Execut. ORA_RUNTIME_MEM DEC 22
SORTS Oracle Monitoring: SORTS: Number of Sorts Done for cursor ORA_SORTS DEC 22
VERSION_COUNT Oracle monitor: version count ORA_VERION_COUNT DEC 22
LOADED_VERSIONS Oracle Monitoring: LOADED_VERSIONS: Is context Heap Loaded ORA_LOADED_VERSIONS DEC 22
OPEN_VERSIONS Oracle Monitoring: OPEN_VERSIONS: Is Child Cursor Locked? ORA_OPEN_VERSIONS DEC 22
USERS_OPENING Oracle Monitoring: USERS_OPENING: # of users executing SQL ORA_USERS_OPENING DEC 22
FETCHES Oracle Monitoring: FETCHES: # Fetches assoc. with statement ORA_FETCHES DEC 22
EXECUTIONS Oracle Monitoring: EXECUTIONS: # Executions ORA_EXECUTIONS DEC 22
USERS_EXECUTING Oracle Monitoring: USERS_EXECUTING: # of Users Exec. SQL ORA_USERS_EXECUTING DEC 22
LOADS Oracle Monitoring: # Times Object was Loaded or Reloaded ORA_LOADS DEC 22
FIRST_LOAD_TIME Oracle Monitoring: FIRST_LOAD_TIME: Timestamp of Creation ORA_FIRST_LOAD_TIME CHAR 19
INVALIDATIONS Oracle monitoring: # of times objects were marked invalid ORA_SQL_INVALIDATIONS DEC 22
PARSE_CALLS Oracle Monitoring: PARSE_CALLS: Number of Parse Calls ORA_PARSE_CALLS DEC 22
DISK_READS Oracle Monitoring: DISK_READS: # Disk Reads for this Cursor ORA_DISK_READS DEC 22
BUFFER_GETS Oracle Monitoring: BUFFER_GETES: # Buffer Gets for Cursor ORA_BUFFER_GETS DEC 22
ROWS_PROCESSED Oracle Monitoring: ROWS_PROCESSED: Total # Rows returned ORA_ROWS_PROCESSED DEC 22
COMMAND_TYPE Oracle Monitoring: COMMAND_TYPE: Oracle Command Type Def. ORA_COMMAND_TYPE DEC 22
OPTIMIZER_MODE Oracle monitoring: Optimizer mode ORA_OPTIMIZER_MODE2 CHAR 25
PARSING_USER_ID Oracle Monitoring: PARSING_USER_ID: 1st User having parsed ORA_PARSING_USER_ID DEC 22
PARSING_SCHEMA_I Oracle Monitoring: PARSING_SCHEMA_ID ORA_PARSING_SCHEMA_ID DEC 22
KEPT_VERSIONS Oracle Monitoring: KEPT_VERSIONS: Marked to be Kept ORA_KEPT_VERSIONS DEC 22
SQL_MODULE Oracle Monitoring: MODULE: Name of Module Causing Parsing ORA_SQL_MODULE CHAR 64
MODULE_HASH Oracle Monitoring: MODULE_HASH: Hash Value of Parsing Module ORA_SQL_MODULE_HASH DEC 22
ACTION Oracle Monitoring: ACTION ORA_SQL_ACTION CHAR 64
ACTION_HASH Oracle Monitoring: ACTION_HASH: Hash Value of action ORA_SQL_ACTION_HASH DEC 22
SERIALIZABLE_ABO Oracle Monitoring: SERIALIZABLE_ABORTS: # of fails to serial ORA_SERIALIZABLE_ABORTS DEC 22
CPU_TIME Oracle Monitoring: CPU_TIME ORA_CPU_TIME DEC 22
ELAPSED_TIME Oracle Monitoring: ELAPSED_TIME: in microseconds ORA_ELAPSED_TIME DEC 22
IS_OBSOLETE Oracle Monitoring: IS_OBSOLETE ORA_IS_OBSOLETE CHAR 1
CHILD_LATCH Oracle Monitoring: CHILD_LATCH: Child Latch Number ORA_CHILD_LATCH DEC 22
SQL_TXT_LENGTH Oracle Monitoring: Field to store length of long char types ORA_TEXT_LENGTH INT4 10
SQL_TEXT Oracle Monitoring: SQL_TEXT: SQL Text of current cursor ORA_SQL_TEXT LCHR 1000