Automatic Runtime Memory Tuning
•One parameter:
PGA_AGGREGATE_SIZE
= <size>
•Dynamic allocation of ‘runtime’ memory based upon each query’s requirements
–In data-warehouse
environments, >50% of a server’s physical memory is typically used for query ‘runtime’ memory
•Benefits:
–Reduced overall memory
usage
–Improved throughput
–Simplified tuning