Bayt.com

Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

How do you use automatic PGA memory management with Oracle 9i and above?

Oracle
user-image
Question added by khalid Hassanien , Financial Manger , Alrwania Ltd
Date Posted: 2014/10/12
Upvote (0) Views (1) Followers (1) Answers (1) Report Question
Write an Answer
Register now or log in to answer.
Dhairyasheel Tawade
by Dhairyasheel Tawade , Principal Technical Account Manager , Oracle India

Just set PGA_AGGREGATE_TARGET TO SOME VALUE.

SET WORKAREA_SIZE_POLICY=AUTO AND WORT_AREA_SIZE TO NULL.

 

 

Write Your Answer
More Questions Like This