Re: Oracle 8i - W2k - MultiProcessor and Thread Question

Hi!

You can't start oracle.exe on specific processor unless you manually set ORACLE_AFFINITY in registry.
It's the same with notepad and whatever other program, the Windows scheduler spreads your processe's threads among all available cpus.

Tanel.

"news.optonline.net" <rickms63_at_optonline.net> wrote in message news:brc4a.386948$HG.69520253_at_news4.srv.hcvlny.cv.net...
> Do all you agree, if a single instance of oracle is running on a
> multiprocessor system, can the threads that are launched by oracle.exe be
on
> different processors then the processor the oracle.exe started on?
>
> Rick
>
> "Tanel Poder" <tanel@@peldik.com> wrote in message
> news:3e514764_2_at_news.estpak.ee...
> > With an 8.0.4 heavily loaded database on NT4 I've seen it too often..
> >
> > Tanel.
> >
> > "Jim Kennedy" <kennedy-down_with_spammers_at_attbi.com> wrote in message
> > news:kwb4a.138994$SD6.6998_at_sccrnsc03...
> > > Never had that happen.
> > > Jim
> > >
> > > --
> > > Replace part of the email address:
kennedy-down_with_spammers_at_attbi.com
> > > with family. Remove the negative part, keep the minus sign. You can
> > figure
> > > it out.
> > > "Tanel Poder" <tanel@@peldik.com> wrote in message
> > > news:3e510b38$1_2_at_news.estpak.ee...
> > > > Yes, they will.
> > > > And often, when one thread crashes, your whole instance goes with
> it...
> > > *g*
> > > >
> > > > Tanel.
> > > >
> > > > "news.optonline.net" <rickms63_at_optonline.net> wrote in message
> > > > news:%H74a.383961$HG.68301770_at_news4.srv.hcvlny.cv.net...
> > > > > I know that on W2K with Oracle 8i that for an particular Instance
> > > > Oracle.exe
> > > > > is run. Oracle.exe then creates many threads. My question is, will
> the
> > > > > threads started by Oracle.exe run on a different CPU then the one
> > > > Oracle.exe
> > > > > was started on. If not, what is the benifit of having multiple
> CPU(s)
> > > > while
> > > > > running a single Instance?
> > > > >
> > > > > Rick
> > > > >
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>
Received on Mon Feb 17 2003 - 18:52:18 CST