Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Can I change the values of parameters without bringing database down.

555530Apr 29 2011 — edited Apr 29 2011

Hi All,

Is database need to be restarted if these parameters value is changed. Can I change the parameter values without restarting the database.

--> pga_aggregate_target
--> memory_target
--> streams_pool_size
--> sga_target

Thanks !

Locked Post

New comments cannot be posted to this locked post.

Locked on May 27 2011

Added on Apr 29 2011

#general-database-discussions

4 comments

698 views