Space-Management Tips and Tricks
Oracle recommends using automatic segment-space management for permanent tablespaces. These tablespaces are locally managed tablespaces and are also known as bitmap tablespaces. Locally managed tablespace (LMT) uses bitmaps at the extent level and ASSM uses bitmap at the segment level.
When you create database objects (tables and indexes), specify automatic segment-space management in the creation script itself. This helps Oracle to provide better performance for the database.
If, after using Segment Advisor, you find that there is space available in the object for reclamation, you should compact and shrink the segments. You may also deallocate free space at the end of a database segment. Segment shrink is available ...
Get Oracle® Database 10g Insider Solutions now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
