Deactivating database-request statement caching for selected users

Database Administration

Reference : PROMON Utility : R&D Status Displays : Client Database-Request Statement Cache : Deactivating database-request statement caching for selected users

Once database-request statement caching is activated for one or more users, any deactivate menu option will halt database-request statement caching.

Note: To view the database-request statement cache, select View Database-Request Statement Cache from the main Client Database-Request Statement Caching menu. For more information, see Viewing database-request statement caching.

When you choose to deactivate database-request statement caching for selected users, a list of users with database-request statement caching activated is generated, like the following:

04/08/15 OpenEdge Release 11 Monitor (R&D)
13:12:30 Deactivate For Selected Users

Usr:Ten Name Domain Type Login time Serv IPV# Remote Address
5 User-5 -4 SELF/ABL 04/08/15 13:33 0
6 User-6 -4 SELF/ABL 04/08/15 13:34 0
7 User-7 -4 SELF/ABL 04/08/15 13:34 0
8 User-8 -4 SELF/ABL 04/08/15 13:34 0

Enter user number, P, T, or X (? for help):

Once the user information is displayed, you can deactivate database-request statement caching for selected users by specifying the corresponding user number. Based on the user number, the following actions are performed:

If the user number is valid, and if the user is specified in the list, database-request statement caching is deactivated. If the user is a self-serve or remote client, database-request statement caching is deactivated for that client. If the user number represents a remote database server, database-request statement caching is deactivated for all clients serviced by that database server.

You can continue entering additional valid user numbers.

The user number entry is terminated when you press ENTER without specifying a valid numeric character, or when you press ENTER after entering a non-numeric character.