SAP GORAV_SQL_SELECT table - Structure Corresponding to Oracle Table GV$SQL details in SAP

SAP GORAV_SQL_SELECT table summary

Object Name: GORAV_SQL_SELECT
Dictionary Type: Structure
Description: Structure Corresponding to Oracle Table GV$SQL

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

Details

GORAV_SQL_SELECT-INST_ID table field - Oracle Instance ID ▼

Description: Oracle Instance ID
Field Name: INST_ID
Data Element: ORAINST_ID
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: ORANUMBER
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field INST_ID

GORAV_SQL_SELECT-SQL_TEXT table field - Start of SQL statement ▼

Description: Start of SQL statement
Field Name: SQL_TEXT
Data Element: ORASQLTEXT
Data Type: CHAR
length (Dec): 60(0)
Check table:
Conversion Routine:
Domain Name: CHAR60
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SQL_TEXT

GORAV_SQL_SELECT-SHARABLE_MEM table field - Shareable memory ▼

Description: Shareable memory
Field Name: SHARABLE_MEM
Data Element: ORSHARMEM
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: ORAMEMORY
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SHARABLE_MEM

GORAV_SQL_SELECT-PERSISTENT_MEM table field - Persistent memory ▼

Description: Persistent memory
Field Name: PERSISTENT_MEM
Data Element: ORPERSMEM
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: ORAMEMORY
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PERSISTENT_MEM

GORAV_SQL_SELECT-RUNTIME_MEM table field - Ephemeral frame used ▼

Description: Ephemeral frame used
Field Name: RUNTIME_MEM
Data Element: ORRUNTMEM
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: ORAMEMORY
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RUNTIME_MEM

GORAV_SQL_SELECT-SORTS table field - Number of sorts ▼

Description: Number of sorts
Field Name: SORTS
Data Element: ORSORTS
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: ORANUMBER
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SORTS

GORAV_SQL_SELECT-LOADED_VERSIONS table field - Context heap load flag ▼

Description: Context heap load flag
Field Name: LOADED_VERSIONS
Data Element: ORLOADVER
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: ORANUMBER
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LOADED_VERSIONS

GORAV_SQL_SELECT-OPEN_VERSIONS table field - Flag for child cursors is locked ▼

Description: Flag for child cursors is locked
Field Name: OPEN_VERSIONS
Data Element: OROPENVER
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: ORANUMBER
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field OPEN_VERSIONS

GORAV_SQL_SELECT-USERS_OPENING table field - Number of users executing the statement ▼

Description: Number of users executing the statement
Field Name: USERS_OPENING
Data Element: ORUSROPEN
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: ORANUMBER
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field USERS_OPENING

GORAV_SQL_SELECT-EXECUTIONS table field - Number of executions ▼

Description: Number of executions
Field Name: EXECUTIONS
Data Element: OREXECNUM
Data Type: DEC
length (Dec): 31(0)
Check table:
Conversion Routine:
Domain Name: ORAPNUMBER
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field EXECUTIONS

GORAV_SQL_SELECT-FETCHES table field - Total Number of Fetches ▼

Description: Total Number of Fetches
Field Name: FETCHES
Data Element: ORAFETCHES
Data Type: DEC
length (Dec): 31(0)
Check table:
Conversion Routine:
Domain Name: ORAPNUMBER
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field FETCHES

GORAV_SQL_SELECT-USERS_EXECUTING table field - Number of users executing ▼

Description: Number of users executing
Field Name: USERS_EXECUTING
Data Element: ORUSREXEC
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: ORANUMBER
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field USERS_EXECUTING

GORAV_SQL_SELECT-LOADS table field - Number of loads or reloads ▼

Description: Number of loads or reloads
Field Name: LOADS
Data Element: ORALOADS
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: ORANUMB5
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LOADS

GORAV_SQL_SELECT-FIRST_LOAD_TIME table field - Time SQL statement loaded ▼

