GVD_SQLTEXT - Copy of GV$SQLTEXT (currently not provided with snapshots)
Copy of GV$SQLTEXT (currently not provided with snapshots) information is stored in SAP table GVD_SQLTEXT.
It is part of development package STUN in software component BC-CCM-MON-TUN. This development package consists of objects that can be grouped under "SAP Monitoring Tools".
It is part of development package STUN in software component BC-CCM-MON-TUN. This development package consists of objects that can be grouped under "SAP Monitoring Tools".
Fields for table GVD_SQLTEXT
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| SNAPSHOT_ID | Oracle monitor: snapshot ID | X | ORA_SNAPSHOT_ID | NUMC | 10 | * |
| INST_ID | Oracle monitor: Instance ID | X | ORA_INST_ID | DEC | 12 | |
| ADDRESS | Oracle monitoring: ADDRESS: Address of a cursor | X | ORA_CADDRESS | RAW | 8 | |
| PIECE | Oracle monitoring: PIECE: Seq. No of SQL pieces | X | ORA_PIECE | DEC | 12 | |
| HASH_VALUE | Oracle monitoring: HASH_VALUE: Cursor hash | ORA_CHASH_VALUE | DEC | 12 | ||
| COMMAND_TYPE | Oracle monitoring: COMMAND_TYPE: Code for the type of SQL | ORA_CCOMMAND_TYPE | DEC | 12 | ||
| SQL_TEXT | Oracle monitoring: SQL_TEXT: A column containing 1 SQL Text | ORA_CSQL_TEXT | CHAR | 64 |