Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> 10g temp tbsp extent size when using workarea_size_policy=auto

10g temp tbsp extent size when using workarea_size_policy=auto

From: Spendius <spendius_at_muchomail.com>
Date: 5 Apr 2006 02:43:15 -0700
Message-ID: <1144230195.922745.254780@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
Received on Wed Apr 05 2006 - 04:43:15 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US