SAP ABAP Table GVD_SQLTEXT (Copy of GV$SQLTEXT (currently not provided with snapshots))
Hierarchy
☛
SAP_BASIS (Software Component) SAP Basis Component
⤷
BC-CCM-MON-TUN (Application Component) Performance Monitors (TCC)
⤷
STUN (Package) DBA: All the rest in English
SAP_BASIS (Software Component) SAP Basis Component⤷
BC-CCM-MON-TUN (Application Component) Performance Monitors (TCC)⤷
STUN (Package) DBA: All the rest in English
Basic Data
| Table Category | TRANSP | Transparent table |
| Transparent table | GVD_SQLTEXT |
Table Relationship Diagram 
|
| Short Description | Copy of GV$SQLTEXT (currently not provided with snapshots) |
Delivery and Maintenance
| Pool/cluster | ||
| Delivery Class | L | Table for storing temporary data, delivered empty |
| Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
 |
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|---|---|---|---|---|---|---|---|---|---|
| 1 |  SNAPSHOT_ID |
ORA_SNAPSHOT_ID | ORA_SNAPSHOT_ID | NUMC | 10 | 0 | Oracle monitor: snapshot ID | * | |
| 2 | INST_ID |
ORA_INST_ID | ORA_INST_ID | DEC | 22 | 0 | Oracle monitor: Instance ID | ||
| 3 | ADDRESS |
ORA_CADDRESS | ORA_ADDRESS | RAW | 8 | 0 | Oracle monitoring: ADDRESS: Address of a cursor | ||
| 4 | PIECE |
ORA_PIECE | ORA_PIECE | DEC | 22 | 0 | Oracle monitoring: PIECE: Seq. No of SQL pieces | ||
| 5 | HASH_VALUE |
ORA_CHASH_VALUE | ORA_HASH_VALUE | DEC | 22 | 0 | Oracle monitoring: HASH_VALUE: Cursor hash | ||
| 6 | COMMAND_TYPE |
ORA_CCOMMAND_TYPE | ORA_COMMAND_TYPE | DEC | 22 | 0 | Oracle monitoring: COMMAND_TYPE: Code for the type of SQL | ||
| 7 | SQL_TEXT |
ORA_CSQL_TEXT | ORA_SQL_TEXT | CHAR | 64 | 0 | Oracle monitoring: SQL_TEXT: A column containing 1 SQL Text |
History
| Last changed by/on | SAP | 20130604 |
| SAP Release Created in | 700 |
