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