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: Problem w/ Oracle Multithreading

Re: Problem w/ Oracle Multithreading

From: Pete Sharman <psharman_at_us.oracle.com>
Date: Thu, 16 Sep 1999 08:31:29 -0700
Message-ID: <37E10D51.D6E27759@us.oracle.com>


Multithreaded Server is available on NT with Oracle8. As you say, it's not there with Oracle7.

Pete

Burkhard Schneider wrote:

> hello marc, (Hallo Marc, i am german)
>
> under NT there are no multithreaded parameter settings available. the
> oracle process itself is already sub-divided inth threads so you can do
> anything here. multi-processor usage is with 7.x, as far as i know, not
> supported, so your other processors are running without work.
> the whole process deisgn under nt is total different from the one under
> unix.
> activating parallel query option depends on the usage of your database,
> so for this part i can recommend you to read the oracle documentation or
> to go around in internet where many other DBAs have their own internet
> sites with lots of informations.
> are you using own developed sql-scripts or third party products that run
> against the database ? optimizing always starts first with looking at
> the sql-statements.
> do you constantly get the all the monitoring values to see the
> bottlenecks if there are any ?
>
> best regards
>
> burkhard schneider
>
> Marc Holz schrieb:
> >
> > Hi,
> >
> > We are running an Oracle 7.3.4 based Document Management system and
> > are encountering problems with Oracle's Multihreading.
> > The application communicates per SQL EasyNet with the database host.
> > The database is running on a four processor NT 4.0 SP 5 box
> > but doesn't use more than 1 processor for all Oracle threads
> > at the same time. In other words, one processor is running w/ full load,
> > other 3 do nothing.
> > Do we need to do some special adjustments to activate
> > Oracle's Multithreading or do we need the parralell query option for our
> > SMP?
> > We appreciate any hint to solve this problem.
> >
> > Thanks in Advance,
> >
> > Marc Holz -> mailto:Marc.Holz_at_nbgm.siemens.de
> >
> > Siemens AG -> http://www.siemens.de
> > A&D SH53 -> http://www.ad.siemens.de/sw-haus
> > 90475 Nürnberg
> > Gleiwitzerstraße 555
> > Tel + 49 911 895 3578
> > Fax + 49 911 895 4802


Received on Thu Sep 16 1999 - 10:31:29 CDT

Original text of this message

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