Re: Fwd: 9.2 - Parallel Query Not Working

From: Oxnard Montalvo <oxnard_at_carolina.rr.com>
Date: Thu, 27 Mar 2008 18:48:58 -0400
Message-ID: <6963082.172091206658138454.JavaMail.root@cdptpa-web07-z02>

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

Received on Thu Mar 27 2008 - 17:48:58 CDT

This message: [ Message body ]
Next message: Pratap Singh (c): "RE: create a view with parallel hint"
Previous message: Oxnard Montalvo: "Re: create a view with parallel hint"
Maybe in reply to: Tony Adolph: "Fwd: 9.2 - Parallel Query Not Working"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message