4.9.42 Oracle PGA

Item	Description	Evaluation
Memory sort hit rate	Sorts should be performed in memory whenever possible. Sorting in memory is far quicker than using the disk.	Increase the value of the initialization parameter "SORT_AREA_SIZE" or "PGA_AGGREGATE_TARGET". Note: - "PGA_AGGREGATE_TARGET" is a new initialization parameter that was added in Oracle9i. - Pay attention to the remaining memory capacity. - Because changes to the above initialization parameter can change the execution plans for optimizing all SQL statements, be wary of changing the value, unless the memory sort hit rate has become a major problem.

Item

Description

Evaluation

Memory sort hit rate

Sorts should be performed in memory whenever possible. Sorting in memory is far quicker than using the disk.

Increase the value of the initialization parameter "SORT_AREA_SIZE" or "PGA_AGGREGATE_TARGET".

Note:

- "PGA_AGGREGATE_TARGET" is a new initialization parameter that was added in Oracle9i.

- Pay attention to the remaining memory capacity.

- Because changes to the above initialization parameter can change the execution plans for optimizing all SQL statements, be wary of changing the value, unless the memory sort hit rate has become a major problem.