had a quick read
article states that oracle block size starts from 512 bytes, wrong it starts from 2K (minimum)
pctused definition is totally wrong, pctused is used for DELETEs not INSERTs, a block is removed from freelist when it reachs PCTFREE, re-enters to freelist when block usage falls BELOW PCTUSED




Reply With Quote