Oracle Database - HASH_AREA_SIZE parameter

Card Puncher Data Processing

Oracle Database - HASH_AREA_SIZE parameter

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



Share this page:
Follow us:
Task Runner