RE: Num. of blocks multiple of 5?

[Adams, Matthew (GEA, 088130)]

This has been the documented behavior for non-LMT for quite a while.  From the storage clause section of the SQL Reference Manual   "Oracle rounds values up to the next multiple of the data block size for values less than 5 data blocks, and rounds up to the next multiple of 5 data blocks for values greater than 5 data blocks."   ---- Matt Adams - GE Appliances - [EMAIL PROTECTED] The thrill is gone -  B. B. King If the thrill is gone, then it's time to take it back. -  Meatloaf   -----Original Message----- From: Vladimir Barac - posao [mailto:[EMAIL PROTECTED]] Sent: Friday, December 21, 2001 6:55 AM To: Multiple recipients of list ORACLE-L Subject: Num. of blocks multiple of 5? 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 table occupies 35 blocks, instead of 32 blocks. Same happened with tablespace where initial = next = 256 and test table occupied 65 instead of 64 blocks. Why is this happening? Regards