Oracle Database - WORK_AREA_SIZE_POLICY

Card Puncher Data Processing

About

WORK_AREA_SIZE_POLICY is a parameter to manage the pga.

It's a new features of Oracle 9i.

alter session workarea_size_policy = manual;
alter session workarea_size_policy = auto;

If WORK_AREA_SIZE_POLICY = AUTO, the hash_area_size and sort_area_size setting are ignored, Oracle will set them automatically, using 10MB when appropriate, 1MB when that is better and 100KB when that make sense. In fact, the amount used can vary from statement to statement in your session as the load goes up and down over time.

This parameter is extremely useful for huge sorting/grouping systems. The parameter informs the server that it should take over PGA memory management.





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 - HASH AREA memory

hash area is an area of the pga memory which is controled by the sort_area_size parameter if the WORKAREA_SIZE_POLICY is not set to AUTO.
Card Puncher Data Processing
Oracle Database - HASH_AREA_SIZE parameter

HASH AREA SIZE is a parameter which set the hash area size of the pga memory. It will have no effect if WORKAREA_SIZE_POLICY is set to auto.
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_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 - 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 - V

V displays information work areas used by SQL cursors. The primary key for the view is WORKAREA_ADDRESS, the memory Address...
Oracle Database Direct Path Read Temp With Parallel Slave
Oracle Database - direct path read temp and direct path read wait event

“direct path read temp” and “direct path read” event are wait events. When a session is reading buffers from disk directly into the PGA (opposed to the buffer cache in SGA), it waits on this event....



Share this page:
Follow us:
Task Runner