Re: Problem w/ Oracle Multithreading

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 Wed Sep 15 1999 - 16:11:48 CDT