8 Replies Latest reply: Nov 14, 2012 2:57 PM by 12cdb RSS

    How to avoid restarting the database instance after tuning parameters

    Krishna Nazare

      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.