Operating System - HP-UX
1745791 Members
4037 Online
108722 Solutions
New Discussion

Oracle 9i and "max_thread_proc"

 
SOLVED
Go to solution

Oracle 9i and "max_thread_proc"

I use Oracle 9i I would like to know if it has some parameters recommended for “max_thread_proc” for oracle for this parameter, is thus.

Max No. of Threads Allowed in Each Process

max_thread_proc 256 256 Static N/A
4 REPLIES 4
Ben Dehner
Trusted Contributor
Solution

Re: Oracle 9i and "max_thread_proc"

Depends on which Oracle 9i product you are using. We're running 64-bit database with max_thread_proc = 128, with no problems. (Yet). For Oracle Management Server 9i, Oracle recommends a value of 1024 or higher. I can't find the 9i database on Metalink, but 10g database requires 256 as the minimum value.
Trust me, I know what I'm doing
pabel
Valued Contributor

Re: Oracle 9i and "max_thread_proc"

Hi Lucas, Oracle recommends a value of 256 in max_thread_proc parameter.

Take a look at this powerpoint, it may help you a lot.

http://h21007.www2.hp.com/dspp/files/unprotected/database/HP3KOracle.ppt

Regards.
Florian Heigl (new acc)
Honored Contributor

Re: Oracle 9i and "max_thread_proc"

I remember we had occurences where oracle wouldn't come up with max_thread_proc=512 and now it's standarized to 2048 at our site.

Don't remember the gory details, but it's related to using a dedicated or shared server and the amount of user sessions You face. :)
yesterday I stood at the edge. Today I'm one step ahead.

Re: Oracle 9i and "max_thread_proc"

Decided problem modifying parameter max_thread_proc was with 256 modified for 1024.

Thanks.