Make sure you have a large enough sort_area_size set so the data doesn't go
to disk (temp tablespace) while sorting.

Dave
----- Original Message -----
From: "Jenny" <oracledba-ezmlmshield-x96208125.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Friday, January 27, 2006 5:33 PM
Subject: sql tuning.


> Hi, gurus!
>
> Any one had a positive experience with using partitioning/parallel select
> on a small-ish databases? I am getting desperate ...
> Must improve performance of one query, which performs decently, but I am
> asked to "improve", and seems like no matter what I try I am hitting a
> wall.
> I know my question is too generic, and it is all too
> environment-dependent...so I am looking for an inspiration! Any war
> stories appreciated.
>
> Thanks,
> Jenny
>
> Visit our website at http://www.ubs.com
>
> This message contains confidential information and is intended only
> for the individual named. If you are not the named addressee you
> should not disseminate, distribute or copy this e-mail. Please
> notify the sender immediately by e-mail if you have received this
> e-mail by mistake and delete this e-mail from your system.
>
> E-mail transmission cannot be guaranteed to be secure or error-free
> as information could be intercepted, corrupted, lost, destroyed,
> arrive late or incomplete, or contain viruses. The sender therefore
> does not accept liability for any errors or omissions in the contents
> of this message which arise as a result of e-mail transmission. If
> verification is required please request a hard-copy version. This
> message is provided for informational purposes and should not be
> construed as a solicitation or offer to buy or sell any securities or
> related financial instruments.
>
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com
> By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
>



Oracle LazyDBA home page