How Do You Use Automatic Pga Memory Management With Oracle 9i And Abo

1.	How Do You Use Automatic Pga Memory Management With Oracle 9i And Above?
Answer» SET the WORKAREA_SIZE_POLICY PARAMETER to AUTO and set PGA_AGGREGATE_TARGET. Set the WORKAREA_SIZE_POLICY parameter to AUTO and set PGA_AGGREGATE_TARGET.

How Do You Use Automatic Pga Memory Management With Oracle 9i And Above?

Answer»

SET the WORKAREA_SIZE_POLICY PARAMETER to AUTO and set PGA_AGGREGATE_TARGET.

Set the WORKAREA_SIZE_POLICY parameter to AUTO and set PGA_AGGREGATE_TARGET.