SAP ABAP Table ORASAREA_B (Structure for Base List: "Oracle Cursor Cache Statistics")
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

⤷

⤷

Basic Data
Table Category | INTTAB | Structure |
Structure | ORASAREA_B |
![]() |
Short Description | Structure for Base List: "Oracle Cursor Cache Statistics" |
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 | ![]() |
ORAEXECNUM | ORAPNUMBER | DEC | 31 | 0 | Total number of executions | ||
2 | ![]() |
ORACURREX | ORANUMB7 | INT4 | 10 | 0 | Number of users executing this cursor | ||
3 | ![]() |
ORADISKR | ORAPNUMBER | DEC | 31 | 0 | Sum of all 'disk reads' | ||
4 | ![]() |
ORADRPERE | ORADEC16 | DEC | 31 | 1 | Number of 'disk reads' for each execution | ||
5 | ![]() |
ORABUFFERG | ORAPNUMBER | DEC | 31 | 0 | Total number of "buffer gets" | ||
6 | ![]() |
ORABGPERE | ORADEC16 | DEC | 31 | 1 | Number of 'buffer gets' for each execution | ||
7 | ![]() |
ORAROWPROC | ORAPNUMBER | DEC | 31 | 0 | Number of processed rows | ||
8 | ![]() |
ORARPPERE | ORADEC16 | DEC | 31 | 1 | Number of rows processed for each execution | ||
9 | ![]() |
ORABGPERR | ORADEC16 | DEC | 31 | 1 | Number of 'buffer gets' for each row | ||
10 | ![]() |
ORASQLSORT | ORANUMB8 | INT4 | 10 | 0 | Sort orders | ||
11 | ![]() |
ORACPUTIME | ORAPNUMBER | DEC | 31 | 0 | CPU Time in Miroseconds | ||
12 | ![]() |
ORACTPERE | ORADEC16 | DEC | 31 | 1 | CPU Time per Execution | ||
13 | ![]() |
ORAELAPSED | ORAPNUMBER | DEC | 31 | 0 | Elapsed Time in Microseconds | ||
14 | ![]() |
ORAELAPERE | ORADEC16 | DEC | 31 | 1 | Elapsed Time per Execution | ||
15 | ![]() |
ORAWAITTIM | ORAPNUMBER | DEC | 31 | 0 | Wait time | ||
16 | ![]() |
ORAWTPERE | ORADEC16 | DEC | 31 | 1 | Wait Time per Execution | ||
17 | ![]() |
ORASQLTEXT | CHAR60 | CHAR | 60 | 0 | Start of SQL statement |
History
Last changed by/on | SAP | 20070813 |
SAP Release Created in |