SAP Table GVD_SQLTEXT

Copy of GV$SQLTEXT (currently not provided with snapshots)

The table GVD_SQLTEXT (Copy of GV$SQLTEXT (currently not provided with snapshots)) is a standard table in SAP ERP. It belongs to the package STUN.

Technical Information

Table	GVD_SQLTEXT
Short Text	Copy of GV$SQLTEXT (currently not provided with snapshots)
Package	STUN
Table Type	Transparent Table

Fields for Table GVD_SQLTEXT

Field Name	Key	Description	Data Element	Type	Length	Check Table
SNAPSHOT_ID	✔	Oracle monitor: snapshot ID	ORA_SNAPSHOT_ID	NUMC	10	*
INST_ID	✔	Oracle monitor: Instance ID	ORA_INST_ID	DEC	22
ADDRESS	✔	Oracle monitoring: ADDRESS: Address of a cursor	ORA_CADDRESS	RAW	8
PIECE	✔	Oracle monitoring: PIECE: Seq. No of SQL pieces	ORA_PIECE	DEC	22
HASH_VALUE		Oracle monitoring: HASH_VALUE: Cursor hash	ORA_CHASH_VALUE	DEC	22
COMMAND_TYPE		Oracle monitoring: COMMAND_TYPE: Code for the type of SQL	ORA_CCOMMAND_TYPE	DEC	22
SQL_TEXT		Oracle monitoring: SQL_TEXT: A column containing 1 SQL Text	ORA_CSQL_TEXT	CHAR	64