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

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 - 15:25:27 CST