Table of ContentsPPT Slide Objectives PPT Slide Types of Segments Types of Segments Types of Segments Storage Clause Precedence Extent Allocation and Deallocation Used and Free Extents Coalescing Free Space Database Block: Review Database Block Contents Block Space Utilization Parameters Block Space Usage Data Dictionary Views Querying Segment Information Getting Used Extent Information Checking Free Extent Information Organizing Tablespaces Based on Fragmentation Propensity Summary |
Author: Oracle Email: melody@ecst.csuchico.edu Home Page: http://www.ecst.csuchico.edu/~melody |