Hi All ,
Please let me know , whether Database bounce is needed , if we add a new parameter [parallel_force_local] to be added / appended to the existing pfile/spfile.
This parameter is not all present in the Database , however I am aware that we change its value True to false or vice versa with out a DB bounce .
But adding this new parameter to the init file , needs a DB bounce ?
Thanks , but I want to add the Parameter ( this doesn't exists in the initi file now ) , not change/modify its value .
does adding a new parameter needs a bounce ?
Edited by: 984252 on Feb 22, 2013 6:18 AM
No. You can add a new parameter to the spfile at any time. You do not have to bounce the database.
The new parameter will not take effect until the next bounce, but you can add it anytime.
alter system set parameter=value scope=spfile;