Enterprise Manager

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!

alter system set processes = 900 scope=spfile sid= '*';

Ayu3uLMar 15 2018 — edited Mar 16 2018

recently i facing error ORA-00018: maximum number of sessions

i am new dba and now i need to increase session for database by altering processes from 780 to 900.

but it gives me this error: ORA-02095: specified initialization parameter cannot be modified.

Request your help~

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 13 2018

Added on Mar 15 2018

10 comments

39,200 views