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 -> Dictionary-managed tablespace

Dictionary-managed tablespace

From: EP <ep_at_plusnet.pl>
Date: Fri, 12 Jul 2002 22:35:41 +0200
Message-ID: <agnee4$bgc$1@news.tpi.pl> 





Hi



I'va got a question concerning dictionary managed tablespace - how are the
extent sizes determined ?


I normally use LMT so that issue hasn't troubled me so far.
According to documentation, what matters here is INITIAL, NEXT AND
PCTINCREASE.



However, when I create a table with the following parameters:
initial 32768 next 32768 pctincrease 50 I get odd extent sizes:
32768, 32768, 81920, 81920 (???),  122880, 204800 (???) 286720, 409600
etc...



TIA



EP
Received on Fri Jul 12 2002 - 15:35:41 CDT












Original text of this message













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