Oracle Database - SORT_AREA_SIZE parameter

> Database > Oracle Database

Table of Contents

1 - About

SORT AREA SIZE is a parameter which set the sort area size of the pga memory.

ALTER session SET sort_area_size = 102400;

It will have no effect if the WORKAREA_SIZE_POLICY is set to auto.

The sort area size control how much memory will be dynamically allocated at runtime in order to satisfy a sort request. After the sort is completed, this memory will be released entirely.

The sort area size are not a permanently allocation of memory.

Advertising