Re: 10g temp tbsp extent size when using workarea_size

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Wed, 5 Apr 2006 15:07:59 +0100
Message-ID: <gpudnYA7mJhVU67ZRVnysg@bt.com>

"Spendius" <spendius_at_muchomail.com> wrote in message news:1144230195.922745.254780_at_i39g2000cwa.googlegroups.com...
> Hello,
> Has anybody already noticed temp tbsp extent size-related issues
> in 10g when using WORKAREA_SIZE_POLICY='auto' and setting
> certain values for PGA_AGGREGATE_TARGET ? I'm using locally
> managed temp tablespaces... What UNIFORM SIZE should I
> specify, if necessary ? Does it only depend on the volumes and
> amounts of the sorts that will be performed on this DB ?
>
> Thanks.
> Spendius
>

Have you seen any issues, or are you just doing the 'due diligence' bit of just asking if anyone has noticed any ?

If the former, could you give us an example of your observations.

-- 
Regards

Jonathan Lewis
http://www.oracle.com/technology/community/oracle_ace/ace1.html#lewis

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

Cost Based Oracle: Fundamentals
http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html

Received on Wed Apr 05 2006 - 09:07:59 CDT

Re: 10g temp tbsp extent size when using workarea_size_policy=auto