Oracle is counting hundreds of events - both on system and session level - they are called statistics. They can provide significant information about the pasts activities - especially when deltas are calculated for a period of interest.
In 23c free, 362 new statistics appeared (om comparison to 21.9):
| STATISTIC# | NAME | CLASS | CLASS_NAME |
|---|---|---|---|
| 20 | RM usage by this session | 1 | User |
| 21 | RM adjustments | 1 | User |
| 74 | spare statistic 1 | 128 | Debug |
| 75 | spare statistic 2 | 128 | Debug |
| 205 | control file read req (single-block) | 4 | Enqueue |
| 206 | control file read req (multi-block) | 4 | Enqueue |
| 207 | control file read req (single-block) RDMA optimized | 4 | Enqueue |
| 208 | control file read req (multi-block) RDMA optimized | 4 | Enqueue |
| 914 | index cmph, decomp full buffers | 128 | Debug |
| 915 | index cmph, decomp full buffers failures | 128 | Debug |
| 916 | index cmph sc, decomp buffers rows avail | 128 | Debug |
| 917 | index cmph sc, decomp buffers rows used | 128 | Debug |
| 918 | index cmph sc, decomp buffers released and found valid | 128 | Debug |
| 1252 | bytes sent via network packages | 1 | User |
| 1253 | bytes received via network packages | 1 | User |
| 1254 | bytes sent via UTL_HTTP | 1 | User |
| 1255 | bytes received via UTL_HTTP | 1 | User |
| 1256 | bytes sent via UTL_TCP | 1 | User |
| 1257 | bytes received via UTL_TCP | 1 | User |
| 1258 | bytes sent via UTL_SMTP | 1 | User |
| 1259 | bytes received via UTL_SMTP | 1 | User |
| 1549 | MLE JIT compilation success count | 1 | User |
| 1550 | MLE JIT compilation error count | 1 | User |
| 1551 | MLE JIT compilation duration max | 1 | User |
| 1552 | MLE JIT compilation duration cumulative | 1 | User |
| 1553 | MLE incremental GC count | 1 | User |
| 1554 | MLE incremental GC accumulated time | 1 | User |
| 1555 | MLE full GC count | 1 | User |
| 1556 | MLE full GC accumulated time | 1 | User |
| 1598 | cell xrmem log writes | 258 | Redo Instance level |
| 1603 | distributed operation count | 384 | Debug Instance level |
| 1604 | distributed operation active count | 384 | Debug Instance level |
| 1605 | distributed operation paused count | 384 | Debug Instance level |
| 1606 | distributed operation no-op count | 384 | Debug Instance level |
| 1607 | distributed operation waiting to archive count | 384 | Debug Instance level |
| 1608 | distributed operation dist_op count | 384 | Debug Instance level |
| 1609 | distributed operation count began in last second | 384 | Debug Instance level |
| 1610 | distributed operation count per second over last minute | 384 | Debug Instance level |
| 1611 | distributed operation count archives in last second | 384 | Debug Instance level |
| 1612 | distributed operation count archives per second over last minut | 384 | Debug Instance level |
| 1613 | distributed operation pool bucket grow error | 384 | Debug Instance level |
| 1614 | distributed operation pool buckets in use | 384 | Debug Instance level |
| 1615 | distributed operation pool bucket buffers in use | 384 | Debug Instance level |
| 1616 | distributed operation pool buckets available | 384 | Debug Instance level |
| 1617 | control file read block (multi-block) | 256 | Instance level |
| 1618 | control file read req (single-block) no enqueue | 256 | Instance level |
| 1619 | control file read req (multi-block) no enqueue | 256 | Instance level |
| 1620 | control file read block (multi-block) no enqueue | 256 | Instance level |
| 1621 | control file read req with MGA buffer | 256 | Instance level |
| 1622 | control file buffers scanned looking for a victim | 256 | Instance level |
| 1623 | control file warm buffers from cold region | 256 | Instance level |
| 1624 | control file exclusive latch success | 256 | Instance level |
| 1625 | control file exclusive latch failure | 256 | Instance level |
| 1626 | control file invalid cached buffers | 256 | Instance level |
| 1627 | control file blocks written | 256 | Instance level |
| 1628 | control file cache search for read hit | 256 | Instance level |
| 1629 | control file cache search for read miss | 256 | Instance level |
| 1694 | TrueCache: block requests to preferred primary | 264 | Cache Instance level |
| 1695 | TrueCache: block requests to primary | 264 | Cache Instance level |
| 1696 | rt prf local ORL write bytes | 256 | Instance level |
| 1697 | rt prf local elapsed time | 256 | Instance level |
| 1725 | rt wrn sequence skipped | 256 | Instance level |
| 1726 | pdc waits for new incarnation | 258 | Redo Instance level |
| 1727 | pdc slb flushes | 258 | Redo Instance level |
| 1728 | pdc slb flushes avoided | 258 | Redo Instance level |
| 1729 | pdc slb flushes partial | 258 | Redo Instance level |
| 1730 | pdc slb flushes (imu downgrade) | 258 | Redo Instance level |
| 1731 | pdc slb flushes (txn dependency) | 258 | Redo Instance level |
| 1732 | pdc slb flushes (get/steal) | 258 | Redo Instance level |
| 1733 | pdc slb flushes (no ri slots) | 258 | Redo Instance level |
| 1734 | pdc redo size | 258 | Redo Instance level |
| 1735 | redo entries (pdc) | 258 | Redo Instance level |
| 1736 | pdc commits (imu) | 258 | Redo Instance level |
| 1737 | pdc commits (non imu) | 258 | Redo Instance level |
| 1738 | pdc dependencies | 258 | Redo Instance level |
| 1739 | pdc dependencies (orl) | 258 | Redo Instance level |
| 1740 | pdc dependencies nlc | 258 | Redo Instance level |
| 1741 | pdc dependencies nlc (orl) | 258 | Redo Instance level |
| 1742 | pdc dependencies xfer (imu downgrade) | 258 | Redo Instance level |
| 1743 | pdc scn waits | 258 | Redo Instance level |
| 1744 | pdc scn waits (clearing orl session) | 258 | Redo Instance level |
| 1745 | pdc switches to orl (no free slb) | 258 | Redo Instance level |
| 1746 | pdc switches to orl (no ri slots) | 258 | Redo Instance level |
| 1747 | pdc switches to orl (background) | 258 | Redo Instance level |
| 1748 | pdc switches to orl (no ptn chunks) | 258 | Redo Instance level |
| 1749 | pdc switches to orl (rdma fail) | 258 | Redo Instance level |
| 1750 | pdc switches to orl (own thread dep) | 258 | Redo Instance level |
| 1751 | pdc switches to orl (slb full) | 258 | Redo Instance level |
| 1752 | pdc switches to orl (txn time limit) | 258 | Redo Instance level |
| 1753 | pdc switches to orl (pdc ratio exceeded) | 258 | Redo Instance level |
| 1754 | pdc switches to orl (open failure) | 258 | Redo Instance level |
| 1755 | pdc switches to orl (incarnation chg) | 258 | Redo Instance level |
| 1756 | pdc switches to orl (non-pdc session) | 258 | Redo Instance level |
| 1757 | redo size (parallel LGWR) | 258 | Redo Instance level |
| 1758 | redo size sample count (parallel LGWR) | 258 | Redo Instance level |
| 1759 | redo size (serial LGWR) | 258 | Redo Instance level |
| 1760 | redo size sample count (serial LGWR) | 258 | Redo Instance level |
| 1761 | redo size (test serial LGWR) | 258 | Redo Instance level |
| 1762 | redo size sample count (test serial LGWR) | 258 | Redo Instance level |
| 1763 | redo writes adaptive switch | 258 | Redo Instance level |
| 1764 | redo write test single time (usec) | 258 | Redo Instance level |
| 1765 | redo write test single count | 258 | Redo Instance level |
| 1774 | gc zcopy slow send | 296 | Cache Real Application Clusters Instance level |
| 1801 | pdc boc composite bcasts | 258 | Redo Instance level |
| 1802 | pdc boc composite bcast time (usecs) | 258 | Redo Instance level |
| 1803 | pdc boc composite bcasts avoided | 258 | Redo Instance level |
| 1804 | pdc boc instance successful bcasts | 258 | Redo Instance level |
| 1805 | pdc boc instance successful bcast time (usecs) | 258 | Redo Instance level |
| 1806 | pdc boc instance retried bcasts | 258 | Redo Instance level |
| 1807 | pdc boc instance failed connections | 258 | Redo Instance level |
| 1808 | pdc boc instance failed connection time (usecs) | 258 | Redo Instance level |
| 1809 | pdc boc instance failed bcasts | 258 | Redo Instance level |
| 1810 | pdc boc instance failed bcast time (usecs) | 258 | Redo Instance level |
| 1811 | pdc boc instance aborted bcasts | 258 | Redo Instance level |
| 1812 | pdc boc instance bcasts avoided | 258 | Redo Instance level |
| 1813 | pdc boc instance bcasts avoided thru lgwr | 258 | Redo Instance level |
| 1814 | pdc boc instance bcasts wasted | 258 | Redo Instance level |
| 1815 | pdc boc instance down | 258 | Redo Instance level |
| 1816 | pdc boc initializations | 258 | Redo Instance level |
| 1817 | pdc boc initialization time (usecs) | 258 | Redo Instance level |
| 1818 | pdc boc lgwr bcasts avoided | 258 | Redo Instance level |
| 1819 | pdc boc rcvd scn scans | 258 | Redo Instance level |
| 1820 | True Cache: message roundtrip time data send | 256 | Instance level |
| 1821 | True Cache: message roundtrip time request send | 256 | Instance level |
| 1822 | True Cache: message count data send | 256 | Instance level |
| 1823 | True Cache: message count request send | 256 | Instance level |
| 1824 | txns rollback txn_auto_rollback_high_priority_wait_target | 384 | Debug Instance level |
| 1825 | txns rollback txn_auto_rollback_medium_priority_wait_target | 384 | Debug Instance level |
| 1826 | txns track mode txn_auto_rollback_high_priority_wait_target | 384 | Debug Instance level |
| 1827 | txns track mode txn_auto_rollback_medium_priority_wait_target | 384 | Debug Instance level |
| 1845 | Heatmap SegLevel - Fast Full Index Scan | 256 | Instance level |
| 1846 | Heatmap SegLevel - Range Index Scan | 256 | Instance level |
| 1921 | IM private journal HT granule count | 384 | Debug Instance level |
| 1922 | IM private journal HT bucket count | 384 | Debug Instance level |
| 1951 | Native Transaction Guard inconclusive outcome count | 256 | Instance level |
| 1952 | Native Transaction Guard force_outcome count | 256 | Instance level |
| 1953 | Transaction Guard force_outcome count | 256 | Instance level |
| 1954 | Native Transaction Guard usage count | 256 | Instance level |
| 1955 | Native Transaction Guard Transaction Table rollback count | 256 | Instance level |
| 1956 | transaction recovery quarantines generated | 256 | Instance level |
| 1957 | transaction recovery quarantines escalated | 256 | Instance level |
| 1958 | quarantined transactions skipped | 256 | Instance level |
| 1959 | IM repopulate IMEI accumulated time (ms) | 384 | Debug Instance level |
| 1960 | IM repopulate reverse IMEI accumulated time (ms) | 384 | Debug Instance level |
| 1961 | IM graph change queue scheduling accumulated time (ms) | 384 | Debug Instance level |
| 1962 | IM graph change queue drain accumulated time (ms) | 384 | Debug Instance level |
| 1963 | IM graph change queue background drain accumulated time (ms) | 384 | Debug Instance level |
| 1964 | IM graph change queue fetch accumulated time (ms) | 384 | Debug Instance level |
| 1965 | IM graph change queue background fetch accumulated time (ms) | 384 | Debug Instance level |
| 1966 | IM graph transaction consistent CSR built accumulated time (ms) | 384 | Debug Instance level |
| 1967 | IM repopulate IMEIs | 384 | Debug Instance level |
| 1968 | IM repopulate reverse IMEIs | 384 | Debug Instance level |
| 1969 | IM graph change queue drain tasks scheduled | 384 | Debug Instance level |
| 1970 | IM graph change queue drained records | 384 | Debug Instance level |
| 1971 | IM graph change queue invalid records | 384 | Debug Instance level |
| 1972 | IM graph change queue background drained | 384 | Debug Instance level |
| 1973 | IM graph change queue drained downgraded records | 384 | Debug Instance level |
| 1974 | IM graph transaction consistent CSR built | 384 | Debug Instance level |
| 1975 | IM graph transaction consistent CSR drainless built | 384 | Debug Instance level |
| 1976 | IM graph change queue insert only object records | 384 | Debug Instance level |
| 1977 | IM graph change queue delete only object records | 384 | Debug Instance level |
| 1978 | IM graph change queue object records | 384 | Debug Instance level |
| 1979 | IMEI log records | 384 | Debug Instance level |
| 1980 | IMEI log vertex inserts | 384 | Debug Instance level |
| 1981 | IMEI log vertex deletes | 384 | Debug Instance level |
| 1982 | IMEI log edge inserts | 384 | Debug Instance level |
| 1983 | IMEI log edge deletes | 384 | Debug Instance level |
| 1984 | IMEI log record bytes allocated | 384 | Debug Instance level |
| 1985 | Temp Space Prewarm Request | 384 | Debug Instance level |
| 1986 | Temp Space Prewarm Extents | 384 | Debug Instance level |
| 1987 | Temp Space Rebalance Request | 384 | Debug Instance level |
| 1988 | Temp Space Shrink Extent Release Request | 384 | Debug Instance level |
| 1989 | Temp Space Rebalance Receive | 384 | Debug Instance level |
| 1990 | Temp Space Shrink Extent Release Receive | 384 | Debug Instance level |
| 1991 | Temp Space Dealloc Extents | 384 | Debug Instance level |
| 1992 | securefile alloc all sources | 384 | Debug Instance level |
| 1993 | securefile alloc curr descn | 384 | Debug Instance level |
| 1994 | Sub-segment created | 384 | Debug Instance level |
| 1995 | Sub-segment dropped | 384 | Debug Instance level |
| 1996 | Sub-segment state quiesce | 384 | Debug Instance level |
| 1997 | Sub-segment state interim | 384 | Debug Instance level |
| 1998 | Sub-segment state done | 384 | Debug Instance level |
| 1999 | kts spare statistic 1 | 384 | Debug Instance level |
| 2000 | kts spare statistic 2 | 384 | Debug Instance level |
| 2001 | kts spare statistic 3 | 384 | Debug Instance level |
| 2002 | kts spare statistic 4 | 384 | Debug Instance level |
| 2023 | Temp File Extend Request | 384 | Debug Instance level |
| 2024 | Temp File Reuse Any Instance | 384 | Debug Instance level |
| 2025 | Temp File Reuse Dead Instance | 384 | Debug Instance level |
| 2026 | Temp File Reuse Get Instance Lock | 384 | Debug Instance level |
| 2027 | Temp File Bitmap Reuse Execution | 384 | Debug Instance level |
| 2028 | Temp File Bitmap Reuse Extents | 384 | Debug Instance level |
| 2029 | Temp File Bitmap Pre-reuse Execution | 384 | Debug Instance level |
| 2030 | Temp File Bitmap Pre-reuse Extents | 384 | Debug Instance level |
| 2032 | IM area shrink | 384 | Debug Instance level |
| 2033 | IM area RO shrink granules | 384 | Debug Instance level |
| 2034 | IM area RW shrink granules | 384 | Debug Instance level |
| 2035 | IM area shrink RO granules swap | 384 | Debug Instance level |
| 2036 | IM area shrink RO granules failed | 384 | Debug Instance level |
| 2037 | IM area shrink RO granules replaced | 384 | Debug Instance level |
| 2038 | IM area shrink garbage collect waits | 384 | Debug Instance level |
| 2039 | IM area shrink garbage collect timeout | 384 | Debug Instance level |
| 2040 | IM area shrink fails | 384 | Debug Instance level |
| 2041 | IM area shrink fail insufficent granules | 384 | Debug Instance level |
| 2042 | IM area grow fails | 384 | Debug Instance level |
| 2043 | IM area concurrent resize fails | 384 | Debug Instance level |
| 2044 | IM area grow | 384 | Debug Instance level |
| 2045 | IM area grow granules | 384 | Debug Instance level |
| 2046 | IM area RO grow granules | 384 | Debug Instance level |
| 2047 | IM space metadata alloc fail | 384 | Debug Instance level |
| 2048 | IM raclocks alloc fail | 384 | Debug Instance level |
| 2049 | IM raclocks alloc bytes | 384 | Debug Instance level |
| 2050 | IM raclocks retry alloc shared pool | 384 | Debug Instance level |
| 2051 | Auto SF SHK total number of tasks | 256 | Instance level |
| 2052 | Auto SF SHK rejected due to activity | 256 | Instance level |
| 2053 | Auto SF SHK rejected due to past shrink | 256 | Instance level |
| 2054 | Auto SF SHK rejected fast SU unavailable | 256 | Instance level |
| 2055 | Auto SF SHK rejected due to disk SU check | 256 | Instance level |
| 2056 | Auto SF SHK rejected due to recycle bin check | 256 | Instance level |
| 2057 | Auto SF SHK rejected trickle (fast SU) | 256 | Instance level |
| 2058 | Auto SF SHK rejected trickle (disk SU) | 256 | Instance level |
| 2059 | Auto SF SHK total analyzed segments | 256 | Instance level |
| 2060 | Auto SF SHK total candidates | 256 | Instance level |
| 2061 | Auto SF SHK successfully shrunk | 256 | Instance level |
| 2062 | Auto SF SHK number shrinks failed | 256 | Instance level |
| 2063 | Auto SF SHK time (disk SU check) | 256 | Instance level |
| 2064 | Auto SF SHK time (shrink task) | 256 | Instance level |
| 2065 | Auto SF SHK time (releasing extents) | 256 | Instance level |
| 2066 | Auto SF SHK tasks failed: rowlock contention | 256 | Instance level |
| 2067 | Auto SF SHK tasks failed: concurrent DDL | 256 | Instance level |
| 2068 | cell IOT leaf blocks filtered | 320 | SQL Instance level |
| 2069 | cell IOT leaf blocks not filtered: nonkey where | 320 | SQL Instance level |
| 2070 | cell IOT rows returned | 320 | SQL Instance level |
| 2071 | cell IOT compressed leaf blocks filtered | 320 | SQL Instance level |
| 2072 | cell index leaf blocks filtered | 320 | SQL Instance level |
| 2073 | cell index compressed leaf blocks filtered | 320 | SQL Instance level |
| 2074 | cell index rows returned | 320 | SQL Instance level |
| 2076 | SV Ordered Sequence X gets | 384 | Debug Instance level |
| 2077 | SV Ordered Sequence S gets | 384 | Debug Instance level |
| 2078 | index coal, active block | 384 | Debug Instance level |
| 2079 | index coal, busy block | 384 | Debug Instance level |
| 2080 | index coal, examined blocks | 384 | Debug Instance level |
| 2081 | index coal, empty blocks removed | 384 | Debug Instance level |
| 2082 | index coal, redo limit hit | 384 | Debug Instance level |
| 2083 | index cmph, recompression failed | 384 | Debug Instance level |
| 2084 | index coal, skip blocks | 384 | Debug Instance level |
| 2085 | index coal, rows do not fit | 384 | Debug Instance level |
| 2086 | KDBL partition spilling starts | 384 | Debug Instance level |
| 2087 | cell IOT scans | 320 | SQL Instance level |
| 2091 | securefile multi-wgc use count | 384 | Debug Instance level |
| 2093 | cellmemory IM scan column CUs format dict | 384 | Debug Instance level |
| 2094 | cellmemory IM scan column CUs format rle dict | 384 | Debug Instance level |
| 2095 | cellmemory IM scan column CUs format non-dict | 384 | Debug Instance level |
| 2096 | cellmemory IM scan column CUs format null | 384 | Debug Instance level |
| 2097 | cellmemory IM scan column CUs format constant | 384 | Debug Instance level |
| 2098 | cellmemory IM scan column path value index | 384 | Debug Instance level |
| 2099 | HCC scan cell CUs requeue | 384 | Debug Instance level |
| 2100 | HCC scan cell CUs un-agg fallback | 384 | Debug Instance level |
| 2101 | cellmemory IM hpk bloom filter nrows | 384 | Debug Instance level |
| 2102 | cellmemory IM bloom filter returned nrows | 384 | Debug Instance level |
| 2103 | cellmemory IM bloom filter total calls | 384 | Debug Instance level |
| 2104 | cellmemory IM simd bloom filter calls | 384 | Debug Instance level |
| 2105 | cellmemory HCC simd compare calls | 384 | Debug Instance level |
| 2106 | cellmemory HCC simd decode calls | 384 | Debug Instance level |
| 2107 | cellmemory HCC simd rle burst calls | 384 | Debug Instance level |
| 2108 | cellmemory HCC simd set membership calls | 384 | Debug Instance level |
| 2109 | cellmemory HCC simd xlate filter calls | 384 | Debug Instance level |
| 2110 | cellmemory HCC simd decode unpack calls | 384 | Debug Instance level |
| 2111 | cellmemory HCC simd decode symbol calls | 384 | Debug Instance level |
| 2112 | HCC simd compare calls | 384 | Debug Instance level |
| 2113 | HCC simd decode calls | 384 | Debug Instance level |
| 2114 | HCC simd rle burst calls | 384 | Debug Instance level |
| 2115 | HCC simd set membership calls | 384 | Debug Instance level |
| 2116 | HCC simd bloom filter calls | 384 | Debug Instance level |
| 2117 | HCC hpk bloom filter nrows | 384 | Debug Instance level |
| 2118 | HCC bloom filter skipped calls | 384 | Debug Instance level |
| 2119 | HCC bloom filter skipped nrows | 384 | Debug Instance level |
| 2120 | HCC bloom filter returned nrows | 384 | Debug Instance level |
| 2121 | HCC bloom filter total calls | 384 | Debug Instance level |
| 2122 | HCC simd xlate filter calls | 384 | Debug Instance level |
| 2123 | HCC simd decode unpack calls | 384 | Debug Instance level |
| 2124 | HCC simd decode symbol calls | 384 | Debug Instance level |
| 2125 | HCC simd compare selective calls | 384 | Debug Instance level |
| 2126 | HCC simd decode selective calls | 384 | Debug Instance level |
| 2127 | HCC simd rle burst selective calls | 384 | Debug Instance level |
| 2128 | HCC simd set membership selective calls | 384 | Debug Instance level |
| 2129 | HCC simd bloom filter selective calls | 384 | Debug Instance level |
| 2130 | HCC simd xlate filter selective calls | 384 | Debug Instance level |
| 2131 | HCC simd decode unpack selective calls | 384 | Debug Instance level |
| 2132 | HCC simd decode symbol selective calls | 384 | Debug Instance level |
| 2133 | HCC simd KV add calls | 384 | Debug Instance level |
| 2134 | HCC simd KV add rows | 384 | Debug Instance level |
| 2135 | HCC simd KV probe calls | 384 | Debug Instance level |
| 2136 | HCC simd KV probe keys | 384 | Debug Instance level |
| 2137 | HCC simd KV probe rows | 384 | Debug Instance level |
| 2138 | HCC simd KV probe serial_buckets | 384 | Debug Instance level |
| 2139 | HCC simd KV probe chain_buckets | 384 | Debug Instance level |
| 2140 | HCC simd hash calls | 384 | Debug Instance level |
| 2141 | HCC simd hash rows | 384 | Debug Instance level |
| 2142 | HCC simd compare HW offload calls | 384 | Debug Instance level |
| 2143 | HCC simd decode HW offload calls | 384 | Debug Instance level |
| 2144 | HCC simd rle burst HW offload calls | 384 | Debug Instance level |
| 2145 | HCC simd set membership HW offload calls | 384 | Debug Instance level |
| 2146 | HCC simd decode unpack HW offload calls | 384 | Debug Instance level |
| 2253 | IM populate scan checkpoints | 384 | Debug Instance level |
| 2254 | IM populate scan | 384 | Debug Instance level |
| 2381 | IM hpk bloom filter nrows | 384 | Debug Instance level |
| 2382 | IM bloom filter skipped calls | 384 | Debug Instance level |
| 2383 | IM bloom filter skipped nrows | 384 | Debug Instance level |
| 2384 | IM bloom filter returned nrows | 384 | Debug Instance level |
| 2385 | IM bloom filter total calls | 384 | Debug Instance level |
| 2486 | IM populate max retry fail | 384 | Debug Instance level |
| 2487 | IM populate retries | 384 | Debug Instance level |
| 2513 | memopt w buffer miss nowait | 384 | Debug Instance level |
| 2514 | Count of population tasks submitted for IMEI | 384 | Debug Instance level |
| 2515 | Count of population tasks succeeded for IMEI | 384 | Debug Instance level |
| 2516 | Count of population tasks submitted for on demand IMPG | 384 | Debug Instance level |
| 2517 | Count of population tasks submitted for automatic IMPG | 384 | Debug Instance level |
| 2518 | Count of vertex tables populated | 384 | Debug Instance level |
| 2519 | Count of vertices populated | 384 | Debug Instance level |
| 2520 | Count of edge tables populated | 384 | Debug Instance level |
| 2521 | Count of edges populated | 384 | Debug Instance level |
| 2522 | Auto compression data movement success | 384 | Debug Instance level |
| 2523 | Auto compression data movement failure | 384 | Debug Instance level |
| 2524 | Auto compression data moved | 384 | Debug Instance level |
| 2525 | IM Graph Algo execs started | 384 | Debug Instance level |
| 2526 | Loaded side tables across all IM Graph Algo execs | 384 | Debug Instance level |
| 2527 | Materialized side tables across all IM Graph Algo execs | 384 | Debug Instance level |
| 2528 | Non-IM Graph Algo execs due to no available KSOLT threads | 384 | Debug Instance level |
| 2529 | IM Graph Algo startup time across all execs | 384 | Debug Instance level |
| 2530 | IM Graph Algo prop loading time across all execs (ms) | 384 | Debug Instance level |
| 2531 | IM Graph Algo core execution time across all execs (ms) | 384 | Debug Instance level |
| 2532 | IM Graph Algo prop materialization time across all execs (ms) | 384 | Debug Instance level |
| 2533 | IM Graph Algo cleanup time across all executions (ms) | 384 | Debug Instance level |
| 2534 | IM Graph Algo failures caused by a lack of available memory | 384 | Debug Instance level |
| 2535 | IM Graph Algo failures caused by missing reverse CSRs | 384 | Debug Instance level |
| 2536 | sql area evicted - failed | 256 | Instance level |
| 2537 | CCursor + sql area evicted - failed | 256 | Instance level |
| 2568 | new RECO protocol executions | 384 | Debug Instance level |
| 2569 | SPM_TEST_PLAN_VERIFICATIONS | 320 | SQL Instance level |
| 2570 | SPM_TEST_PLAN_IMPROVEMENTS | 320 | SQL Instance level |
| 2571 | SPM_TEST_PLAN_REGRESSIONS | 320 | SQL Instance level |
| 2576 | maximum user calls per request | 288 | Real Application Clusters Instance level |
| 2577 | maximum calls protected by Application Continuity per request | 288 | Real Application Clusters Instance level |
| 2579 | cell RDMA reads eligible | 257 | User Instance level |
| 2580 | cell RDMA read hash table probes | 257 | User Instance level |
| 2581 | cell RDMA reads issued | 257 | User Instance level |
| 2582 | cell RDMA probe failures - hash table buffer allocation failed | 257 | User Instance level |
| 2583 | cell RDMA probe failures - IPCDAT metadata allocation failed | 257 | User Instance level |
| 2584 | cell RDMA probe failures - IPCDAT errors | 257 | User Instance level |
| 2585 | cell RDMA read failures - lease expired | 257 | User Instance level |
| 2586 | cell RDMA reads - Exascale RPM incarnation matched | 257 | User Instance level |
| 2587 | cell RDMA read failures - invalid Exascale RPM ID or GUID | 257 | User Instance level |
| 2588 | cell RDMA reads rejected - ineligible | 257 | User Instance level |
| 2589 | cell RDMA read failures - client registration errors | 257 | User Instance level |
| 2590 | cell physical IO bytes saved during smart incremental backup | 256 | Instance level |
| 2591 | cell IO retries due to buffer allocation failures | 320 | SQL Instance level |
| 2592 | cell num bytes in filter passthru due to low mem | 256 | Instance level |
| 2593 | cell num bytes in filter passthru due to subheap size limit exc | 256 | Instance level |
| 2594 | cell smart IO foreground CPU time (msec) | 256 | Instance level |
| 2595 | cell smart IO background CPU time (msec) | 256 | Instance level |
| 2596 | cell num smart IO sessions in rdbms block IO due to online encr | 256 | Instance level |
On the other side, 17 statistics were removed:
| STATISTIC# | NAME | CLASS | CLASS_NAME |
|---|---|---|---|
| 469 | gc current blocks served with BPS | 40 | Cache Real Application Clusters |
| 471 | gc cr blocks served with BPS | 40 | Cache Real Application Clusters |
| 951 | index cmph sc, ffs decomp buffers | 128 | Debug |
| 952 | index cmph sc, ffs decomp buffers rows avail | 128 | Debug |
| 953 | index cmph sc, ffs decomp buffers rows used | 128 | Debug |
| 954 | index cmph sc, ffs decomp failures | 128 | Debug |
| 955 | index cmph sc, ffs decomp buffers released and found valid | 128 | Debug |
| 1490 | backup pieces compressed locally | 1 | User |
| 1491 | backup data compressed locally | 1 | User |
| 1492 | backup compressed data written locally | 1 | User |
| 1493 | backup piece local processing time | 1 | User |
| 1494 | backup pieces compressed remotely | 1 | User |
| 1495 | backup data compressed remotely | 1 | User |
| 1496 | backup compressed data written remotely | 1 | User |
| 1497 | backup piece remote processing time | 1 | User |
| 1586 | cell pmem log writes | 258 | Redo Instance level |
| 1855 | KTFT file extend req | 384 | Debug Instance level |
Keine Kommentare:
Kommentar veröffentlichen