Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

4.0.6 upgrade, hit Oracle max processes limit - Is there a suggested value for this parameter?

I've recently upgraded from RTC 3.0.1.2 to 4.0.6.   We had been using a max processes limit of 300, but this does not appear to be high enough for 4.0.6.  The system hit the num processes limit once during the actual upgrade process.  It then hit it again during the nightly ETL jobs.  (no users using the system at all yet)  

I am wondering if there is a suggested number for the max processes, or if we just need to bump it up and guess if it is enough.  

0 votes



3 answers

Permanent link

Hi Jason,

Usually decreasing the number of JDBC and Mediator pool connections would be the alternative to raising the Oracle limits.  Are you using WAS or Tomcat?

You do need to set the Oracle limit higher than the JDBC/Mediator connections due to ETLs and other system connections, but I am afraid there is no rule of thumb that I am aware of.

If you can provide the additional info, it might be able to comment further.  If you can get your DBA to give you the list of users accessing the databases, then it should also be able to guesstimate how many you (should) require.

Paul

1 vote

Comments

I'm running with Tomcat.   


Unfortunately the DBA's were locked out of the DB when the max limit was hit and they had to bounce the DB.  So we couldn't tell what was going on.   I now have access to see the current sessions and have been keeping an eye on that as well as the number of processes in v$process.   I've yet to see the number of processes get over 60, even when running all the ETL processes.   So I have no idea what would have caused it to jump up to over 300 processes.   The only idea I have is perhaps the first-time bulk migrations have some large, parallel sql that pushed it over the limit... 

Hi again Jason,

I have been holding off replying, as I too am unsure of why this limit would peak other than through natural causes, such as the upgrade.  I am afraid I am the wrong person to comment on the intricacies of upgrade in those terms.
Are you using Suspect Links in 4.x?  I know that this could take some time in the initial indices build...as will undoing the Suspect Links (turning it off, so be warned if you did!)
As you do have 300 Oracle connections, if you do continue to monitor the $vprocesses in Oracle and note you're not going above say 150, then you could increase the JDBC/Mediator pool sizes accordingly...see https://jazz.net/library/article/790. These JDBC/Mediator pool sizes are 128 by default btw


Permanent link
Hello Jason,

this section of the info center talks about the limits for open files and processes:

Planning to install on UNIX and Linux systems
http://pic.dhe.ibm.com/infocenter/clmhelp/v4r0m6/topic/com.ibm.jazz.install.doc/topics/c_special_considerations_linux.html
* hard nofile 65536
* soft nofile 65536
* hard nproc 10000
* soft nproc 10000

Best Regards,

Francesco Chiossi

0 votes

Comments

Thank you for this information.  The recommended OS settings for linux is good to know as well, but I was asking about the actual Oracle parameter which limits the number of processes for the DB.   


Permanent link
 Any answer to this?

0 votes

Comments

Hi Sterling,

Which aspect of this post were you interested in?  There is no absolute value for the Oracle connections, as it is usually based on your mediator pool sizes.  However, this is usually for the main Jazz applications.  I have seen admin and ETL users go outside this.
Please let me know if I didn't address something from your perspective too.

Hello,

I have 2 Oracle customers I am about to upgrade. We have experienced the file limit error above, but I was just researching any additional problems that may occur and how to combat them in advance.

Your answer

Register or log in to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 42

Question asked: May 05 '14, 10:28 a.m.

Question was seen: 5,927 times

Last updated: May 19 '14, 4:07 p.m.

Confirmation Cancel Confirm