SAP GVD_SQLTEXT table - Copy of GV$SQLTEXT (currently not provided with snapshots) details in SAP

SAP GVD_SQLTEXT table summary

Object Name: GVD_SQLTEXT
Dictionary Type: Transparent table
Description: Copy of GV$SQLTEXT (currently not provided with snapshots)

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

Details

GVD_SQLTEXT-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_SQLTEXT-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_SQLTEXT-ADDRESS table field - Oracle monitoring: ADDRESS: Address of a cursor ▼

Description: Oracle monitoring: ADDRESS: Address of a cursor
Field Name: ADDRESS
Data Element: ORA_CADDRESS
Data Type: RAW
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: ORA_ADDRESS
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ADDRESS

GVD_SQLTEXT-PIECE table field - Oracle monitoring: PIECE: Seq. No of SQL pieces ▼

Description: Oracle monitoring: PIECE: Seq. No of SQL pieces
Field Name: PIECE
Data Element: ORA_PIECE
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_PIECE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PIECE

GVD_SQLTEXT-HASH_VALUE table field - Oracle monitoring: HASH_VALUE: Cursor hash ▼

Description: Oracle monitoring: HASH_VALUE: Cursor hash
Field Name: HASH_VALUE
Data Element: ORA_CHASH_VALUE
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_HASH_VALUE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field HASH_VALUE

GVD_SQLTEXT-COMMAND_TYPE table field - Oracle monitoring: COMMAND_TYPE: Code for the type of SQL ▼

Description: Oracle monitoring: COMMAND_TYPE: Code for the type of SQL
Field Name: COMMAND_TYPE
Data Element: ORA_CCOMMAND_TYPE
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_COMMAND_TYPE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field COMMAND_TYPE

GVD_SQLTEXT-SQL_TEXT table field - Oracle monitoring: SQL_TEXT: A column containing 1 SQL Text ▼

Description: Oracle monitoring: SQL_TEXT: A column containing 1 SQL Text
Field Name: SQL_TEXT
Data Element: ORA_CSQL_TEXT
Data Type: CHAR
length (Dec): 64(0)
Check table:
Conversion Routine:
Domain Name: ORA_SQL_TEXT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SQL_TEXT

View list of all SAP tables(S4H/ECC)

Select data from SAP table