O'Reilly logo

Oracle® Database 10g Insider Solutions by Richard Stroupe, John Kanagaraj, Arun Kumar R.

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required