Description: Time SQL statement loaded
Field Name: FIRST_LOAD_TIME
Data Element: ORALOAD_T
Data Type: CHAR
length (Dec): 19(0)
Check table:
Conversion Routine:
Domain Name: ORATIMESTA
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field FIRST_LOAD_TIME

GORAV_SQL_SELECT-INVALIDATIONS table field - Invalidations for this child cursor ▼

Description: Invalidations for this child cursor
Field Name: INVALIDATIONS
Data Element: ORINVALID
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: ORANUMBER
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field INVALIDATIONS

GORAV_SQL_SELECT-PARSE_CALLS table field - Parse calls for this child cursor ▼

Description: Parse calls for this child cursor
Field Name: PARSE_CALLS
Data Element: ORPARSEC
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: ORANUMBER
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PARSE_CALLS

GORAV_SQL_SELECT-DISK_READS table field - Disk reads for this child cursor ▼

Description: Disk reads for this child cursor
Field Name: DISK_READS
Data Element: ORDISKR
Data Type: DEC
length (Dec): 31(0)
Check table:
Conversion Routine:
Domain Name: ORAPNUMBER
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DISK_READS

GORAV_SQL_SELECT-BUFFER_GETS table field - Buffer gets for this child cursor ▼

Description: Buffer gets for this child cursor
Field Name: BUFFER_GETS
Data Element: ORBUFFERG
Data Type: DEC
length (Dec): 31(0)
Check table:
Conversion Routine:
Domain Name: ORAPNUMBER
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BUFFER_GETS

GORAV_SQL_SELECT-ROWS_PROCESSED table field - Number of rows parsed ▼

Description: Number of rows parsed
Field Name: ROWS_PROCESSED
Data Element: ORROWPROC
Data Type: DEC
length (Dec): 31(0)
Check table:
Conversion Routine:
Domain Name: ORAPNUMBER
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ROWS_PROCESSED

GORAV_SQL_SELECT-PARSING_USER_ID table field - ID of the user who built this child cursor ▼

Description: ID of the user who built this child cursor
Field Name: PARSING_USER_ID
Data Element: ORAPARSUSR
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: ORANUMBER
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PARSING_USER_ID

GORAV_SQL_SELECT-ADDRESS table field - Address of statement in the cache ▼

Description: Address of statement in the cache
Field Name: ADDRESS
Data Element: ORAADDRESS
Data Type: CHAR
length (Dec): 16(0)
Check table:
Conversion Routine:
Domain Name: CHAR16
MemoryID:
AppClass: SLG
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ADDRESS

GORAV_SQL_SELECT-HASH_VALUE table field - Hash value of statement ▼

Description: Hash value of statement
Field Name: HASH_VALUE
Data Element: ORAHASHVAL
Data Type: FLTP
length (Dec): 16(16)
Check table:
Conversion Routine:
Domain Name: ORAP16
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field HASH_VALUE

GORAV_SQL_SELECT-MODULE table field - Program Name ▼

Description: Program Name
Field Name: MODULE
Data Element: ORAMODULE
Data Type: CHAR
length (Dec): 64(0)
Check table:
Conversion Routine:
Domain Name: ORACHAR64
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field MODULE

GORAV_SQL_SELECT-ACTION table field - Action name ▼

Description: Action name
Field Name: ACTION
Data Element: ORAACTION
Data Type: CHAR
length (Dec): 64(0)
Check table:
Conversion Routine:
Domain Name: CHAR64
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ACTION

GORAV_SQL_SELECT-CPU_TIME table field - CPU Time in Miroseconds ▼

Description: CPU Time in Miroseconds
Field Name: CPU_TIME
Data Element: ORACPUTIME
Data Type: DEC
length (Dec): 31(0)
Check table:
Conversion Routine:
Domain Name: ORAPNUMBER
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CPU_TIME

GORAV_SQL_SELECT-ELAPSED_TIME table field - Elapsed Time in Microseconds ▼

