Re: Problem w/ Oracle Multithreading

Stilian

You misunderstood what I wrote. Multithreaded Server is a way of configuring Oracle so that server processes can be shared amongst multiple clients. Check the Concepts Guide for more information.

The ORACLE73.EXE process (or whatever version you're on) is as you say always multithreaded on NT. These threads are the equivalents of the background processes (PMON, SMON, DBWR, LGWR etc.) that you see in other environments such as Unix.

HTH. Pete

Stilian Elenkov wrote:

> Oracle7 (just like 8) has at least 6 threads as part of the
> ORACLEXX.EXE. See them using a thread display tool, or do select * from
> v$session - the first six entries. So technically one tread could be
> processing data in a PLSQL block another could be updating data to disk
> and yet another one - updating the logs etc. You can monitor the CPUs
> over a longer period of time and see this. Even in a predominantly
> SELECT oriented environment the extra CPUs are put to a good use - like
> sending a cashed result set while retrieving another result set from
> disk. Aso there is an add on Parallel Query option for Oracle 7 (it
> costs extra though). Even if Oracle 7 was not multithreaded, the fact
> that the OS is means that at least disk /file cache data manipulations
> is done in parallel with the Oracle process and the extra CPUs are used.
> There is NO way that Oracle/NT uses ONLY 1 CPU with 6 threads running.
> How did you determine that?
> I have a dual Xeon machine with both of these occasionally pegged (big
> reports) while running Oracle 7.3.2.3.15 on NT SP5.
>
> Stilian
>
> Pete Sharman wrote:
> >
> > 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 Fri Sep 17 1999 - 10:25:03 CDT