The primary key for the view is WORKAREA_ADDRESS, the memory Address of the work area handle.
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?