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
⤷ 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 | Table Relationship Diagram |
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 | EXECUTIONS | ORAEXECNUM | ORAPNUMBER | DEC | 31 | 0 | Total number of executions | ||
2 | CURR_EXEC | ORACURREX | ORANUMB7 | INT4 | 10 | 0 | Number of users executing this cursor | ||
3 | DISK_READS | ORADISKR | ORAPNUMBER | DEC | 31 | 0 | Sum of all 'disk reads' | ||
4 | DISKRPER_E | ORADRPERE | ORADEC16 | DEC | 31 | 1 | Number of 'disk reads' for each execution | ||
5 | BUFFER_GET | ORABUFFERG | ORAPNUMBER | DEC | 31 | 0 | Total number of "buffer gets" | ||
6 | BUFFGPER_E | ORABGPERE | ORADEC16 | DEC | 31 | 1 | Number of 'buffer gets' for each execution | ||
7 | ROWS_PROCE | ORAROWPROC | ORAPNUMBER | DEC | 31 | 0 | Number of processed rows | ||
8 | ROWSPPER_E | ORARPPERE | ORADEC16 | DEC | 31 | 1 | Number of rows processed for each execution | ||
9 | BUFFGPER_R | ORABGPERR | ORADEC16 | DEC | 31 | 1 | Number of 'buffer gets' for each row | ||
10 | SORTS | ORASQLSORT | ORANUMB8 | INT4 | 10 | 0 | Sort orders | ||
11 | CPU_TIME | ORACPUTIME | ORAPNUMBER | DEC | 31 | 0 | CPU Time in Miroseconds | ||
12 | CPU_TIME_E | ORACTPERE | ORADEC16 | DEC | 31 | 1 | CPU Time per Execution | ||
13 | ELAPSED_TI | ORAELAPSED | ORAPNUMBER | DEC | 31 | 0 | Elapsed Time in Microseconds | ||
14 | ELAPSEDTIE | ORAELAPERE | ORADEC16 | DEC | 31 | 1 | Elapsed Time per Execution | ||
15 | WAIT_TIME | ORAWAITTIM | ORAPNUMBER | DEC | 31 | 0 | Wait time | ||
16 | WAITTIME_E | ORAWTPERE | ORADEC16 | DEC | 31 | 1 | Wait Time per Execution | ||
17 | SQL_TEXT | ORASQLTEXT | CHAR60 | CHAR | 60 | 0 | Start of SQL statement |
History
Last changed by/on | SAP | 20070813 |
SAP Release Created in |