SAP ORA_TABLE_ACCESS table - Structure for the table access monitor details in SAP


SAP ORA_TABLE_ACCESS table summary

Object Name: ORA_TABLE_ACCESS
Dictionary Type: Structure
Description: Structure for the table access monitor


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

Details
ORA_TABLE_ACCESS-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

ORA_TABLE_ACCESS-OWNER table field - Table Owner

Description: Table Owner
Field Name: OWNER
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 OWNER

ORA_TABLE_ACCESS-TABLE_NAME table field - Table Name

Description: Table Name
Field Name: TABLE_NAME
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 TABLE_NAME

ORA_TABLE_ACCESS-SIZE_KB table field - Size (kB)

Description: Size (kB)
Field Name: SIZE_KB
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 SIZE_KB

ORA_TABLE_ACCESS-TYPE table field - Table Type

Description: Table Type
Field Name: TYPE
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 TYPE

ORA_TABLE_ACCESS-BUFFER_POOL table field - Buffer pool of the table

Description: Buffer pool of the table
Field Name: BUFFER_POOL
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 BUFFER_POOL

ORA_TABLE_ACCESS-OPERATION table field - Type of SQL Operation

Description: Type of SQL Operation
Field Name: OPERATION
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 OPERATION

ORA_TABLE_ACCESS-SQL_TEXT table field - Text of the SQL statement

Description: Text of the SQL statement
Field Name: SQL_TEXT
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_TEXT

ORA_TABLE_ACCESS-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

ORA_TABLE_ACCESS-ACTION table field - Oracle Monitoring: gv$sql action

Description: Oracle Monitoring: gv$sql action
Field Name: ACTION
Data Element: ORA_ACTION_LATCH
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

ORA_TABLE_ACCESS-EXECUTIONS table field - Number of Executions

Description: Number of Executions
Field Name: EXECUTIONS
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 EXECUTIONS

ORA_TABLE_ACCESS-CACHE_HIT_RAT table field - Cache Hit Ratio

Description: Cache Hit Ratio
Field Name: CACHE_HIT_RAT
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 CACHE_HIT_RAT

ORA_TABLE_ACCESS-DISK_READS table field - Number of Disk Reads

Description: Number of Disk Reads
Field Name: DISK_READS
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 DISK_READS

ORA_TABLE_ACCESS-DISK_READ_RAT table field - Disk Read Ratio

Description: Disk Read Ratio
Field Name: DISK_READ_RAT
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 DISK_READ_RAT

ORA_TABLE_ACCESS-BUFFER_GETS table field - Buffer Gets

Description: Buffer Gets
Field Name: BUFFER_GETS
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 BUFFER_GETS

ORA_TABLE_ACCESS-LOG_READ_RAT table field - Log Read Ratio

Description: Log Read Ratio
Field Name: LOG_READ_RAT
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 LOG_READ_RAT

ORA_TABLE_ACCESS-ROWS_PROC table field - Number of Rows Processed

Description: Number of Rows Processed
Field Name: ROWS_PROC
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 ROWS_PROC

ORA_TABLE_ACCESS-ROWS_PER_EXEC table field - Average Number of Rows processed per Execution

Description: Average Number of Rows processed per Execution
Field Name: ROWS_PER_EXEC
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 ROWS_PER_EXEC

ORA_TABLE_ACCESS-BUFFGETS_PER_ROW table field - Number of Buffer Gets per Row

Description: Number of Buffer Gets per Row
Field Name: BUFFGETS_PER_ROW
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 BUFFGETS_PER_ROW

ORA_TABLE_ACCESS-SORTS table field - Number of Sorts

Description: Number of Sorts
Field Name: SORTS
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 SORTS

ORA_TABLE_ACCESS-CPU_TIME table field - CPU time (milliseconds)

Description: CPU time (milliseconds)
Field Name: CPU_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 CPU_TIME

ORA_TABLE_ACCESS-USER_OPEN table field - Users Opening

Description: Users Opening
Field Name: USER_OPEN
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_OPEN

ORA_TABLE_ACCESS-OPENING_VERS table field - Opening Versions

Description: Opening Versions
Field Name: OPENING_VERS
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 OPENING_VERS

ORA_TABLE_ACCESS-LOAD_VERS table field - Loaded Versions

Description: Loaded Versions
Field Name: LOAD_VERS
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 LOAD_VERS

ORA_TABLE_ACCESS-NB_CHILDS table field - Number of Childs

Description: Number of Childs
Field Name: NB_CHILDS
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 NB_CHILDS

ORA_TABLE_ACCESS-SH_MEM table field - Sharable Memory

