VSQL_WORKAREA displays information about work areas used by SQL cursors.
The primary key for the view is WORKAREA_ADDRESS, the memory Address of the work area handle.
Each SQL statement stored in the shared pool has one or more child cursors that are listed in the VSQL view.
VSQL_WORKAREA lists all work areas needed by these child cursors; VSQL_WORKAREA can be joined with:
You can use this view to find out answers to the following questions: