SAP LTC_PROTEC_STMT2 table - Latch Monitoring details in SAP

SAP LTC_PROTEC_STMT2 table summary

Object Name: LTC_PROTEC_STMT2
Dictionary Type: Structure
Description: Latch Monitoring

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

Details

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

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

LTC_PROTEC_STMT2-ADDRESS table field - Oracle Monitoring: ADDRESS: @ of Handle to Parent Cursor ▼

Description: Oracle Monitoring: ADDRESS: @ of Handle to Parent Cursor
Field Name: ADDRESS
Data Element: ORA_ADDRESS
Data Type: RAW
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: ORA_RAW_8
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ADDRESS

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

LTC_PROTEC_STMT2-USERNAME table field - Oracle monitoring: USERNAME: Oracle username ▼

Description: Oracle monitoring: USERNAME: Oracle username
Field Name: USERNAME
Data Element: ORA_USERNAME
Data Type: CHAR
length (Dec): 30(0)
Check table:
Conversion Routine:
Domain Name: ORA_USERNAME
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field USERNAME

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

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

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

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

LTC_PROTEC_STMT2-PCALLS_PER_EXE table field - Oracle Monitoring: Parse Calls Per Executions in gv$sql ▼

Description: Oracle Monitoring: Parse Calls Per Executions in gv$sql
Field Name: PCALLS_PER_EXE
Data Element: ORA_PCALLS_PER_EXEC
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PCALLS_PER_EXE

LTC_PROTEC_STMT2-PARSE_CALLS_PCT table field - Oracle Monitoring: Parse Calls of gv$sql in percentage ▼

Description: Oracle Monitoring: Parse Calls of gv$sql in percentage
Field Name: PARSE_CALLS_PCT
Data Element: ORA_PARSE_CALLS_PCT
Data Type: DEC
length (Dec): 8(4)
Check table:
Conversion Routine:
Domain Name: PERCENTAGE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PARSE_CALLS_PCT

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

LTC_PROTEC_STMT2-CPU_TIME_PER_EXE table field - Oracle Monitoring: CPU Time per execution in ms ▼

Description: Oracle Monitoring: CPU Time per execution in ms
Field Name: CPU_TIME_PER_EXE
Data Element: ORA_CPU_TIME_PER_EXEC
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_PER_EXE

LTC_PROTEC_STMT2-CPU_TIME_PCT table field - Oracle Monitoring: CPU Time in percentage ▼

Description: Oracle Monitoring: CPU Time in percentage
Field Name: CPU_TIME_PCT
Data Element: ORA_CPU_TIME_PCT
Data Type: DEC
length (Dec): 8(4)
Check table:
Conversion Routine:
Domain Name: PERCENTAGE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CPU_TIME_PCT

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

LTC_PROTEC_STMT2-ELAPSED_TIME_PER_EXE table field - Oracle Monitoring: Elapsed Time Per Executions in Ms ▼

Description: Oracle Monitoring: Elapsed Time Per Executions in Ms
Field Name: ELAPSED_TIME_PER_EXE
Data Element: ORA_ELAPSED_TIME_PER_EXE
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ELAPSED_TIME_PER_EXE

LTC_PROTEC_STMT2-ELAPSED_TIME_PCT table field - Oracle Monitoring: Elapsed Time in Percentage ▼

Description: Oracle Monitoring: Elapsed Time in Percentage
Field Name: ELAPSED_TIME_PCT
Data Element: ORA_ELAPSED_TIME_PCT
Data Type: DEC
length (Dec): 8(4)
Check table:
Conversion Routine:
Domain Name: PERCENTAGE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ELAPSED_TIME_PCT

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

LTC_PROTEC_STMT2-DISK_READS_PER_EXE table field - Oracle Monitoring: Disk Reads per Executions ▼

Description: Oracle Monitoring: Disk Reads per Executions
Field Name: DISK_READS_PER_EXE
Data Element: ORA_DISK_READS_PER_EXEC
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_PER_EXE

LTC_PROTEC_STMT2-DISK_READS_PCT table field - Oracle Monitoring: Disk Reads in Percentage ▼

Description: Oracle Monitoring: Disk Reads in Percentage
Field Name: DISK_READS_PCT
Data Element: ORA_DISK_READS_PCT
Data Type: DEC
length (Dec): 8(4)
Check table:
Conversion Routine:
Domain Name: PERCENTAGE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DISK_READS_PCT

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

LTC_PROTEC_STMT2-BUFFER_GETS_PER_EXE table field - Oracle Monitoring: Buffer Gets per Executions ▼

Description: Oracle Monitoring: Buffer Gets per Executions
Field Name: BUFFER_GETS_PER_EXE
Data Element: ORA_BUFFER_GETS_PER_EXE
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_PER_EXE

LTC_PROTEC_STMT2-BUFFER_GETS_PCT table field - Oracle Monitoring: Buffer Gets In Percentage ▼

Description: Oracle Monitoring: Buffer Gets In Percentage
Field Name: BUFFER_GETS_PCT
Data Element: ORA_BUFFER_GETS_PCT
Data Type: DEC
length (Dec): 8(4)
Check table:
Conversion Routine:
Domain Name: PERCENTAGE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BUFFER_GETS_PCT

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

LTC_PROTEC_STMT2-ROWS_PROCESSED_PER_EXE table field - Oracle monitoring: Rows Processed per Executions ▼

Description: Oracle monitoring: Rows Processed per Executions
Field Name: ROWS_PROCESSED_PER_EXE
Data Element: ORA_ROWS_PROCESSED_PER_EXE
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_PROCESSED_PER_EXE

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

View list of all SAP tables(S4H/ECC)

Select data from SAP table