Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle thread scheduling on NT with 4 processor configuration
Processor afinity not supported in Oracle 7
In Oracle 8 you can use ORACLE_AFINITY registry value
RP Data Solutions wrote:
> 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 Thu Jan 21 1999 - 05:27:23 CST