it´s possible to enable cache info without promon?
I would like to enable and disable at run time
Yes, _Connect-CachingType is an updatable field:
0 Turns off caching
1 Single
2 Stack
3 One Time
I'd strongly recommend to use promon -> Specify Directory for Statement Cache Files
You need to do it only once after db startup.
Directory should have the read/write permissions for all users.