_Connect-CacheInfo

Posted by claudemir_santos on 05-Jun-2017 14:29

it´s  possible to enable cache info without  promon?
I would like to enable and disable at run time

All Replies

Posted by George Potemkin on 06-Jun-2017 01:00

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.

This thread is closed