Oracle Database - HASH AREA memory

Card Puncher Data Processing

About

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.





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



Share this page:
Follow us:
Task Runner