Oracle Database - SORT_AREA_SIZE parameter

Card Puncher Data Processing

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.





Discover More
Card Puncher Data Processing
Oracle Database - How to detect read from the temporary tablespace ?

How to detect read from the temporary tablespace ? Step followed : disable automatic PGA management by the server set the hash area size. and play with the sort area size In this example, the...
Card Puncher Data Processing
Oracle Database - Sort Area memory

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. V$ table
Card Puncher Data Processing
Oracle Database - WORK_AREA_SIZE_POLICY

WORK_AREA_SIZE_POLICY is a parameter to manage the pga. It's a new features of Oracle 9i. If WORK_AREA_SIZE_POLICY = AUTO, the hash_area_size and sort_area_size setting are ignored, Oracle will set them...
Card Puncher Data Processing
Oracle Database - sorts (memory) statistics

Sort done in the user's session memory (sort area). Controlled via the sort_area_size database parameter.



Share this page:
Follow us:
Task Runner