Gurus:
To change the parameters using spfile
1) does it require the DB to be down first?
2) If DB is NOT down while the parameter is changed, DB needs to be re-started?
3) I am NOT used to the spfile, can I do in the old fashioned way?
Thanks!