Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium



Posted on 2011-04-19
Medium Priority
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

Accepted Solution

Cha1tu earned 668 total points
ID: 35424707
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

by:Praveen Kumar Chandrashekatr
Praveen Kumar Chandrashekatr earned 664 total points
ID: 35426605

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

mrjoltcola earned 668 total points
ID: 35433410
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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
This video shows how to recover a database from a user managed backup
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.
Suggested Courses
Course of the Month10 days, 18 hours left to enroll

571 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