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): |
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:
![]() ![]() |