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 -> temp extent size

temp extent size

From: viny <vinsharma1808_at_gmail.com>
Date: 18 Jan 2007 14:16:08 -0800
Message-ID: <1169158568.623047.77250@a75g2000cwd.googlegroups.com> 





My sort area size is 8MB  and db_block_size is 8KB



I have created locally managed temporary tablespace. What should be
ideal value for INITIAL, NEXT extent size for the locally managed
temporary tablespace??



I am using 8MB+8KB extent size. Is it higher/lower? Need the suggestion
asap.



thanks in advance !!



regards,


vinay
Received on Thu Jan 18 2007 - 16:16:08 CST












Original text of this message













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