Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Parallel Query Option on 7.3.4
What is the standard setting for these parameters if I have 5 CPU's?
B.Sc Yassir Khogaly wrote in message
<71qg8r$68p$1_at_newsreader1.core.theplanet.net>...
>you can select * from sys.v$PQ_TQSTAT to monitor you parallel query
>execution.
>
>Please make sure that you have correctly set the relevant Parallel query
>parameters in your init.ora
>and that the system resources allow for the given values of
>"parallel_min_servers & parallel_max_servers& PARALLEL_MIN_PERCENTt"
>
>
>Roman Gelfand wrote in message <71qf03$a93$1_at_news.monmouth.com>...
>>select /*+ PARALLEL(TBL1, 5) */ fld1, fld2, fld3, fld4 from tbl1 order by
>>fld5, fld6;
>>
>>The table tbl1 contains 5000 rows. Can anyone tell me why I am not seeing
>>performance improvement using parallel query option.
>>
>>Thanks for your help
>>
>>
>
>
>
Received on Wed Nov 04 1998 - 15:39:36 CST