Space Manager with LiveReorg 9.1 - User Guide

Smart Start for Space Manager

Welcome to Space Manager

Space Manager with LiveReorg® is a comprehensive solution for achieving optimal capacity and performance in Oracle® databases. It provides the DBA with powerful functionality for making the most of storage resources. Space Manager can be used to collect statistics, visualize space use, detect and resolve space-use problems, identify the benefits of reorganizing tables and indexes, reorganize and resize objects for efficient space use, partition tables and indexes, plan for database growth, and document reorganization activities.

Use Space Manager to Detect and Resolve Space Usage Problems

Here are some of the ways Space Manager streamlines the strategic tasks involved in managing database storage:

Detect Problems

• The Explorer window allows you to quickly detect the space-use problems that impact database capacity and performance. Space-usage pie-charts provide a graphic display of space use in your databases and tablespaces, allowing you to visualize how space is allocated and how much is free.

  In the Explorer window, you can drill down to information on each tablespace. A tablespace view displays the tablespace segments and includes statistics on space usage, including segment counts and sizes. The Reorg Need column reveals which tablespace objects need to be reorganized.

• Predicted Reorganization Benefit reports calculate the amount of space you can reclaim by reorganizing specific tables or indexes.
• Reorganization History reports document your reorganization activities for a specific time period, which allows you to effectively plan for future reorganizations and extrapolate space savings based on data from past reorganizations.
• Reorganization Candidates reports help you identify objects with the highest reorg need.
• Size and Growth reports provide information to help you plan future capacity.

Resolve Problems

• Reorg Manager automates the reorganization and repair processes that resolve space-use problems.
• The Partitioning Wizard lets you easily visualize and specify partitioning schemes that provide better performance and easier maintenance.
• All reorganization, repair, and partitioning modules are designed to deliver maximum benefit with minimum impact. Online reorganization methods allow you to reorganize with little or no downtime. During a live reorganization, applications can remain online and users can continue activity against tables as they are reorganized. Because partitioning scripts use the live reorganization method, they allow you to perform critical database maintenance without interrupting access to data.

Friday, November 12, 2021

Additional Resources

You can find additional documentation for Space Manager with LiveReorg at the Quest Software Support Portal.

• Technical Documentation at Quest Support—Find Release Notes and Installation Guides for current and previous releases of Space Manager.
• Space Manager at Quest Support—Find software downloads, life cycle information, knowledge base articles, and technical documentation for Space Manager.

Smart Start for Space Manager

This Smart Start outlines the workflow involved in using Space Manager to manage database space. It identifies key features and displays the order in which these features are typically used.

1. Run the Find Long LONGs procedure in order to populate the Find Long LONGs table.

   Reorg Manager checks this table for the size of LONG and LONG RAW columns. The size of these columns determines which data movement methods can be used to reorganize their tables. See Use the Find Long LONGs Package for more information.

2. Run the Repository Update job.

   Make sure the Repository Update job runs at least one time before running a reorganization or attempting to identify objects in need of reorganization. This job updates the reorg need and wasted space information in the Space Manager Repository. See About the Space Manager Repository for more information.

3. Check space usage in a database and detect space-use problems using Space Manager storage monitoring tools.

   • Explorer—The Explorer displays when you open Space Manager allowing you to view space usage and space issues for a database. In addition, you can view storage information for a tablespace, datafile, object, or segment. See Monitor Storage from the Explorer for more information.

     Right-click a tablespace and select Tablespace Properties to monitor and manage tablespace storage properties.

   • Datafile Maps—Datafile maps help you visualize space use in a datafile. Each datafile map includes a list of the segments with blocking extents. See Monitor Datafile Storage.
   • Predicted Reorganization Benefit report—The Predicted Reorganization Benefit report shows you the amount of space you can reclaim if you reorganize a selected table or index. See Generate Reorganization Reports for more information.
   • Reorganization Candidates Reports—These reports produce a list of tables or indexes with the highest reorg need. See Generate Reorganization Candidates Report.
4. Identify reorg need. Use the Explorer and Reports to identify reorg need. See Identify Objects That Need to Be Reorganized.

5. Manage space in a database and resolve space-use problems with properties dialogs and reorganization wizards. You can redefine extent allocation and resize objects for more efficient space use. You can also relocate or partition objects.

   • Reorg Manager—Use Reorg Manager to resolve space-use problems for objects from anywhere in a database. Reorg Manager provides two reorganization methods: standard and live (available when the LiveReorg option is licensed). During reorganizations with both methods, you can relocate objects to different tablespaces.

     For help determining which reorganization method to use, see Select a Reorganization Method for Reorg Manager.

     Note: The Live option is only available when the LiveReorg option is licensed.

   • Partitioning Wizard—Use the Partitioning Wizard to partition, repartition, or unpartition objects and resolve space-use problems during a live reorganization. See About the Partitioning Wizard for more information.

     Note: The Partitioning Wizard is only available when the LiveReorg option is licensed.

   • Object Properties—Use Object Properties to view storage values for an object. See Manage Storage with Object Properties for more information.
   • Tablespace Properties—Use Tablespace Properties to create tablespaces, add datafiles to existing tablespaces, and size new and existing datafiles. You can also work from here to alter certain properties for existing tablespaces and datafiles. See Open Tablespace Properties for more information.
   • Move to Tablespace—Use the Move to Tablespace dialog to relocate an object to another tablespace without launching the Reorg Manager. See Move Objects to Tablespace for more information.
   • Reclaim Space—Use the Reclaim Space dialog to reclaim space in an object without launching the Reorg Manager Wizard. This method performs a live reorganization using the default settings. See Reclaim Space for more information.

6. Monitor and manage script execution.

   Use the Script/Job Monitor to check the status of all scripts that are stored in the Space Manager repository.

   Stored scripts are run from the server on a scheduled basis by the QSA Server Agent. They can include reorganization and partitioning scripts.

   You can also use the Script/Job Monitor to manage stored scripts and the QSA Server Agent. Script functions allow you to do the following:

   • Run, cancel, restart, open, and remove scripts. See About Running and Scheduling Scripts and Manage Scheduled Scripts.
   • Schedule and unschedule scripts. See Schedule Scripts.
   • Retrieve script execution logs. See Manage Scheduled Scripts.
   • Approve the switch for a live reorganization. See Approve the Switch .

   QSA Server Agent functions allow you to start or stop the agent and check its status. See Manage and Monitor QSA.

Related Topics

Connect to Databases

Oracle License Compliance

Reorganization Method Selection Chart