I just ran the query below. However, no data was found in sys.v$pw_tqstat.
Roman Gelfand wrote in message <71qher$c01$1_at_news.monmouth.com>...
>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:47:39 CST
