Re: Problem w/ Oracle Multithreading

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 - 09:59:20 CDT