About
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:
- What are the top 10 work areas that require the most cache area?
- For work areas allocated in AUTO mode, what percentage of work areas are running using maximum memory?