Look into Oracle9i's automatic memory management features. If the initialization parameter WORKAREA_SIZE_POLICY is set to AUTO, you can set the PGA_AGGREGATE_TARGET parameter to specify the total amount of memory that can be used by Oracle processes on your system. Oracle will automatically allocate this memory among processes that need it, depending on the operations they are performing. Oracle attempts to keep the amount of private memory below the target specified by this parameter.
Dig Deeper on Oracle database performance problems and tuning
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.