Re: Fwd: 9.2 - Parallel Query Not Working

  • From: Oxnard Montalvo <oxnard@xxxxxxxxxxxxxxx>
  • To: tony.adolph.dba@xxxxxxxxx
  • 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.2


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


Other related posts: