Skip to Main Content

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!

What is the relationship between Process and Session parameter in Oracle

601939Jul 18 2008 — edited Jul 18 2008
Hi All

I ran into a problem
"ORA-00020: maximum number of processes (150) exceeded " on the other day and I want to fix this temporary by increase the process by some number like 200.
Someone suggesting the syntax to fix my problem then the database must restart after running this command.

alter system set processes=200 scope=spfile;

However, I check the v$Paramenter view I see 2 values I believe they go together are
Processes: 150
Sessions:170.

Here are my questions:
1. "alter system set processes=200 scope=spfile;" is the correct way to increase the max Processes?
2. Do I have change the number of Sessions after changing the number of Processes?
3. Is there other way to increase the processes number without reboot the Oracle database?


Regards,

Jdang
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 15 2008
Added on Jul 18 2008
3 comments
4,612 views