Originally posted by sgodbole
.... If you want to change its value then you need to add it in pfile and start the database using this pfile and then recreate spfile from pfile.
No need for this spfile->pfile->change_parameter_in_pfile->recreate_spfile jumble. You can directly change any parameter (being static or dynamic) directly in spfile. In our case, a simple
Code:
ALTER SYSTEM SET sessions=170 SCOPE=SPFILE;
will do.
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
Reply With Quote