Space
- Storage
Use this page to review and manage the storage space for a database server. - Information
Use this page to review the storage space usage for a database server. - Spaces
Use this page to review information about the storage spaces in a database server and to expand, create, modify, or drop a space. - Create a Space
Use this page to create a storage space for a database server. - Expand a Space
Use this page to expand a space immediately or to add a chunk to a space. - Modify the Space
Use this page to specify whether the database server can expand the size of the storage space when necessary. Set the minimum size that the server can use to expand the space. - Storage Pool
Use this page to configure the database server to add storage space automatically when more space is needed. Add entries to the storage pool that the server can use to expand a space and set the threshold for expanding a space. - Add a Storage Pool Entry
Use this page to define the directories, files, and devices that the database server can use to expand a space. - Modify a Storage Pool Entry
Use this page to modify the definition of the directories, files, and devices that the database server can use to expand a space. - Chunks
Use this page to review information about chunks and to extend, add, modify, or drop a chunk. - Add a Chunk
Use this page to add a chunk to a storage space. - Modify a Chunk
Use this page to specify whether the database server can automatically extend the chunk when necessary. - Extend a Chunk
Use this page to extend a chunk immediately. - Tables and Indexes
Use this page to review information about the tables, indexes, and fragments in a storage space. - Optimize Space
Use this page to optimize storage space. Compress tables, indexes, and fragments, consolidate free space (repack), return free space to the dbspace (shrink), merge extents (defragment), or remove in-place alter operations. You can also uncompress tables and table fragments. - Server Optimization Policies
Use this page to configure the database server to automatically compress, repack, shrink, and defragment tables and fragments, and to remove in-place alter operations from tables. - Task Status
Use this page to monitor the status of the tasks that optimize storage space, including the status of these tasks: compress, uncompress, repack, shrink, defragment, and estimate compression savings. - Information
Use this page to review the page usage and other information for a specific space on a database server.