Re: Oracle parallel query on windows NT

Have you had any answer to this question? I am curious to how well Oracle scales on NT.

In article <7e3hpi$8d6$1_at_nnrp1.dejanews.com>,   juliay_at_my-dejanews.com wrote:
> We have an Oracle 8.0.4 database running on a Wondows NT Server with 4 CPU
> processors. when we run queries on this machines, we can see through Task
> Manager on Windows NT that only one CPU is utilized, the other three CPUs are
> idle.
>
> We did the following approachs to try to improve the performance, but did not
> get a better results,
>
> 1. changed some parameters in the init file, like
> CPU_COUNT,
> PARALLEL_MIN_SERVERS,
> PARALLEL_MAX_SERVERS
>
> 2. run the qery with many different hints, like
> SELECT /*+ ALL_ROWS */
> SELECT /*+ INDEX_FFS ... +/
> SELECT /*+ FULL(...) PARALLEL(table1,8, default) */
> SELECT /*+ PARALLEL_INDEX...*/
>
> Would anyone has ever encountered the same situation or anyone has a clue
> about how oracle takes the adventage of multiple CPUs to improve the
> performance ? Or maybe someone knows a good book or documentaion related to
> this issue....
>
> We appreciate your help !
>
> -Julia Yang
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Apr 09 1999 - 11:09:43 CDT