Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How change "sessions" parameter when spfile?

XenofonFeb 8 2010 — edited Dec 4 2012
Hi,
I am running a 10g XE database, which is spfile based.

How can I change the "sessions" parameter?

According to the documentation it is a non-modifiable parameter, which that it cannot be set through ALTER SYSTEM or ALTER SESSION commands. So how should I change it. Should I manipulate the init*.ora file and restart the DB? Will then the init*.ora file be reread?

Is there a way to create a text-init.ora file out of a sp-file?

Thanks in advance
This post has been answered by Aman.... on Feb 8 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 1 2013
Added on Feb 8 2010
#general-database-discussions
10 comments
25,612 views