Re: Oracle parallel query on windows NT

Do you have the parallel query option installed? In NT task manager right click on oracle80.exe and check the cpu affinity and make sure all 4 processors are checked. when you created the table did you include parallel(degree xx) or in enterprise manager quick edit the table and make sure there is a number in the last tab if not check value and enter whatever degree of parallelism. the cpu count should be correct as oracle detects this go ahead and make the parallel min and max servers settings the same I have had problems with this before.
Also the select /*+PARALLEL*/ hint
or change the optimizer percent parallel to 100 also make sure you spread the tablespace's datafiles across as many drives as you can.
also make sure you have enough ram to support those 40 query servers that you just activated.
That's everything I know to check maybe somebody else can add something that I forgot

John

juliay_at_my-dejanews.com wrote in message <7e3hpi$8d7$1_at_nnrp1.dejanews.com>...
>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
Received on Sun Apr 11 1999 - 11:16:11 CDT