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: Oracle thread scheduling on NT with 4 processor configuration

Re: Oracle thread scheduling on NT with 4 processor configuration

From: RP Data Solutions <rpdata_at_cyberus.ca>
Date: Wed, 20 Jan 1999 23:54:04 GMT
Message-ID: <36a66be0.940847907@news.cyberus.ca>


Don't know if it can be done, but have you configured the parallel query option?

Robert
nordby_at_channelpoint.com wrote:

>Hello,
>
>We are running some performance testing on NT to prove how scalable Oracle
>7.3.4 and 8.0.5 is, and to use that information to influence our architecture
>accordingly.
>
>We see connection threads being scheduled to the least busy processor, and
>are happy with the results. However, it seems that when a single connection
>thread is running against the Oracle server, the set of core Oracle threads
>(dbwr, pmon, smon, etc.) do not get scheduled evenly between the three idle
>processors.
>
>Does anyone know if on NT4.0 that Oracle 7.3.4 Worgroup Server threads can be
>scheduled on separate processors, and how to verify that is or is not
>happening?
>
>On a Unix smp box, can the different Oracle processes be scheduled on distinct
>processors?
>
>Thanks!
>Jon
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own

Robert Prendin
RP Data Solutions Inc.
Specializing in ORACLE DBA Support Services Received on Wed Jan 20 1999 - 17:54:04 CST

Original text of this message

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