SAP ABAP Table RSDB_CATALOG_CACHE_STAT (Statement Cache Statistics)
Hierarchy
☛
SAP_BASIS (Software Component) SAP Basis Component
⤷
BC-DB-DBI (Application Component) DB-Independent Database Interface
⤷
SBUF (Package) Table Buffers
⤷
⤷
Basic Data
| Table Category | INTTAB | Structure |
| Structure | RSDB_CATALOG_CACHE_STAT |
|
| Short Description | Statement 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 | |
DBSQL_STAT_WP | INT4 | 10 | 0 | Work Process ID | |||
| 2 | |
DBSQL_STAT_REQUESTS | INT4 | 10 | 0 | Number of Requests | |||
| 3 | |
DBSQL_STAT_HITS | INT4 | 10 | 0 | Number of Hits | |||
| 4 | |
DBSQL_STAT_HITRATIO | DEC | 10 | 2 | Hit Ratio as a Percentage | |||
| 5 | |
DBSQL_STAT_REPLACEMENTS | INT4 | 10 | 0 | Number of LRU Replacements from the Cache | |||
| 6 | |
DBSQL_STAT_ALLOCATED | INT4 | 10 | 0 | Allocated Memory in KB | |||
| 7 | |
DBSQL_STAT_MAXOBJECTS | INT4 | 10 | 0 | Maximum Number of Objects in Cache | |||
| 8 | |
DBSQL_STAT_USED | INT4 | 10 | 0 | Number of Used Entries in the Cache | |||
| 9 | |
DBSQL_STAT_REFERENCED | INT4 | 10 | 0 | Number of Currently Referenced Entries in the Cache | |||
| 10 | |
DBSQL_STAT_TABSECKEY | INT4 | 10 | 0 | Number of Objects with at Least One Secondary Key Loaded | |||
| 11 | |
DBSQL_STAT_TABNOTBUFFERED | INT4 | 10 | 0 | Number of Non-Buffered Objects in the Cache | |||
| 12 | |
DBSQL_STAT_TABRESIDENTBUF | INT4 | 10 | 0 | Number of Fully Buffered Objects in the Cache | |||
| 13 | |
DBSQL_STAT_TABGENERICBUF | INT4 | 10 | 0 | Number of Generically Buffered Objects in the Cache | |||
| 14 | |
DBSQL_STAT_TABPARTIALBUF | INT4 | 10 | 0 | Number of Partially Buffered Objects in Cache |
History
| Last changed by/on | SAP | 20141013 |
| SAP Release Created in | 740 |