摘要： each segment starts out with 140 Chapter 3  Database Storage and Schema Objects,64KB extents for the first 16 extents, and then extents increase in size to 1MB for the next 63extents. The size then increases to 8MB for the next 120 extents, then 64MB, and so on as the segment grows. *先分配16个64K的exte 阅读全文

摘要： 取决于存储的segment的大小。根据Bhaskar Himatsingka的HOW TO STOP DEFRAGMENTING AND START LIVING: THE DEFINITIVEWORD ON FRAGMENTATION一文，建议是1) Segments smaller than 160M should be placed in 160K extent tablespaces. ==》Uniform Size 160K2) Segments between 160M and 5120M should be placed in 5120K extent tablespaces. 阅读全文