SAP ORA_TABACCESS table - Oracle Table Access Monitor Structure details in SAP


SAP ORA_TABACCESS table summary

Object Name: ORA_TABACCESS
Dictionary Type: Structure
Description: Oracle Table Access Monitor Structure


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

Details
ORA_TABACCESS-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_TABACCESS-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_TABACCESS-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_TABACCESS-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_TABACCESS-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_TABACCESS-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_TABACCESS-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_TABACCESS-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_TABACCESS-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_TABACCESS-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_TABACCESS-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_TABACCESS-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_TABACCESS-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_TABACCESS-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_TABACCESS-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_TABACCESS-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_TABACCESS-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_TABACCESS-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_TABACCESS-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_TABACCESS-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_TABACCESS-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_TABACCESS-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_TABACCESS-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_TABACCESS-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_TABACCESS-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_TABACCESS-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_TABACCESS-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_TABACCESS-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_TABACCESS-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_TABACCESS-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_TABACCESS-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_TABACCESS-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_TABACCESS-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_TABACCESS-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