The number of times that the system tried to insert table descriptor or authorization information into the catalog cache.
Table Function | Monitor Element Collection Level |
---|---|
MON_GET_CONNECTION table function - Get connection metrics | REQUEST METRICS BASE |
MON_GET_CONNECTION_DETAILS table function - Get detailed connection metrics (reported in DETAILS XML document) | REQUEST METRICS BASE |
MON_GET_SERVICE_SUBCLASS table function - Get service subclass metrics | REQUEST METRICS BASE |
MON_GET_SERVICE_SUBCLASS_DETAILS table function - Get detailed service subclass metrics (reported in DETAILS XML document) | REQUEST METRICS BASE |
MON_GET_UNIT_OF_WORK table function - Get unit of work metrics | REQUEST METRICS BASE |
MON_GET_UNIT_OF_WORK_DETAILS table function - Get detailed unit of work metrics (reported in DETAILS XML document) | REQUEST METRICS BASE |
MON_GET_WORKLOAD table function - Get workload metrics | REQUEST METRICS BASE |
MON_GET_WORKLOAD_DETAILS table function - Get detailed workload metrics (reported in DETAILS XML document) | REQUEST METRICS BASE |
Snapshot Level | Logical Data Grouping | Monitor Switch |
---|---|---|
Database | dbase | Basic |
Application | appl | Basic |
Event Type | Logical Data Grouping | Monitor Switch |
---|---|---|
Database | event_db | - |
Connection | event_conn | - |
Statistics | event_scstats (reported in the metrics document) | REQUEST METRICS BASE |
Statistics | event_wlstats (reported in the metrics document) | REQUEST METRICS BASE |
Unit of work |
Reported in the in the system_metrics document. |
REQUEST METRICS BASE |
Statistics | event_scmetrics* | REQUEST METRICS BASE |
Statistics | event_wlmetrics* | REQUEST METRICS BASE |
* When returned as part of this logical data group, this element reflects the change in value of this metric since the last statistics collection or database activation, whichever was more recent. |
1 - (Catalog Cache Inserts / Catalog Cache Lookups)
See the cat_cache_lookups monitor element for more information on using this element.