Table of Contents

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:

  • VSQLAREA on (ADDRESS, HASH_VALUE)
  • and with VSQL on (ADDRESS, HASH_VALUE, CHILD_NUMBER).

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?

Documentation / Reference