Xref: alice comp.databases.oracle.server:79494
Path: alice!news-feed.fnsi.net!news.maxwell.syr.edu!news.mindspring.net!newsfeed.mindspring.net!firehose.mindspring.com!not-for-mail
From: "crumedgeon" <zimsbait@hotmail.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: using all available CPUs
Date: Sat, 1 Jan 2000 17:11:48 -0500
Organization: MindSpring Enterprises
Lines: 37
Message-ID: <84lu47$q5h$1@nntp9.atl.mindspring.net>
References: <84ese1$mbj$1@redftp.redftp.attws.com> <386E5A6C.E026E8FA@cc.gatech.edu>
X-Server-Date: 1 Jan 2000 22:12:23 GMT
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6600
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600

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@cc.gatech.edu> wrote in message
news:386E5A6C.E026E8FA@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?
>