SAP ABAP Table ORASAREA_A (Structure for Field Catalog Creation "Cursor Cache Stats")
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 | ORASAREA_A | Table Relationship Diagram |
Short Description | Structure for Field Catalog Creation "Cursor Cache Stats" |
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 | .INCLUDE | 0 | 0 | Structure for Base List: "Oracle Cursor Cache Statistics" | |||||
2 | EXECUTIONS | ORAEXECNUM | ORAPNUMBER | DEC | 31 | 0 | Total number of executions | ||
3 | CURR_EXEC | ORACURREX | ORANUMB7 | INT4 | 10 | 0 | Number of users executing this cursor | ||
4 | DISK_READS | ORADISKR | ORAPNUMBER | DEC | 31 | 0 | Sum of all 'disk reads' | ||
5 | DISKRPER_E | ORADRPERE | ORADEC16 | DEC | 31 | 1 | Number of 'disk reads' for each execution | ||
6 | BUFFER_GET | ORABUFFERG | ORAPNUMBER | DEC | 31 | 0 | Total number of "buffer gets" | ||
7 | BUFFGPER_E | ORABGPERE | ORADEC16 | DEC | 31 | 1 | Number of 'buffer gets' for each execution | ||
8 | ROWS_PROCE | ORAROWPROC | ORAPNUMBER | DEC | 31 | 0 | Number of processed rows | ||
9 | ROWSPPER_E | ORARPPERE | ORADEC16 | DEC | 31 | 1 | Number of rows processed for each execution | ||
10 | BUFFGPER_R | ORABGPERR | ORADEC16 | DEC | 31 | 1 | Number of 'buffer gets' for each row | ||
11 | SORTS | ORASQLSORT | ORANUMB8 | INT4 | 10 | 0 | Sort orders | ||
12 | CPU_TIME | ORACPUTIME | ORAPNUMBER | DEC | 31 | 0 | CPU Time in Miroseconds | ||
13 | CPU_TIME_E | ORACTPERE | ORADEC16 | DEC | 31 | 1 | CPU Time per Execution | ||
14 | ELAPSED_TI | ORAELAPSED | ORAPNUMBER | DEC | 31 | 0 | Elapsed Time in Microseconds | ||
15 | ELAPSEDTIE | ORAELAPERE | ORADEC16 | DEC | 31 | 1 | Elapsed Time per Execution | ||
16 | WAIT_TIME | ORAWAITTIM | ORAPNUMBER | DEC | 31 | 0 | Wait time | ||
17 | WAITTIME_E | ORAWTPERE | ORADEC16 | DEC | 31 | 1 | Wait Time per Execution | ||
18 | SQL_TEXT | ORASQLTEXT | CHAR60 | CHAR | 60 | 0 | Start of SQL statement | ||
19 | .INCLUDE | 0 | 0 | Additional Fields for "Oracle Cursor Cache Stats" List | |||||
20 | OPEN_VERSI | ORAOPENVER | ORANUMB8 | INT4 | 10 | 0 | Number of opened cursor versions | ||
21 | USERS_OPEN | ORAUSROPEN | ORANUMB8 | INT4 | 10 | 0 | Number of users who have opened cursor version | ||
22 | LOADED_VER | ORALOADVER | ORANUMB8 | INT4 | 10 | 0 | Loaded cursor versions | ||
23 | SHARABLE_M | ORASHARMEM | ORAPNUMBER | DEC | 31 | 0 | Total shareable memory | ||
24 | PERSISTENT | ORAPERSMEM | ORAMEMORY | INT4 | 10 | 0 | Total 'persistent memory' | ||
25 | RUNTIME_ME | ORARUNTMEM | ORAMEMORY | INT4 | 10 | 0 | Total "runtime memory" | ||
26 | INVALIDATI | ORAINVALID | ORANUMB8 | INT4 | 10 | 0 | Number of 'invalidations' for all versions | ||
27 | LOADS | ORALOADS | ORANUMB5 | INT4 | 10 | 0 | Number of loads or reloads | ||
28 | PARSE_CALL | ORAPARSEC | ORANUMB8 | INT4 | 10 | 0 | Sum of all 'parse calls' | ||
29 | MODULE | ORAMODULE | ORACHAR64 | CHAR | 64 | 0 | Program Name | ||
30 | DB_USER | ORAUSER | CHAR10 | CHAR | 10 | 0 | Column USERNAME in V$SESSION | ||
31 | FIRST_LOAD | ORALOAD_T | ORATIMESTA | CHAR | 19 | 0 | Time SQL statement loaded |
History
Last changed by/on | SAP | 20130604 |
SAP Release Created in |