SAP GVD_SQLAREA table - Copy of GV$SQLAREA (currently not provided with snapshots) details in SAP

SAP GVD_SQLAREA table summary

Object Name: GVD_SQLAREA
Dictionary Type: Transparent table
Description: Copy of GV$SQLAREA (currently not provided with snapshots)

Field list for GVD_SQLAREA table on an S/4 SAP system

Details

GVD_SQLAREA-SNAPSHOT_ID table field - Oracle monitor: snapshot ID ▼

Description: Oracle monitor: snapshot ID
Field Name: SNAPSHOT_ID
Data Element: ORA_SNAPSHOT_ID
Data Type: NUMC
length (Dec): 10(0)
Check table: *
Conversion Routine:
Domain Name: ORA_SNAPSHOT_ID
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SNAPSHOT_ID

GVD_SQLAREA-INST_ID table field - Oracle monitor: Instance ID ▼

Description: Oracle monitor: Instance ID
Field Name: INST_ID
Data Element: ORA_INST_ID
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_INST_ID
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field INST_ID

GVD_SQLAREA-ADDRESS table field - Oracle monitoring: ADDR ▼

Description: Oracle monitoring: ADDR
Field Name: ADDRESS
Data Element: ORA_ADDR
Data Type: RAW
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: ORA_ADDR
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ADDRESS

GVD_SQLAREA-HASH_VALUE table field - Oracle Monitoring: HASH_VALUE: Hash Value of Parent Statment ▼

Description: Oracle Monitoring: HASH_VALUE: Hash Value of Parent Statment
Field Name: HASH_VALUE
Data Element: ORA_HASH_VALUE
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_NUMBER
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field HASH_VALUE

GVD_SQLAREA-SHARABLE_MEM table field - Oracle Monitoring: SHARABLE_MEM: Shared Memory Used ▼

Description: Oracle Monitoring: SHARABLE_MEM: Shared Memory Used
Field Name: SHARABLE_MEM
Data Element: ORA_SHARABLE_MEM
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_NUMBER
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SHARABLE_MEM

GVD_SQLAREA-PERSISTENT_MEM table field - Oracle Monitoring: PERSISTENT_MEM: Fixed Mem used in lifetim ▼

Description: Oracle Monitoring: PERSISTENT_MEM: Fixed Mem used in lifetim
Field Name: PERSISTENT_MEM
Data Element: ORA_PERSISTENT_MEM
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_NUMBER
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PERSISTENT_MEM

GVD_SQLAREA-RUNTIME_MEM table field - Oracle Monitoring: RUNTIME_MEM: Mem required during Execut. ▼

Description: Oracle Monitoring: RUNTIME_MEM: Mem required during Execut.
Field Name: RUNTIME_MEM
Data Element: ORA_RUNTIME_MEM
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_NUMBER
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RUNTIME_MEM

GVD_SQLAREA-SORTS table field - Oracle Monitoring: SORTS: Number of Sorts Done for cursor ▼

Description: Oracle Monitoring: SORTS: Number of Sorts Done for cursor
Field Name: SORTS
Data Element: ORA_SORTS
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_NUMBER
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SORTS

GVD_SQLAREA-VERSION_COUNT table field - Oracle monitor: version count ▼

Description: Oracle monitor: version count
Field Name: VERSION_COUNT
Data Element: ORA_VERION_COUNT
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_NUM_22
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field VERSION_COUNT

GVD_SQLAREA-LOADED_VERSIONS table field - Oracle Monitoring: LOADED_VERSIONS: Is context Heap Loaded ▼

Description: Oracle Monitoring: LOADED_VERSIONS: Is context Heap Loaded
Field Name: LOADED_VERSIONS
Data Element: ORA_LOADED_VERSIONS
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_NUMBER
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LOADED_VERSIONS

GVD_SQLAREA-OPEN_VERSIONS table field - Oracle Monitoring: OPEN_VERSIONS: Is Child Cursor Locked? ▼

Description: Oracle Monitoring: OPEN_VERSIONS: Is Child Cursor Locked?
Field Name: OPEN_VERSIONS
Data Element: ORA_OPEN_VERSIONS
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_NUMBER
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field OPEN_VERSIONS

GVD_SQLAREA-USERS_OPENING table field - Oracle Monitoring: USERS_OPENING: # of users executing SQL ▼

Description: Oracle Monitoring: USERS_OPENING: # of users executing SQL
Field Name: USERS_OPENING
Data Element: ORA_USERS_OPENING
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_NUMBER
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field USERS_OPENING

GVD_SQLAREA-FETCHES table field - Oracle Monitoring: FETCHES: # Fetches assoc. with statement ▼

