How are extents allocated 2 a segment?
Oracle8 and above rounds off extents 2 a multiple off 5 blocks when more than 5 blocks are requested. If one requests 16K or 2 blocks (assuming a 8K block size), Oracle doesn’t round it up 2 5 blocks, but it allocates 2 blocks or 16K as requested. If one asks for 8 blocks, Oracle will round it up 2 10 blocks. Space allocation also depends upon D size off contiguous free space available. If one asks for 8 blocks and Oracle finds a contiguous free space that is exactly 8 blocks, it would give it you. If it is 9 blocks, Oracle would also give it 2 you. Clearly Oracle doesn’t always round extents 2 a multiple off 5 blocks. D exception 2 this rule is locally managed tablespaces. If a tablespace is created with local extent management and D extent size is 64K, D n Oracle allocates 64K or 8 blocks assuming 8K block size. Oracle doesn’t round it up 2 D multiple off 5 when a tablespace is locally managed.
