Re: Fwd: 9.2 - Parallel Query Not Working

We had some problems with 9206 doing parallel. 

We unset as much of the not used much parameters in the init.ora.

We made a big table .. 20 million rows

select /*+ parallel(tab) */ * from tab

worked. The syntax of    parallel(tab, 4)   or some other number never worked 
for us. but it does work in 10.2


--
http://www.freelists.org/webpage/oracle-l

Other related posts: