This discussion is archived
8 Replies Latest reply: Nov 14, 2012 12:57 PM by user296828 RSS

How to avoid restarting the database instance after tuning parameters

Krishna Nazare Newbie
Currently Being Moderated
Hi,

For our product's backend database (oracle 11g r2), we have to set several tuning parameters. Some of these parameters will be in effect only after the instance is restarted. Is there a way these parameters can be set/preset during instance creation itself, or some other means, so that the additional restart can be avoided.

Thanks,
Krishna

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points