Posted on 2011-04-19
Last Modified: 2013-11-11
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
Question by:hussainkhan22
    LVL 2

    Accepted Solution

    we don't need to bounce the database for this alter system set PGA_aggregate_target=200 scope=spfile;

    Changes the parameter's value for the running instance only. As soon as the instance is stopped and started, this change will be lost.
    Alters an initialization parameter in the spfile
    Alters an initialization parameter in the spfile as well as in the running instance.
    LVL 12

    Assisted Solution


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

    for info on this parameter check this doc.

    LVL 40

    Assisted Solution

    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.

    Featured Post

    What Is Threat Intelligence?

    Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

    Join & Write a Comment

    I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
    Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
    This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
    This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now