Re: Parallel query

From: Stefan Roesch <sroesch3_at_attbi.com>
Date: Tue, 04 Dec 2001 07:56:39 GMT
Message-ID: <Xk%O7.4744$TZ1.30308@rwcrnsc51>

Hi Michiel,

with 8i the easiest way to use parallel query ist to set the init.ora parameter parallel_automatic_tuning to true, then you don't have to set a parallel degree for the individual tables

Stefan

Michiel Brunt wrote:

> We use Oracle 8i for a data warehouse. There is a large (>20 mln) fact
> table and smaller dimension tables (max 100.000).
> Parallel processing should be useful, but what tables should be altered
> for parallel query?
> Thanks
> Michiel
Received on Tue Dec 04 2001 - 01:56:39 CST