Databases Reference
In-Depth Information
The output can be seen in the following screenshot:
We can see that before the first execution we have 2220 sorts in-memory and 0 sorts on-disk.
We then set a
MANUAL
policy, reserving the size of 1000 database blocks of memory for
sorting, with the following statements:
ALTER SESSION SET WORKAREA_SIZE_POLICY = 'MANUAL';
ALTER SESSION SET SORT_AREA_SIZE = 1000;
ALTER SESSION SET SORT_AREA_RETAINED_SIZE = 1000;
After this change in the session configuration, observe that the number of on-disk sorts
changes from zero to one, because the sort cannot execute in-memory.
