SAP ORA_LCK table - Structure for the lock monitor details in SAP

SAP ORA_LCK table summary

Object Name: ORA_LCK
Dictionary Type: Structure
Description: Structure for the lock monitor

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

Details

ORA_LCK-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_LCK-INSTANCE_NAME table field - Oracle monitoring: instance_name ▼

Description: Oracle monitoring: instance_name
Field Name: INSTANCE_NAME
Data Element: ORA_INSTANCE_NAME
Data Type: CHAR
length (Dec): 48(0)
Check table:
Conversion Routine:
Domain Name: ORA_LK_INSTNAME
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field INSTANCE_NAME

ORA_LCK-OBJECT_NAME table field - Oracle monitoring: table name ▼

Description: Oracle monitoring: table name
Field Name: OBJECT_NAME
Data Element: ORA_TABLE_NAME
Data Type: CHAR
length (Dec): 30(0)
Check table:
Conversion Routine:
Domain Name: ORA_CHAR_30
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field OBJECT_NAME

ORA_LCK-REQUEST table field - GV$LOCK->REQUEST ▼

Description: GV$LOCK->REQUEST
Field Name: REQUEST
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 REQUEST

ORA_LCK-LMODE table field - GV$LOCK->LMODE ▼

Description: GV$LOCK->LMODE
Field Name: LMODE
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 LMODE

ORA_LCK-STATUS table field - ▼

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

ORA_LCK-SID table field - GV$LOCK->SID ▼

Description: GV$LOCK->SID
Field Name: 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 SID

ORA_LCK-ID1 table field - GV$LOCK->ID1 ▼

Description: GV$LOCK->ID1
Field Name: ID1
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 ID1

ORA_LCK-ID2 table field - GV$LOCK->ID2 ▼

Description: GV$LOCK->ID2
Field Name: ID2
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 ID2

ORA_LCK-TYPE table field - Oracle Monitoring: Type of user or system lock ▼

Description: Oracle Monitoring: Type of user or system lock
Field Name: TYPE
Data Element: ORA_TYPE
Data Type: CHAR
length (Dec): 2(0)
Check table:
Conversion Routine:
Domain Name: ORA_TYPE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TYPE

ORA_LCK-SQL_ADDRESS table field - Oracle monitoring: SQL_ADDRESS: SQL Statement ID ▼

Description: Oracle monitoring: SQL_ADDRESS: SQL Statement ID
Field Name: SQL_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 SQL_ADDRESS

ORA_LCK-SQL_HASH_VALUE table field - Oracle monitoring: SQL_HASH_VALUE: SQL statement hash ▼

Description: Oracle monitoring: SQL_HASH_VALUE: SQL statement hash
Field Name: SQL_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 SQL_HASH_VALUE

ORA_LCK-SPID table field - Oracle monitoring: Operating system process identifier ▼

Description: Oracle monitoring: Operating system process identifier
Field Name: SPID
Data Element: ORA_SPID
Data Type: CHAR
length (Dec): 12(0)
Check table:
Conversion Routine:
Domain Name: ORA_CHAR_12
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SPID

ORA_LCK-PID table field - GV$PROCESS->PID ▼

Description: GV$PROCESS->PID
Field Name: PID
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 PID

ORA_LCK-CTIME table field - GV$LOCK->CTIME ▼

Description: GV$LOCK->CTIME
Field Name: CTIME
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 CTIME

ORA_LCK-BLOCK table field - GV$LOCK->BLOCK ▼

Description: GV$LOCK->BLOCK
Field Name: BLOCK
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 BLOCK

ORA_LCK-PROCESS table field - ▼

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

ORA_LCK-MACHINE table field - ▼

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

ORA_LCK-IPADDRESS table field - IP Address ▼

Description: IP Address
Field Name: IPADDRESS
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 IPADDRESS

View list of all SAP tables(S4H/ECC)

Select data from SAP table