Not sure what spfile would do but in my version of Oracle, you definitely have to recycle the db to see the effect of the increase.

Regards,
Mel

hans theveneau stolte <oracledba-ezmlmshield-x162971.[Email address protected] wrote:
Want to increase session connections from 300, but dont want to take DB
offline, is there a way to do this ie: spfile?

--
---------------------------------------------
Nothing is foolproof to the professional fool

Hans Theveneau Stolte.


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: send a blank email to oracledba-[Email address protected]
By using this list you agree to these terms:http://www.lazydba.com/legal.html


---------------------------------
Do you Yahoo!?
Friends. Fun. Try the all-new Yahoo! Messenger

Oracle LazyDBA home page