Data Element list used by SAP ABAP Table GVD_SQL (Copy of GV$SQL (currently not provided with snapshots))
SAP ABAP Table GVD_SQL (Copy of GV$SQL (currently not provided with snapshots)) is using
# | Object Type | Object Name | Object Description | Note |
---|---|---|---|---|
1 | Data Element | ORA_ADDRESS | Oracle Monitoring: ADDRESS: @ of Handle to Parent Cursor | |
2 | Data Element | ORA_BUFFER_GETS | Oracle Monitoring: BUFFER_GETES: # Buffer Gets for Cursor | |
3 | Data Element | ORA_CHILD_ADDRESS | Oracle Monitoring: CHILD_ADDRESS: @ of Child Cursor | |
4 | Data Element | ORA_CHILD_LATCH | Oracle Monitoring: CHILD_LATCH: Child Latch Number | |
5 | Data Element | ORA_CHILD_NUMBER | Oracle Monitoring: CHILD_NUMBER | |
6 | Data Element | ORA_COMMAND_TYPE | Oracle Monitoring: COMMAND_TYPE: Oracle Command Type Def. | |
7 | Data Element | ORA_CPU_TIME | Oracle Monitoring: CPU_TIME | |
8 | Data Element | ORA_DISK_READS | Oracle Monitoring: DISK_READS: # Disk Reads for this Cursor | |
9 | Data Element | ORA_ELAPSED_TIME | Oracle Monitoring: ELAPSED_TIME: in microseconds | |
10 | Data Element | ORA_EXECUTIONS | Oracle Monitoring: EXECUTIONS: # Executions | |
11 | Data Element | ORA_FETCHES | Oracle Monitoring: FETCHES: # Fetches assoc. with statement | |
12 | Data Element | ORA_FIRST_LOAD_TIME | Oracle Monitoring: FIRST_LOAD_TIME: Timestamp of Creation | |
13 | Data Element | ORA_HASH_VALUE | Oracle Monitoring: HASH_VALUE: Hash Value of Parent Statment | |
14 | Data Element | ORA_INST_ID | Oracle monitor: Instance ID | |
15 | Data Element | ORA_IS_OBSOLETE | Oracle Monitoring: IS_OBSOLETE | |
16 | Data Element | ORA_KEPT_VERSIONS | Oracle Monitoring: KEPT_VERSIONS: Marked to be Kept | |
17 | Data Element | ORA_LAST_LOAD_TIME | Oracle Monitoring: LAST_LOAD_TIME | |
18 | Data Element | ORA_LITERAL_HASH_VALUE | Oracle Monitoring: LITERAL_HASH_VALUE: H val of replaced lit | |
19 | Data Element | ORA_LOADED_VERSIONS | Oracle Monitoring: LOADED_VERSIONS: Is context Heap Loaded | |
20 | Data Element | ORA_LOADS | Oracle Monitoring: # Times Object was Loaded or Reloaded | |
21 | Data Element | ORA_OBJECT_STATUS | Oracle Monitoring: OBJECT_STATUS | |
22 | Data Element | ORA_OPEN_VERSIONS | Oracle Monitoring: OPEN_VERSIONS: Is Child Cursor Locked? | |
23 | Data Element | ORA_OPTIMIZER_COST | Oracle Monitoring: OPTIMIZER_COST: Cost of Execution | |
24 | Data Element | ORA_OPTIMIZER_MODE | Oracle Monitoring: OPTIMIZER_MODE: Mode of SQL Execution | |
25 | Data Element | ORA_OUTLINE_CATEGORY | Oracle Monitoring: OUTLINE_CATEGORY: If outline, its catgory | |
26 | Data Element | ORA_OUTLINE_SID | Oracle Monitoring: OUTLINE_SID: Outline Session ID | |
27 | Data Element | ORA_PARSE_CALLS | Oracle Monitoring: PARSE_CALLS: Number of Parse Calls | |
28 | Data Element | ORA_PARSING_SCHEMA_ID | Oracle Monitoring: PARSING_SCHEMA_ID | |
29 | Data Element | ORA_PARSING_USER_ID | Oracle Monitoring: PARSING_USER_ID: 1st User having parsed | |
30 | Data Element | ORA_PERSISTENT_MEM | Oracle Monitoring: PERSISTENT_MEM: Fixed Mem used in lifetim | |
31 | Data Element | ORA_PLAN_HASH_VALUE | Oracle Monitoring: PLAN_HASH_VALUE: Represent. of SQL Plan | |
32 | Data Element | ORA_REMOTE | Oracle Monitoring: REMOTE: Is Remote Mapped? | |
33 | Data Element | ORA_ROWS_PROCESSED | Oracle Monitoring: ROWS_PROCESSED: Total # Rows returned | |
34 | Data Element | ORA_RUNTIME_MEM | Oracle Monitoring: RUNTIME_MEM: Mem required during Execut. | |
35 | Data Element | ORA_SERIALIZABLE_ABORTS | Oracle Monitoring: SERIALIZABLE_ABORTS: # of fails to serial | |
36 | Data Element | ORA_SHARABLE_MEM | Oracle Monitoring: SHARABLE_MEM: Shared Memory Used | |
37 | Data Element | ORA_SNAPSHOT_ID | Oracle monitor: snapshot ID | |
38 | Data Element | ORA_SORTS | Oracle Monitoring: SORTS: Number of Sorts Done for cursor | |
39 | Data Element | ORA_SQLTYPE | Oracle Monitoring: SQLTYPE: SQL Version used | |
40 | Data Element | ORA_SQL_ACTION | Oracle Monitoring: ACTION | |
41 | Data Element | ORA_SQL_ACTION_HASH | Oracle Monitoring: ACTION_HASH: Hash Value of action | |
42 | Data Element | ORA_SQL_INVALIDATIONS | Oracle monitoring: # of times objects were marked invalid | |
43 | Data Element | ORA_SQL_MODULE | Oracle Monitoring: MODULE: Name of Module Causing Parsing | |
44 | Data Element | ORA_SQL_MODULE_HASH | Oracle Monitoring: MODULE_HASH: Hash Value of Parsing Module | |
45 | Data Element | ORA_SQL_TEXT | Oracle Monitoring: SQL_TEXT: SQL Text of current cursor | |
46 | Data Element | ORA_TEXT_LENGTH | Oracle Monitoring: Field to store length of long char types | |
47 | Data Element | ORA_TYPE_CHK_HEAP | Oracle Monitoring: TYPE_CHK_HEAP: Type Check Heap Descriptor | |
48 | Data Element | ORA_USERS_EXECUTING | Oracle Monitoring: USERS_EXECUTING: # of Users Exec. SQL | |
49 | Data Element | ORA_USERS_OPENING | Oracle Monitoring: USERS_OPENING: # of users executing SQL |