2.1.12 Storage Server SQL Query Statistics Monitoring

Oracle Exadata System Software release 25.2.0 introduces the Exadata Storage Server SQL Statistics utility (cellsqlstat), which provides real-time query-level statistics in each storage server.

The cellsqlstat utility enables administrators to better monitor and understand query-level storage server resource utilization, providing detailed insight into numerous statistics including:

• CPU and memory consumption

• I/O savings associated with storage index and columnar cache

• Flash cache and XRMem cache hits

• Scanned bytes and scan rate

• Passthru bytes and rate

The cellsqlstat utility provides a periodic snapshot of performance statistics for the top SQL statements, helping administrators to:

• Quickly summarize the query workload on each storage server.

• Rapidly identify resource-heavy queries and understand their resource utilization.

• Identify performance bottlenecks and "noisy neighbor" issues.

Storage administrators can run cellsqlstat on demand to understand real-time SQL performance. Additionally, Exawatcher includes cellsqlstat output in its log files.