Viewing database-request statement caching

04/08/15        OpenEdge Release 11 Monitor (R&D)
13:38:46 View Client Statement Cache

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

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

04/08/15        OpenEdge Release 11 Monitor (R&D)
13:39:02 View Client Statement Cache

User number : 6
User name : User-6
User type : SELF/ABL
Login date/time : 04/08/15 12:23

Statement caching type : SQL Statement or Single ABL Program Name
Statement caching last updated : 04/08/15 14:11

Statement cache : -1 : d_mar18.p
2 : /scratch/doc/116/p94309_Untitled1.ped

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

Table 90. View client statement cache display fields
Field	Description
User number	The user number associated with the database connection.
Name	The user name associated with the connected user.
User Type	The type of database connection.
Login date/time	The date and time the user connected to the database.
Statement cache type	SQL statement or Single ABL Program Name — The statement cache information contains a single SQL statement or a partial ABL program line number. SQL statement or Partial ABL Program Name — The statement cache information contains a single SQL statement or a partial ABL program stack containing ABL program names and line numbers. One Time SQL Statement or Partial ABL Program Name — The statement cache information contains a one time request of a single SQL statement or a partial ABL program stack containing ABL program names and line numbers.
Statement cache last updated	The date and time the database-request statement cache was updated.
Statement cache	The SQL statement or ABL program information for the last database request made by the client. This field may change, if: The client is an ABL client, the line number is shown followed by the ABL program name. The line number displayed is the one generated by the compiled listing of the ABL program; it may not match the contents of the ABL source code. The client is a SQL client; the SQL statement is displayed.