Description: Oracle Monitoring: FETCHES: # Fetches assoc. with statement
Field Name: FETCHES
Data Element: ORA_FETCHES
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_NUMBER
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field FETCHES

GVD_SQLAREA-EXECUTIONS table field - Oracle Monitoring: EXECUTIONS: # Executions ▼

Description: Oracle Monitoring: EXECUTIONS: # Executions
Field Name: EXECUTIONS
Data Element: ORA_EXECUTIONS
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_NUMBER
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field EXECUTIONS

GVD_SQLAREA-USERS_EXECUTING table field - Oracle Monitoring: USERS_EXECUTING: # of Users Exec. SQL ▼

Description: Oracle Monitoring: USERS_EXECUTING: # of Users Exec. SQL
Field Name: USERS_EXECUTING
Data Element: ORA_USERS_EXECUTING
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_NUMBER
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field USERS_EXECUTING

GVD_SQLAREA-LOADS table field - Oracle Monitoring: # Times Object was Loaded or Reloaded ▼

Description: Oracle Monitoring: # Times Object was Loaded or Reloaded
Field Name: LOADS
Data Element: ORA_LOADS
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_NUMBER
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LOADS

GVD_SQLAREA-FIRST_LOAD_TIME table field - Oracle Monitoring: FIRST_LOAD_TIME: Timestamp of Creation ▼

Description: Oracle Monitoring: FIRST_LOAD_TIME: Timestamp of Creation
Field Name: FIRST_LOAD_TIME
Data Element: ORA_FIRST_LOAD_TIME
Data Type: CHAR
length (Dec): 19(0)
Check table:
Conversion Routine:
Domain Name: ORA_CHAR_19
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field FIRST_LOAD_TIME

GVD_SQLAREA-INVALIDATIONS table field - Oracle monitoring: # of times objects were marked invalid ▼

Description: Oracle monitoring: # of times objects were marked invalid
Field Name: INVALIDATIONS
Data Element: ORA_SQL_INVALIDATIONS
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_NUM_22
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field INVALIDATIONS

GVD_SQLAREA-PARSE_CALLS table field - Oracle Monitoring: PARSE_CALLS: Number of Parse Calls ▼

Description: Oracle Monitoring: PARSE_CALLS: Number of Parse Calls
Field Name: PARSE_CALLS
Data Element: ORA_PARSE_CALLS
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_NUMBER
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PARSE_CALLS

GVD_SQLAREA-DISK_READS table field - Oracle Monitoring: DISK_READS: # Disk Reads for this Cursor ▼

Description: Oracle Monitoring: DISK_READS: # Disk Reads for this Cursor
Field Name: DISK_READS
Data Element: ORA_DISK_READS
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_NUMBER
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DISK_READS

GVD_SQLAREA-BUFFER_GETS table field - Oracle Monitoring: BUFFER_GETES: # Buffer Gets for Cursor ▼

Description: Oracle Monitoring: BUFFER_GETES: # Buffer Gets for Cursor
Field Name: BUFFER_GETS
Data Element: ORA_BUFFER_GETS
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_NUMBER
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BUFFER_GETS

GVD_SQLAREA-ROWS_PROCESSED table field - Oracle Monitoring: ROWS_PROCESSED: Total # Rows returned ▼

Description: Oracle Monitoring: ROWS_PROCESSED: Total # Rows returned
Field Name: ROWS_PROCESSED
Data Element: ORA_ROWS_PROCESSED
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_NUMBER
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ROWS_PROCESSED

GVD_SQLAREA-COMMAND_TYPE table field - Oracle Monitoring: COMMAND_TYPE: Oracle Command Type Def. ▼

Description: Oracle Monitoring: COMMAND_TYPE: Oracle Command Type Def.
Field Name: COMMAND_TYPE
Data Element: ORA_COMMAND_TYPE
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_NUMBER
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field COMMAND_TYPE

GVD_SQLAREA-OPTIMIZER_MODE table field - Oracle monitoring: Optimizer mode ▼

Description: Oracle monitoring: Optimizer mode
Field Name: OPTIMIZER_MODE
Data Element: ORA_OPTIMIZER_MODE2
Data Type: CHAR
length (Dec): 25(0)
Check table:
Conversion Routine:
Domain Name: ORA_CHAR_25
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field OPTIMIZER_MODE

GVD_SQLAREA-PARSING_USER_ID table field - Oracle Monitoring: PARSING_USER_ID: 1st User having parsed ▼

Description: Oracle Monitoring: PARSING_USER_ID: 1st User having parsed
Field Name: PARSING_USER_ID
Data Element: ORA_PARSING_USER_ID
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_NUMBER
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PARSING_USER_ID

GVD_SQLAREA-PARSING_SCHEMA_I table field - Oracle Monitoring: PARSING_SCHEMA_ID ▼

