Database Tuning (MOSC)

MOSC Banner

Question about Oracle processes parameter

edited Jun 12, 2013 11:20AM in Database Tuning (MOSC) 6 commentsAnswered
I have a question about Oracle processes. It seems like I do not understand the behavior of processes parameter.

We have been running for several years an application that accesses an Oracle 10.2.0.5 instance running on Sun-Fire-880 (8cpus). This instance has processes=300 and it's been working fine for years.

We got a new system - Sun-Fire-T200 with 32 cpus. I created a new 10.2.0.5 instance and used impdp to copy the data. Testing this new environment we are getting problems with not enough processes. So I increased the processes to 800 and it seems to work fine (so far, we're still testing). I've been checking on the number or processes on this machine and I can see increasing processes (using ps -ef | grep oracle | wc).

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center