Making Segment Management Work for You
Oracle Database manages segment space in two ways—automatic and manual, in a locally managed tablespace. Automatic segment-space management (ASSM), which is the default for all new permanent locally managed tablespaces, is much more efficient than manual segment-space management. The DBA can enable automatic segment-space management in a database using the SEGMENT SPACE MANAGEMENT AUTO clause, and can disable it with the SEGMENT SPACE MANAGEMENT MANUAL clause. The initialization parameter COMPATIBLE should be set to >=10.0 for ASSM to work. For Oracle Database 10g Release 1, you will have to enable ASSM; for Release 2, it is automatically enabled by default.
Using automatic segment-space management for ...
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.
