SAP GVD_LOCK table - Copy of GV$LOCK details in SAP


SAP GVD_LOCK table summary

Object Name: GVD_LOCK
Dictionary Type: Transparent table
Description: Copy of GV$LOCK


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

Details
GVD_LOCK-SNAPSHOT_ID table field - Oracle monitor: snapshot ID

Description: Oracle monitor: snapshot ID
Field Name: SNAPSHOT_ID
Data Element: ORA_SNAPSHOT_ID
Data Type: NUMC
length (Dec): 10(0)
Check table: *
Conversion Routine:
Domain Name: ORA_SNAPSHOT_ID
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SNAPSHOT_ID

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

GVD_LOCK-ADDR table field - Oracle monitoring: ADDR

Description: Oracle monitoring: ADDR
Field Name: ADDR
Data Element: ORA_ADDR
Data Type: RAW
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: ORA_ADDR
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ADDR

GVD_LOCK-KADDR table field - Oracle monitoring: KADDR

Description: Oracle monitoring: KADDR
Field Name: KADDR
Data Element: ORA_KADDR
Data Type: RAW
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: ORA_KADDR
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field KADDR

GVD_LOCK-SID table field - Oracle monitoring: SID (Session)

Description: Oracle monitoring: SID (Session)
Field Name: SID
Data Element: ORA_SID
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_SID
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SID

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

GVD_LOCK-ID1 table field - Oracle monitoring: Lock identifier #1 (depends on type)

Description: Oracle monitoring: Lock identifier #1 (depends on type)
Field Name: ID1
Data Element: ORA_ID1
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_ID1
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ID1

GVD_LOCK-ID2 table field - Oracle monitoring: Lock identifier #2 (depends on type)

Description: Oracle monitoring: Lock identifier #2 (depends on type)
Field Name: ID2
Data Element: ORA_ID2
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_ID2
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ID2

GVD_LOCK-LMODE table field - Oracle monitoring: LMODE Lock mode in which the session hold

Description: Oracle monitoring: LMODE Lock mode in which the session hold
Field Name: LMODE
Data Element: ORA_LMODE
Data Type: DEC
length (Dec): 4(0)
Check table:
Conversion Routine:
Domain Name: ORA_LMODE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LMODE

GVD_LOCK-REQUEST table field - Oracle monitoring: Lock mode in which the process requests

Description: Oracle monitoring: Lock mode in which the process requests
Field Name: REQUEST
Data Element: ORA_REQUEST
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_REQUEST
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field REQUEST

GVD_LOCK-CTIME table field - Oracle monitoring: Time since current mode was granted

Description: Oracle monitoring: Time since current mode was granted
Field Name: CTIME
Data Element: ORA_CTIME
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_CTIME
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CTIME

GVD_LOCK-BLOCK table field - Oracle monitoring: The lock is blocking another lock

Description: Oracle monitoring: The lock is blocking another lock
Field Name: BLOCK
Data Element: ORA_BLOCK
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_BLOCK
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BLOCK


  



View list of all SAP tables(S4H/ECC)

Select data from SAP table