Client Database-Request Statement Cache

Displays options for Client Database-Request Statement Caching.

                OpenEdge Release 12 Monitor (R&D)
                Client Database-Request Statement Caching Menu

                 1. Activate For Selected Users
                 2. Activate For All Users
                 3. Activate For All Future Users
                 4. Deactivate For Selected Users
                 5. Deactivate For All Users
                 6. Deactivate For All Future Users
                 7. View Database-Request Statement Cache
                 8. Specify Directory for Statement Cache Files
                 9. Toggle between User and Tenant Options
                10. Database statement cache locks

Choose one of the following options:

• Activate For Selected Users — Activates Client Database-Request Statement Caching for one or more clients. For more information, see Activating database-request statement caching for selected users.
• Activate For All Users — Activates Client Database-Request Statement Caching for all clients. For more information, see Activating database-request statement caching for all users.
• Activate For All Future Users — Activates Client Database-Request Statement Caching for all future client connections to the database. For more information, see Activating database-request statement caching for all future users.
• Deactivate For Selected Users — Deactivates Client Database-Request Statement Caching for one or more clients. For more information, see Deactivating database-request statement caching for selected users.
• Deactivate For All Users — Deactivates Client Database-Request Statement Caching for all clients.
• Deactivate For All Future Users — Deactivates Client Database-Request Statement Caching for all future client connections to the database.
• View Database-Request Statement Cache — View the Client Database-Request Statement Cache. For more information, see Viewing database-request statement caching.
• Specify Directory for Statement Cache Files — Specify the directory for all temporary database-request statement cache files. For more information, see Specifying a directory for database-request statement caching files.
• Toggle between User and Tenant Options — When selected, switches options 1-6 to activate or deactivate based on tenancy not on users.
• Database statement cache locks — When selected, displays a list of locks obtained by users performing database statement caching.