Re: Oracle parallel query on windows NT

Just a thought :

Did you change the definitions of the tables or views ?

• alter table xxx parallel ( degree <number > )

Are your tables distributed over significant number of disks ?

Do you have enough memory and CPUs ?

Good luck

juliay_at_my-dejanews.com wrote in article <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 Mon Apr 05 1999 - 23:35:34 CDT