Oracle Database - Sort Area memory

> Database > Oracle Database

1 - About

sort area is a area of the pga memory which is controled by the sort_area_size parameter if the WORKAREA_SIZE_POLICY is not set to AUTO.


3 - sysstat

V$ table

SELECT name, VALUE FROM V$sysstat WHERE name LIKE 'sort%';
db/oracle/sort_area.txt · Last modified: 2017/09/06 19:29 by gerardnico