Category Archives: oracle

Oracle Notes

Posted on February 13, 2009 by Jianming Li

Data Blocks, Extents, Segments §Data Blocks •Overhead Header: block addr, seg type Table dir: tables having rows Row dir: actual rows info •Free space •Row data §PCTFREE, PCTUSED, Row Chaining •PCTFREE: pct of block spc reseved for updates •PCTUSED: before … Continue reading →

Posted in oracle | Leave a comment