Home » RDBMS Server » Server Administration » A Question about PARALLEL_MAX_SERVERS parameter
A Question about PARALLEL_MAX_SERVERS parameter [message #55024] Fri, 27 December 2002 05:21 Go to next message
Goldy
Messages: 2
Registered: December 2002
Junior Member
I have a Oracle 8.1.7 instance on 2xCPU WinNT Server.
What values I should use for next parameters :
parallel_max_servers
parallel_min_servers
parallel_server...
and other related parameters

Report message to a moderator

Re: A Question about PARALLEL_MAX_SERVERS parameter [message #55092 is a reply to message #55024] Thu, 02 January 2003 17:06 Go to previous message
Trifon Anguelov
Messages: 514
Registered: June 2002
Senior Member
That depends on either you setup PARALLEL_AUTOMATIC_TUNING and PARALLEL_ADAPTIVE_MULTI_USER parameters already. If so, Oracle will manage the best values for these parameters.

Otherwise:

parallel_min_servers = 1
parallel_max_servers = cpu_count

Hope that helps,

clio_usa
OCP - DBA

Visit our Web site

Report message to a moderator

Previous Topic: Clean temp tablespace
Next Topic: Is there some way to know who,what ,how ...
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 04:37:25 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.