Description: Oracle Monitoring: PARSING_SCHEMA_ID
Field Name: PARSING_SCHEMA_I
Data Element: ORA_PARSING_SCHEMA_ID
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_NUMBER
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PARSING_SCHEMA_I

GVD_SQLAREA-KEPT_VERSIONS table field - Oracle Monitoring: KEPT_VERSIONS: Marked to be Kept ▼

Description: Oracle Monitoring: KEPT_VERSIONS: Marked to be Kept
Field Name: KEPT_VERSIONS
Data Element: ORA_KEPT_VERSIONS
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_NUMBER
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field KEPT_VERSIONS

GVD_SQLAREA-SQL_MODULE table field - Oracle Monitoring: MODULE: Name of Module Causing Parsing ▼

Description: Oracle Monitoring: MODULE: Name of Module Causing Parsing
Field Name: SQL_MODULE
Data Element: ORA_SQL_MODULE
Data Type: CHAR
length (Dec): 64(0)
Check table:
Conversion Routine:
Domain Name: ORA_CHAR_64
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SQL_MODULE

GVD_SQLAREA-MODULE_HASH table field - Oracle Monitoring: MODULE_HASH: Hash Value of Parsing Module ▼

Description: Oracle Monitoring: MODULE_HASH: Hash Value of Parsing Module
Field Name: MODULE_HASH
Data Element: ORA_SQL_MODULE_HASH
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_NUMBER
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field MODULE_HASH

GVD_SQLAREA-ACTION table field - Oracle Monitoring: ACTION ▼

Description: Oracle Monitoring: ACTION
Field Name: ACTION
Data Element: ORA_SQL_ACTION
Data Type: CHAR
length (Dec): 64(0)
Check table:
Conversion Routine:
Domain Name: ORA_CHAR_64
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ACTION

GVD_SQLAREA-ACTION_HASH table field - Oracle Monitoring: ACTION_HASH: Hash Value of action ▼

Description: Oracle Monitoring: ACTION_HASH: Hash Value of action
Field Name: ACTION_HASH
Data Element: ORA_SQL_ACTION_HASH
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_NUMBER
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ACTION_HASH

GVD_SQLAREA-SERIALIZABLE_ABO table field - Oracle Monitoring: SERIALIZABLE_ABORTS: # of fails to serial ▼

Description: Oracle Monitoring: SERIALIZABLE_ABORTS: # of fails to serial
Field Name: SERIALIZABLE_ABO
Data Element: ORA_SERIALIZABLE_ABORTS
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_NUMBER
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SERIALIZABLE_ABO

GVD_SQLAREA-CPU_TIME table field - Oracle Monitoring: CPU_TIME ▼

Description: Oracle Monitoring: CPU_TIME
Field Name: CPU_TIME
Data Element: ORA_CPU_TIME
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_NUMBER
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CPU_TIME

GVD_SQLAREA-ELAPSED_TIME table field - Oracle Monitoring: ELAPSED_TIME: in microseconds ▼

Description: Oracle Monitoring: ELAPSED_TIME: in microseconds
Field Name: ELAPSED_TIME
Data Element: ORA_ELAPSED_TIME
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_NUMBER
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ELAPSED_TIME

GVD_SQLAREA-IS_OBSOLETE table field - Oracle Monitoring: IS_OBSOLETE ▼

Description: Oracle Monitoring: IS_OBSOLETE
Field Name: IS_OBSOLETE
Data Element: ORA_IS_OBSOLETE
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: ORA_CHAR_1
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field IS_OBSOLETE

GVD_SQLAREA-CHILD_LATCH table field - Oracle Monitoring: CHILD_LATCH: Child Latch Number ▼

Description: Oracle Monitoring: CHILD_LATCH: Child Latch Number
Field Name: CHILD_LATCH
Data Element: ORA_CHILD_LATCH
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_NUMBER
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CHILD_LATCH

GVD_SQLAREA-SQL_TXT_LENGTH table field - Oracle Monitoring: Field to store length of long char types ▼

Description: Oracle Monitoring: Field to store length of long char types
Field Name: SQL_TXT_LENGTH
Data Element: ORA_TEXT_LENGTH
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: ORA_LCHAR_LENGTH
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SQL_TXT_LENGTH

GVD_SQLAREA-SQL_TEXT table field - Oracle Monitoring: SQL_TEXT: SQL Text of current cursor ▼

Description: Oracle Monitoring: SQL_TEXT: SQL Text of current cursor
Field Name: SQL_TEXT
Data Element: ORA_SQL_TEXT
Data Type: LCHR
length (Dec): 1000(0)
Check table:
Conversion Routine:
Domain Name: ORA_CHAR_1000
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SQL_TEXT

View list of all SAP tables(S4H/ECC)

Select data from SAP table