Description: Sharable Memory
Field Name: SH_MEM
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 SH_MEM

ORA_TABLE_ACCESS-PERS_MEM table field - Persistent Memory

Description: Persistent Memory
Field Name: PERS_MEM
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 PERS_MEM

ORA_TABLE_ACCESS-RUNTIME_MEM table field - Runtime Memory

Description: Runtime Memory
Field Name: RUNTIME_MEM
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 RUNTIME_MEM

ORA_TABLE_ACCESS-INVALIDATIONS table field - Number of Invalidations

Description: Number of Invalidations
Field Name: INVALIDATIONS
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 INVALIDATIONS

ORA_TABLE_ACCESS-PARSE_CALL table field - Parse Calls

Description: Parse Calls
Field Name: PARSE_CALL
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 PARSE_CALL

ORA_TABLE_ACCESS-ITL_WAITS table field - ITL Waits

Description: ITL Waits
Field Name: ITL_WAITS
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 ITL_WAITS

ORA_TABLE_ACCESS-BUFF_BUSY_W table field - Buffer Busy Waits

Description: Buffer Busy Waits
Field Name: BUFF_BUSY_W
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 BUFF_BUSY_W

ORA_TABLE_ACCESS-DB_BLOCK_CHANGES table field - DB Block Changes

Description: DB Block Changes
Field Name: DB_BLOCK_CHANGES
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 DB_BLOCK_CHANGES

ORA_TABLE_ACCESS-GLOB_CACHE_CR table field - Global Cache CR Blocks Served

Description: Global Cache CR Blocks Served
Field Name: GLOB_CACHE_CR
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 GLOB_CACHE_CR

ORA_TABLE_ACCESS-GLOBAL_CACHE_CUR table field - Global Cache Current Blocks Served

Description: Global Cache Current Blocks Served
Field Name: GLOBAL_CACHE_CUR
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 GLOBAL_CACHE_CUR

ORA_TABLE_ACCESS-LOGICAL_READS table field - Logical Reads

Description: Logical Reads
Field Name: LOGICAL_READS
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 LOGICAL_READS

ORA_TABLE_ACCESS-PHYSICAL_READS table field - Physical Reads

Description: Physical Reads
Field Name: PHYSICAL_READS
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 PHYSICAL_READS

ORA_TABLE_ACCESS-PHYS_READS_DIR table field - Physical Reads Direct

Description: Physical Reads Direct
Field Name: PHYS_READS_DIR
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 PHYS_READS_DIR

ORA_TABLE_ACCESS-PHYSICAL_WRITES table field - Physical Writes

Description: Physical Writes
Field Name: PHYSICAL_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 PHYSICAL_WRITES

ORA_TABLE_ACCESS-PHYS_WRITES_DIR table field - Physical Writes Direct

Description: Physical Writes Direct
Field Name: PHYS_WRITES_DIR
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 PHYS_WRITES_DIR

ORA_TABLE_ACCESS-ROW_LOCK_WAITS table field - Row Lock Waits

Description: Row Lock Waits
Field Name: ROW_LOCK_WAITS
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 ROW_LOCK_WAITS

ORA_TABLE_ACCESS-ADDRESS table field - Oracle monitoring: SQL_ADDRESS: SQL Statement ID

Description: Oracle monitoring: SQL_ADDRESS: SQL Statement ID
Field Name: ADDRESS
Data Element: ORA_SQL_ADDRESS
Data Type: RAW
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: ORA_SQL_ADDRESS
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ADDRESS

ORA_TABLE_ACCESS-HASH_VALUE table field - Oracle monitoring: SQL_HASH_VALUE: SQL statement hash

Description: Oracle monitoring: SQL_HASH_VALUE: SQL statement hash
Field Name: HASH_VALUE
Data Element: ORA_SQL_HASH_VALUE
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_SQL_HASH_VALUE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field HASH_VALUE

ORA_TABLE_ACCESS-SQL_ID table field - Oracle monitoring: SQL_ID

Description: Oracle monitoring: SQL_ID
Field Name: SQL_ID
Data Element: ORA_SQL_ID
Data Type: CHAR
length (Dec): 13(0)
Check table:
Conversion Routine:
Domain Name: ORA_SQLID
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SQL_ID

ORA_TABLE_ACCESS-CHILD_NUMBER table field - Oracle monitoring: SQL child number

Description: Oracle monitoring: SQL child number
Field Name: CHILD_NUMBER
Data Element: ORA_SQLCHILDNUM
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CHILD_NUMBER


  



View list of all SAP tables(S4H/ECC)

Select data from SAP table