Oracle Database - V$SQL_WORKAREA

Card Puncher Data Processing

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





Discover More
Card Puncher Data Processing
Oracle Database - (Query) Work Area

The work area is an memory area that is used to perform data operation such as: SORT see sort area memory, HASH JOIN see hash area memory, GROUP BY, BUFFERING, BITMAP MERGE, or BITMAP CREATE...
Card Puncher Data Processing
Oracle Database - V$SQL_PLAN_STATISTICS_ALL

V contains memory usage statistics for row sources that use SQL memory (sort or hash-join). This view concatenates information in:...
Card Puncher Data Processing
PL/SQL - Cursor

A cursor in the context of Oracle. A cursor is a SQL datatype. A cursor is a pointer to a private SQL area that stores information processing a specific: SELECT or DML statement. The cursor data...



Share this page:
Follow us:
Task Runner