Search notes:

Oracle: SQL work areas

The SQL work areas are part of the PGA and are used for operations that require non-trivial amounts of memory, such as

sorting data
grouping data into hash buckets

See also

v$sql_workarea shows which SQL statements (and plan operators) are using how much memory in work areas.

The init parameter workarea_size_policy.