PGA_aggregate_target

SQL> alter system set PGA_aggregate_target=200 scope=spfile;                                             Its a oracle 11g database on Linux server.  Does setting this parameter requires database bounce or not
hussainkhan22Asked:
Who is Participating?
 
Cha1tuCommented:
we don't need to bounce the database for this alter system set PGA_aggregate_target=200 scope=spfile;

scope=memory
Changes the parameter's value for the running instance only. As soon as the instance is stopped and started, this change will be lost.
scope=spfile
Alters an initialization parameter in the spfile
scope=both
Alters an initialization parameter in the spfile as well as in the running instance.
0
 
Praveen Kumar ChandrashekatrDatabase Analysist Senior Commented:
hi,

This is a dynamic parameter, you can change the value without bouncing the database.

for info on this parameter check this doc.

http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/initparams157.htm

                                                           or

http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:17748700346068277 
0
 
mrjoltcolaCommented:
As praveen says, it is dynamic.

But the important point here is you should use "scope = both".

If you use scope = spfile, it won't take effect until next restart.
If you use scope = memory, it won't be a permanent change and will go away after next restart.
Neither is preferred, you want to change it permanently and take effect immediately.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.