Oracle Database - V$SQL_WORKAREA

> Database > Oracle Database

1 - About

V$SQL_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 V$SQL view.

V$SQL_WORKAREA lists all work areas needed by these child cursors; V$SQL_WORKAREA can be joined with:

  • V$SQLAREA on (ADDRESS, HASH_VALUE)
  • and with V$SQL 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?
Advertising

3 - Documentation / Reference

db/oracle/v_sql_workarea.txt · Last modified: 2017/09/06 22:18 by gerardnico