Re: How to tune a huge SELECT ?

From: Niall Litchfield <niall.litchfield_at_dial.pipex.com>
Date: Fri, 13 Sep 2002 09:28:54 +0100
Message-ID: <3d81a1c4$0$8506$cc9e4d1f@news.dial.pipex.com>

"Nuno Souto" <nsouto_at_optushome.com.au> wrote in message news:dd5cc559.0209121954.f315e9b_at_posting.google.com...
> chse30_at_hotmail.com (Christian Svensson) wrote in message
news:<ccc2a7eb.0209060550.55afae93_at_posting.google.com>...
> > What I wonder is what Oracle setting/tuning can you make when you want
> > to get this amount of data from the database ?
>
> Hmmmm,
> _NETWORK_FAST = TRUE
> comes to mind. Another one I'd try would be:
> _PARALLEL_EXECUTION = TRUE.
>
> _LOTS_OF_CPUS = TRUE
> rings a bell as well.

_APPROPRIATE_PARTITIONS=ENABLED and as Billy has said

_PROBLEM_REWRITE_ENABLED=TRUE

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************

Received on Fri Sep 13 2002 - 03:28:54 CDT