cacheStats ​
Command:
cacheStats
Category: System Admin
Status: Production Ready
Description ​
View SQL plan cache and result cache statistics from the SAP HANA database. This command allows you to analyze cache performance and memory utilization by querying the M_SQL_PLAN_CACHE and M_RESULT_CACHE system views.
Syntax ​
bash
hana-cli cacheStats [options]Command Diagram ​
Parameters ​
Options ​
| Option | Alias | Type | Default | Description |
|---|---|---|---|---|
--cacheType | -t | string | all | Type of cache to query. Choices: plan, result, all |
--limit | -l | number | 50 | Maximum number of cache entries to return |
Connection Parameters ​
| Option | Alias | Type | Default | Description |
|---|---|---|---|---|
--admin | -a | boolean | false | Connect via admin (default-env-admin.json) |
--conn | - | string | - | Connection filename to override default-env.json |
Troubleshooting ​
| Option | Alias | Type | Default | Description |
|---|---|---|---|---|
--disableVerbose | --quiet | boolean | false | Disable verbose output - removes all extra output that is only helpful to human readable interface |
--debug | -d | boolean | false | Debug hana-cli itself by adding output of LOTS of intermediate details |
Examples ​
View All Cache Statistics ​
bash
hana-cli cacheStats --cacheType allDisplay both SQL plan cache and result cache statistics.
View SQL Plan Cache Only ​
bash
hana-cli cacheStats --cacheType plan --limit 100View the top 100 entries from the SQL plan cache.
View Result Cache Only ​
bash
hana-cli cacheStats --cacheType result --limit 25View the top 25 entries from the result cache.
Related Commands ​
See the Commands Reference for other commands in this category.