Description: Elapsed Time in Microseconds
Field Name: ELAPSED_TIME
Data Element: ORAELAPSED
Data Type: DEC
length (Dec): 31(0)
Check table:
Conversion Routine:
Domain Name: ORAPNUMBER
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ELAPSED_TIME

GORAV_SQL_SELECT-OUTLINE_CATEGORY table field - Category of outline, if used; otherwise blank ▼

Description: Category of outline, if used; otherwise blank
Field Name: OUTLINE_CATEGORY
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field OUTLINE_CATEGORY

GORAV_SQL_SELECT-OUTLINE_SID table field - Outline Session Identifier ▼

Description: Outline Session Identifier
Field Name: OUTLINE_SID
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field OUTLINE_SID

GORAV_SQL_SELECT-LAST_LOAD_TIME table field - Last Load Time ▼

Description: Last Load Time
Field Name: LAST_LOAD_TIME
Data Element: ORALASTLOA
Data Type: CHAR
length (Dec): 19(0)
Check table:
Conversion Routine:
Domain Name: CHAR19
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LAST_LOAD_TIME

GORAV_SQL_SELECT-END_FETCH_CNT table field - Number of Times Cursor Is Fully Executed ▼

Description: Number of Times Cursor Is Fully Executed
Field Name: END_FETCH_CNT
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field END_FETCH_CNT

GORAV_SQL_SELECT-PLSQL_EXEC_TIME table field - PL/SQL Execution Time ▼

Description: PL/SQL Execution Time
Field Name: PLSQL_EXEC_TIME
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PLSQL_EXEC_TIME

GORAV_SQL_SELECT-DIRECT_WRITES table field - Number of Direct Writes for this Child Cursor ▼

Description: Number of Direct Writes for this Child Cursor
Field Name: DIRECT_WRITES
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DIRECT_WRITES

GORAV_SQL_SELECT-SQL_ID table field - SQL_ID ▼

Description: SQL_ID
Field Name: SQL_ID
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SQL_ID

GORAV_SQL_SELECT-LAST_ACTIVE_TIME table field - Time at which the query plan was last active ▼

Description: Time at which the query plan was last active
Field Name: LAST_ACTIVE_TIME
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LAST_ACTIVE_TIME

GORAV_SQL_SELECT-APPLICATION_WAIT_TIME table field - Application Wait Time (in Microseconds) ▼

Description: Application Wait Time (in Microseconds)
Field Name: APPLICATION_WAIT_TIME
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field APPLICATION_WAIT_TIME

GORAV_SQL_SELECT-CONCURRENCY_WAIT_TIME table field - Concurrency Wait Time (in Microseconds) ▼

Description: Concurrency Wait Time (in Microseconds)
Field Name: CONCURRENCY_WAIT_TIME
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CONCURRENCY_WAIT_TIME

GORAV_SQL_SELECT-CLUSTER_WAIT_TIME table field - Cluster Wait Time (in Microseconds) ▼

Description: Cluster Wait Time (in Microseconds)
Field Name: CLUSTER_WAIT_TIME
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CLUSTER_WAIT_TIME

GORAV_SQL_SELECT-USER_IO_WAIT_TIME table field - User I/O Wait Time (in Microseconds) ▼

Description: User I/O Wait Time (in Microseconds)
Field Name: USER_IO_WAIT_TIME
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field USER_IO_WAIT_TIME

GORAV_SQL_SELECT-PLAN_HASH_VALUE table field - Hash Value of Statement (DEC22) ▼

Description: Hash Value of Statement (DEC22)
Field Name: PLAN_HASH_VALUE
Data Element: ORAHASHVALN
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORANUMD22
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PLAN_HASH_VALUE

GORAV_SQL_SELECT-SQL_FULLTEXT table field - Full Text of an SQL Statement ▼

Description: Full Text of an SQL Statement
Field Name: SQL_FULLTEXT
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SQL_FULLTEXT

View list of all SAP tables(S4H/ECC)

Select data from SAP table