Re: using all available CPUs

Hello,

The init.ora parameter CPU_COUNT is the one you want. Don't forget, you should also bump up your LATCH usage using DB_BLOCK_LRU_LATCHES to allow access to the CPU resources. (LRU should be CPU_COUNT/2)

//
cr
OCP-DBA "Paul Bennett" <bennett_at_cc.gatech.edu> wrote in message news:386E5A6C.E026E8FA_at_cc.gatech.edu...
> This brings up another question.
>
> The OPQ section of database concepts discusses what is necessary to make one
SQL
> statement execute in parallel, but it does not discuss what is necessary for
> different SQL statements to be processed in parallel. If four different users
> execute four different SQL statements on a four processor machine, does each
> statement get it's own processor? Do the tables have to be different? Do the
> tables have to reside in different tablespaces? What are some more
constraints,
> or where can I find information about this?
>
> Thanks.
>
> -- Paul
>
> Verna Legaspi wrote:
>
> > Hello. We have a Sun E4000 with 6 CPUs. Running Solaris 2.6 & Oracle
> > 8.0.5. Is there some parameter, setting, option, etc. that I need to
> > configure in order for Oracle to take advantage of all the CPUs? Or is this
> > only something that can be done on the SQL side?
>
Received on Sat Jan 01 2000 - 16:11:48 CST