Re: query slow in 9i, but not slow in 8i

  • From: "Jonathan Lewis" <jonathan@xxxxxxxxxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 2 Mar 2004 12:22:52 -0000


I should have checked before posting.

pga_aggregate_target defaults to zero,
and the instance won't start if you set
it to zero when workarea_size_policy 
is set to AUTO.

It's DBCA that sets the pga_aggregate_target
to 25M for you if you don't interfere. (Giving
you a whole new meaning for 'default install')

Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

March 2004 Hotsos Symposium - The Burden of Proof
  Dynamic Sampling - an investigation
March 2004 Charlotte OUG (www.cltoug.org) CBO Tutorial 
April 2004 Iceland
June  2004      UK - Optimising Oracle Seminar


----- Original Message ----- 
From: "Jonathan Lewis" <jonathan@xxxxxxxxxxxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
Sent: Tuesday, March 02, 2004 9:38 AM
Subject: Re: query slow in 9i, but not slow in 8i


> 
> True -
> 
> If work_area_policy = auto in 9.2, then the
> pga_aggregate_target is used.  Since this
> defaults to 25M (better check that) and the
> limit for a process is 5% of total, then the
> v9 run is probably trying to do its sort with
> 1.25M, rather than the 90M used by 8i.
> 


----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 03-2004