Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Large pool

Re: Large pool

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 14 Feb 2006 06:46:19 -0800
Message-ID: <1139928379.663629.234930@z14g2000cwz.googlegroups.com>


What version of Oracle?
Are your running shared server? (formerly known as MTS)

>From the 9.2 Reference manual >>

Default value
 0 if both of the following are true:
The pool is not required by parallel execution DBWR_IO_SLAVES is not set
Otherwise, derived from the values of PARALLEL_MAX_SERVERS, PARALLEL_THREADS_PER_CPU, CLUSTER_DATABASE_INSTANCES, DISPATCHERS, and DBWR_IO_SLAVES.
<<

Do you have any of these other parameters set?

HTH -- Mark D Powell -- Received on Tue Feb 14 2006 - 08:46:19 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US