How and what to delete data after changing configuration in SYSTEM EXPLORER -> TOOLS -> SQL PERFORMANCE TOOLS -> SQL RUNTIME STATISTIC
Hello everyone!
Some time ago, I changed the configuration in SQL Runtime Statistic to "Turn on Stats code generation to gather stats at the Open and Close of a query". With this change, the CACHE base (cache/mgr/cache/) has grown a lot to reach 198GB.
Yesterday, I returned the configuration of SQL Runtime Statistic to the default which is "Turn off Stats code generation" and the cache base is no longer growing.
My question is?
How to delete this data that was created in the CACHE base (cache/mgr/cache/) and what data I can delete without affecting the system.
Thanks,
Fábio Louly.
Product version: Caché 2018.1
$ZV: Cache for UNIX (Red Hat Enterprise Linux for x86-64) 2018.1.2 (Build 309_5)