Release Notes
Monday, September 23, 2024
Space Manager with LiveReorg® is Quest Software’s solution for optimizing space use and performance in Oracle® databases. It provides DBAs with a comprehensive set of tools for making the most of storage resources. These tools allow you to collect statistics, visualize space use, detect space-use problems, reorganize and resize objects to reclaim wasted space, create tablespaces,
As you manage capacity with Space Manager, you can monitor it with Capacity Manager for Oracle. Capacity Manager is Quest Software's solution for tracking and planning capacity across multiple Oracle databases. Designed to report on collective space use in databases, Capacity Manager lets you evaluate current allocation, forecast future growth, and identify emerging issues. To resolve these issues, you can run Space Manager from Capacity Manager. Launch points are provided throughout the Capacity Manager interface.
Together, Space Manager and Capacity Manager provide the information and control you need to efficiently maintain and plan your database resources. Capacity Manager uses the Space Manager license and can be installed when you install Space Manager.
Note: Capacity Manager is not available in a 64-bit version at this time and is not included in the 64-bit installer.
Document Version | Date | Change History |
---|---|---|
2 | 12th September 2024 | Added support for the Windows Server 2022 operating system with the QSA Agent and Oracle 19c hosted on AIX 7.2, and AIX 7.3. |
Space Manager 9.1 includes the following new features and enhancements. This release of Space Manager is upgraded to install server agent on Windows 64 bit platform.
Supported Platform versions as below:
Database Server Operating System |
Windows Red Hat® Enterprise Linux 8.4 and 8.6 (64 bit) IBM® AIX 7.1 ,7.2 and 7.3 |
Oracle Database | 12c R2 and 19c |
Operating System |
Windows Server 2016 Datacenter Windows Server 2022 |
Space Manager 9.0 includes the following new features and enhancements.
This release of Space Manager is upgraded to support Oracle Database 19c.
Supported Platform versions as below:
Database Server Operating System |
Oracle Solaris 11 and 11.1 IBM® AIX 7.1 and 7.2 Red Hat® Linux Advanced Server 7.4 |
Oracle Database |
12c R2 19c |
Operating System | Windows 10 |
Note: License validation will happen in Space Manager, QSA independently will not authorize the license key.
Space Manager 8.6 is a minor release and includes resolved issues.
Space Manager 8.5 includes the following new features and enhancements.
Customize DataPump Options for Individual Objects (Oracle 12c)
In the Reorg Manager, you can now specify DataPump options for individual objects. This allows you to override the default (global) setting you specified on the first page of the Reorg Manager. Review the following details:
Support for Oracle 12c Release 2
This release of Space Manager includes support for Oracle Database 12c Release 2.
Note: When using Space Manager with Oracle 12c R2, additional requirements apply. Please see the System Requirements for more information.
Advanced Search Window
The Advanced Search window now conveniently includes an Add to Results button in addition to the menu item.
Support for Oracle Database 9 and 10 is Discontinued
Beginning with Space Manager 8.5, Oracle Database 9 and 10 are no longer supported.
Space Manager 8.4.1 includes the following new features.
Additional DataPump options (Oracle 12c)
When connected to Oracle 12c, the first page of the Reorg Manager allows you to specify the following options for the DataPump data movement method:
Use DataPump for all tables—Select this option to use DataPump for all tables that are supported for this method. Tables that are not supported are excluded from reorganization.
Caution: Care should be taken when selecting this method. DataPump is not always the most efficient data movement method and should be used only for large tables where table copy might cause Oracle errors.
DataPump uses OVERFLOW_DIR_nn directories (Oracle 12c)
The DataPump data movement method (available for Oracle 12c) now uses the overflow directory/directories specified in the OVERFLOW_DIR_nn parameter/parameters. See "QSA Server Agent Parameters" in the online Help or Space Manager User Guide for more information.
Support for Oracle Database 9 and 10 to be discontinued
Space Manager 8.4.1 has been tested with Oracle Database 9 and 10. However, support for Oracle 9 and 10 will be discontinued after the Space Manager 8.4.1 release.
Space Manager 8.3 includes the following new features.
New 64-bit version of Space Manager
Beginning with release 8.3, Space Manager is now available in a 64-bit version, as well as a 32-bit version.
Window tabs identify the associated connection
Instruct Space Manager to use FsCopy/DataPump
For special situations, you can now instruct Space Manager to use only FsCopy or only DataPump as the data movement method. If the database is Oracle 9, 10, or 11, the Reorg Manager allows you to specify FsCopy. If the database is Oracle 12, the Reorg Manager allows you to specify DataPump.
When to use the FsCopy/DataPump option
Selecting the Use FsCopy or Use DataPump option is recommended only for tables that would otherwise get a "snapshot too old" error during table copy. FsCopy and DataPump are not the most efficient data movement methods and should be selected only for large tables where table copy may cause a "snapshot too old" Oracle error.
Important: Because FsCopy and DataPump use the file system to store a copy of the table, make sure that the file system is prepared and the QSA parameter WORKDIR is set correctly. If using FsCopy, make sure the QSA parameter OVERFLOW_DIR_## is also set correctly.
What is Space Manager FsCopy? FsCopy uses an import and export process to move data. It is one of the actions included in the Space Manager FastCopy data movement method.
How to use this feature:
This release of Space Manager now supports the following Oracle database 12c features.
Reorg scripts. New options supporting 12c features in Reorg scripts.
Note: Space Manager 8.3 does not support Oracle database releases later than 12.1.0.2.0.
Reorder databases in Explorer tree-list
Oracle 12c PDB. Oracle 12c pluggable (PDB) databases are now nested under the 12c container (CDB) database in the Explorer tree-list.
Advanced Search
This release includes a new Advanced Search feature in the Explorer. The advanced search allows you to use multiple search criteria to find objects or filter the list. This is useful when you want to find a diverse set of objects to include in one reorganization script group.
Display latest execution logs for a script group
Cancel and Clean Up command
Oracle Database 9 and 10. Beginning with Space Manager 8.5, Oracle Database 9 and Oracle Database 10 are no longer supported.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center