Oracle Database - HASH_AREA_SIZE parameter

Card Puncher Data Processing

About

HASH AREA SIZE is a parameter which set the hash area size of the pga memory.

alter session set hash_area_size = 1024;

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





Discover More
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 - 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 - 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...
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