Re: Fwd: 9.2 - Parallel Query Not Working
Date: Thu, 27 Mar 2008 18:48:58 -0400
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.2Received on Thu Mar 27 2008 - 17:48:58 CDT