query slow in 9i, but not slow in 8i 2004-03-02 - By Niall Litchfield
I had a discussion a while back about the way the use of dbca rather changes the meaning of 'default '. I *think* that this was in relation to wether the default for 9i was to create a locally managed system tablespace or a dictionary mangled one. Dbca has had a habit of setting parameters/options that arguably should be set but in a rather silent manner.
Cheers
Niall Litchfield
Oracle DBA
Audit Commission
+44 117 975 7805
> -- --Original Message-- --
> From: jonathan@(protected)
> Sent: 02 March 2004 12:22
> To: jonathan@(protected); oracle-l@(protected)
> Subject: Re: query slow in 9i, but not slow in 8i
>
>
>
>
> 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@(protected) >
> To: <oracle-l@(protected) >
> 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@(protected)
> put 'unsubscribe ' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
>
>
**********************************************************************
This email contains information intended for
the addressee only. It may be confidential
and may be the subject of legal and/or
professional privilege. Any dissemination,
distribution, copyright or use of this
communication without prior permission of
the sender is strictly prohibited.
**********************************************************************
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
To unsubscribe send email to: oracle-l-request@(protected)
put 'unsubscribe ' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
|
|
