Features and Benefits

Space Manager with LiveReorg

Space Reclamation and Reorganization

• Eliminates unnecessary disk space purchases by reclaiming wasted space via reorganizations—especially when archiving Oracle data

• Identifies tables and indexes to reorganize to reclaim the most space and tracks reorganization activity for historical analysis and planning

• Partitions database objects with no downtime through use of built-in partitioning wizard

• Offers multiple reorganization methods, including live and offline reorgs, online redefinition, program-planned tablespace reorgs, a choice of partition reorg methods, and a choice of SQL statements

• Supports multiple objects and datatypes for live and standard reorgs, including domain indexes, individual partitions, tables with both LONG and LOB datatypes and user-defined datatypes 

• Relocates when you reorganize, allowing you to restructure your database for better I/O performance and ease of administration

• Displays progress of live reorganizations in the Live Reorg detail window allowing you to estimate when the switch will be made

• Provides restart and clean-up capabilities for failed reorganization scripts, allowing you to automatically resume script execution from the point of failure or clean up residual objects

• Designed with applications in mind, including SAP, Oracle E-Business Suite, PeopleSoft, Siebel, Cerner Millennium, and 24x7 e-commerce applications

Capacity Monitoring

• Provides multiple charts to quickly visualize current space use and future growth in databases that share storage resources

• Forecast space needs based on trend charts of historical or hypothetical growth rates

• Alerts of emerging issues such as tablespaces that are low on free space as well as space reclamation opportunities