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

Home -> Community -> Mailing Lists -> Oracle-L -> Num. of blocks multiple of 5?

Num. of blocks multiple of 5?

From: Vladimir Barac - posao <vbarac_at_mobtel.co.yu>
Date: Fri, 21 Dec 2001 04:33:52 -0800
Message-ID: <F001.003E1A03.20011221035518@fatcity.com> 






Hi all!I have created tablespace where initial and 
next extents are same = 128KB.Block size is 4K.After creating test 
table and querying DBA_SEGMENTS, I see that new tableoccupies 35 blocks, 
instead of 32 blocks.Same happened with tablespace where initial = next 
= 256 and test tableoccupied 65 instead of 64 blocks.Why is this 
happening?Regards
Received on Fri Dec 21 2001 - 06:33:52 CST












Original text of this message













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