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