SAP ABAP Table GORAV_SQL_SELECT (Structure Corresponding to Oracle Table GV$SQL)
Hierarchy
☛
SAP_BASIS (Software Component) SAP Basis Component
⤷ BC-DB-ORA-SYS (Application Component) Database Interface/DBMS for Oracle
⤷ STUN_ORA (Package) Objects for Performance Analysis (ST04): Oracle DB
⤷ BC-DB-ORA-SYS (Application Component) Database Interface/DBMS for Oracle
⤷ STUN_ORA (Package) Objects for Performance Analysis (ST04): Oracle DB
Basic Data
Table Category | INTTAB | Structure |
Structure | GORAV_SQL_SELECT | Table Relationship Diagram |
Short Description | Structure Corresponding to Oracle Table GV$SQL |
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 | ORAINST_ID | ORANUMBER | INT4 | 10 | 0 | Oracle Instance ID | ||
2 | SQL_TEXT | ORASQLTEXT | CHAR60 | CHAR | 60 | 0 | Start of SQL statement | ||
3 | SHARABLE_MEM | ORSHARMEM | ORAMEMORY | INT4 | 10 | 0 | Shareable memory | ||
4 | PERSISTENT_MEM | ORPERSMEM | ORAMEMORY | INT4 | 10 | 0 | Persistent memory | ||
5 | RUNTIME_MEM | ORRUNTMEM | ORAMEMORY | INT4 | 10 | 0 | Ephemeral frame used | ||
6 | SORTS | ORSORTS | ORANUMBER | INT4 | 10 | 0 | Number of sorts | ||
7 | LOADED_VERSIONS | ORLOADVER | ORANUMBER | INT4 | 10 | 0 | Context heap load flag | ||
8 | OPEN_VERSIONS | OROPENVER | ORANUMBER | INT4 | 10 | 0 | Flag for child cursors is locked | ||
9 | USERS_OPENING | ORUSROPEN | ORANUMBER | INT4 | 10 | 0 | Number of users executing the statement | ||
10 | EXECUTIONS | OREXECNUM | ORAPNUMBER | DEC | 31 | 0 | Number of executions | ||
11 | FETCHES | ORAFETCHES | ORAPNUMBER | DEC | 31 | 0 | Total Number of Fetches | ||
12 | USERS_EXECUTING | ORUSREXEC | ORANUMBER | INT4 | 10 | 0 | Number of users executing | ||
13 | LOADS | ORALOADS | ORANUMB5 | INT4 | 10 | 0 | Number of loads or reloads | ||
14 | FIRST_LOAD_TIME | ORALOAD_T | ORATIMESTA | CHAR | 19 | 0 | Time SQL statement loaded | ||
15 | INVALIDATIONS | ORINVALID | ORANUMBER | INT4 | 10 | 0 | Invalidations for this child cursor | ||
16 | PARSE_CALLS | ORPARSEC | ORANUMBER | INT4 | 10 | 0 | Parse calls for this child cursor | ||
17 | DISK_READS | ORDISKR | ORAPNUMBER | DEC | 31 | 0 | Disk reads for this child cursor | ||
18 | BUFFER_GETS | ORBUFFERG | ORAPNUMBER | DEC | 31 | 0 | Buffer gets for this child cursor | ||
19 | ROWS_PROCESSED | ORROWPROC | ORAPNUMBER | DEC | 31 | 0 | Number of rows parsed | ||
20 | PARSING_USER_ID | ORAPARSUSR | ORANUMBER | INT4 | 10 | 0 | ID of the user who built this child cursor | ||
21 | ADDRESS | ORAADDRESS | CHAR16 | CHAR | 16 | 0 | Address of statement in the cache | ||
22 | HASH_VALUE | ORAHASHVAL | ORAP16 | FLTP | 16 | 16 | Hash value of statement | ||
23 | MODULE | ORAMODULE | ORACHAR64 | CHAR | 64 | 0 | Program Name | ||
24 | ACTION | ORAACTION | CHAR64 | CHAR | 64 | 0 | Action name | ||
25 | CPU_TIME | ORACPUTIME | ORAPNUMBER | DEC | 31 | 0 | CPU Time in Miroseconds | ||
26 | ELAPSED_TIME | ORAELAPSED | ORAPNUMBER | DEC | 31 | 0 | Elapsed Time in Microseconds | ||
27 | OUTLINE_CATEGORY | CHAR | 64 | 0 | |||||
28 | OUTLINE_SID | FLTP | 16 | 16 | |||||
29 | LAST_LOAD_TIME | ORALASTLOA | CHAR19 | CHAR | 19 | 0 | Last Load Time | ||
30 | END_FETCH_CNT | DEC | 31 | 0 | |||||
31 | PLSQL_EXEC_TIME | DEC | 31 | 0 | |||||
32 | DIRECT_WRITES | DEC | 31 | 0 | |||||
33 | SQL_ID | CHAR | 13 | 0 | |||||
34 | LAST_ACTIVE_TIME | CHAR | 19 | 0 | |||||
35 | APPLICATION_WAIT_TIME | DEC | 31 | 0 | |||||
36 | CONCURRENCY_WAIT_TIME | DEC | 31 | 0 | |||||
37 | CLUSTER_WAIT_TIME | DEC | 31 | 0 | |||||
38 | USER_IO_WAIT_TIME | DEC | 31 | 0 | |||||
39 | PLAN_HASH_VALUE | ORAHASHVALN | ORANUMD22 | DEC | 22 | 0 | Hash Value of Statement (DEC22) | ||
40 | SQL_FULLTEXT | STRG | 0 | 0 |
History
Last changed by/on | SAP | 20141013 |
SAP Release Created in | 710 |