SAP ABAP Table GPG_TR_SQLTEXT (PGA Monitoring: (g)v$SQLTEXT table)
Hierarchy
☛
SAP_BASIS (Software Component) SAP Basis Component
⤷
BC-CCM-MON-ORA (Application Component) Oracle Database Monitors
⤷
S_DBMON_ORA_COCKPIT (Package) Database Monitor for Oracle in Cockpit Framework
SAP_BASIS (Software Component) SAP Basis Component⤷
BC-CCM-MON-ORA (Application Component) Oracle Database Monitors⤷
S_DBMON_ORA_COCKPIT (Package) Database Monitor for Oracle in Cockpit Framework
Basic Data
| Table Category | INTTAB | Structure |
| Structure | GPG_TR_SQLTEXT |
Table Relationship Diagram 
|
| Short Description | PGA Monitoring: (g)v$SQLTEXT table |
Delivery and Maintenance
| Pool/cluster | ||
| Delivery Class | ||
| 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 |  INST_ID |
ORA_INST_ID | ORA_INST_ID | DEC | 22 | 0 | Oracle monitor: Instance ID | ||
| 2 | INSTANCE_NAME |
ORA_INSTANCE_NAME | ORA_LK_INSTNAME | CHAR | 48 | 0 | Oracle monitoring: instance_name | ||
| 3 | ADDRESS |
ORA_CADDRESS | ORA_ADDRESS | RAW | 8 | 0 | Oracle monitoring: ADDRESS: Address of a cursor | ||
| 4 | HASH_VALUE |
ORA_CHASH_VALUE | ORA_HASH_VALUE | DEC | 22 | 0 | Oracle monitoring: HASH_VALUE: Cursor hash | ||
| 5 | COMMAND_TYPE |
ORA_CCOMMAND_TYPE | ORA_COMMAND_TYPE | DEC | 22 | 0 | Oracle monitoring: COMMAND_TYPE: Code for the type of SQL | ||
| 6 | PIECE |
ORA_PIECE | ORA_PIECE | DEC | 22 | 0 | Oracle monitoring: PIECE: Seq. No of SQL pieces | ||
| 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 | 20140117 |
| SAP Release Created in | 710 |
