PGA items ( not in this presentation ): PGA_AGGREGATE_TARGET 9i ( SORT_AREA_SIZE / HASH_AREA_SIZE ) Auto management of PGA works well for most environments but BATCH processing and/or DW etl and/or special cases may need special attention and custom settings turning off the auto stuff.
{}