Oracle Database - Sort Area memory

Card Puncher Data Processing

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.

sysstat

V$ table

SELECT name, value FROM V$sysstat WHERE name LIKE 'sort%';





Discover More
Card Puncher Data Processing
Oracle Database - (Query) Work Area

The work area is an memory area that is used to perform data operation such as: SORT see sort area memory, HASH JOIN see hash area memory, GROUP BY, BUFFERING, BITMAP MERGE, or BITMAP CREATE...
Card Puncher Data Processing
Oracle Database - Physical I/O

A physical read, I/O of table or index data places the block into the buffer cache. Then we perform a logical io to retrieve the block. Hence, most physical read are immediately followed by a logical io....
Card Puncher Data Processing
Oracle Database - Physical Read

The physical read statistic from the autotrace statistics is a measure of how much real I/O, or physical i/o, your query performed. A physical read of table or index data places the block into the buffer...
Card Puncher Data Processing
Oracle Database - Process global area (PGA) - Work Area

The PGA memory is a memory allocated for each session. The PGA (Program or Process Global Area) is a memory area that stores data and control information for a single server process. It typically contains...
Card Puncher Data Processing
Oracle Database - SORT_AREA_SIZE parameter

SORT AREA SIZE is a parameter which set the sort area size of the pga memory. 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...
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