Re: parallel query

From: DA Morgan <damorgan_at_psoug.org>
Date: Mon, 10 Jul 2006 12:52:38 -0700
Message-ID: <1152561161.395754@bubbleator.drizzle.com>

Charles Hooper wrote:

> I noticed a similar trend in 10g R2 when the workarea_size_policy is
> set to auto, and the pga_aggregate_target is set to 2GB. These are
> likely single pass sorts to disk are are being recorded. I was able to
> virtually eliminate the sorts to disk on my system by setting
> sort_area_size to 20M

How many simultaneous users on the system?

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Received on Mon Jul 10 2006 - 14:52:38 CDT