Oracle 9i and "max_thread_proc" (188 Views)
Posts: 36
Registered: ‎06-24-2005
Message 1 of 5 (188 Views)
Accepted 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
Trusted Contributor
Posts: 182
Registered: ‎02-17-1999
Message 2 of 5 (188 Views)

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
Valued Contributor
Posts: 49
Registered: ‎09-23-2001
Message 3 of 5 (188 Views)

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.

Honored Contributor
Posts: 1,546
Registered: ‎08-25-2003
Message 4 of 5 (188 Views)

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.
Posts: 36
Registered: ‎06-24-2005
Message 5 of 5 (188 Views)

Re: Oracle 9i and "max_thread_proc"

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

The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation.