Try OpenEdge Now
skip to main content
Database Administration
Reference : PROMON Utility : R&D Status Displays : Client Database-Request Statement Cache
 
Client Database-Request Statement Cache
Displays options for Client Database-Request Statement Caching.
04/08/15        OpenEdge Release 11 Monitor (R&D)
09:06:10 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.
* Activating database-request statement caching for selected users
* Activating database-request statement caching for all users
* Activating database-request statement caching for all future users
* Deactivating database-request statement caching for selected users
* Viewing database-request statement caching
* Specifying a directory for database-request statement caching files