Release Notes
Wednesday, April 25, 2018
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.
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.
The following is a list of issues addressed and enhancements implemented in this release of Space Manager.
Feature | Enhancement / Resolved Issue | Defect ID |
---|---|---|
Advanced Search | Enhancement: The Advanced Search window now includes an "Add to Results" button in addition to the menu item. | SPC-410 |
General | This release includes support for maximum object name length of 128 bytes in Oracle 12c Release 2. | SPC-308 |
General | This release includes support for Windows 10. | SPC-379 |
Reorg Manager | (Oracle 12c) You can now specify the DataPump method for objects individually. | SPC-323 |
Reorg Manager | (Oracle 12c) Corrected an issue that in some cases prevented a successful cleanup if a script was cancelled or failed during the datapump procedure. | SPC-393 |
Reorg Manager | Corrected an issue that caused a "Value was either too large or too small for an Int32" error when running a reorganization on objects that include large integer values. | SPC-381 |
Reorg Manager | Corrected an issue that prevented the Index partition attributes from being scripted correctly when creating a partition-level reorg script for a partitioned table with a local index. | SPC-431 |
Feature | Enhancement / Resolved Issue | Defect ID |
---|---|---|
LiveReorg | Corrected an issue that caused an ORA-04067 error during a LiveReorg of a table containing a LOB data type column when other processes attempted to access the table. | SPC-392 |
LiveReorg | Corrected an issue that caused an ORA-04067 error during LiveReorg Cleanup of a table containing a LOB data type column when other processes attempted to access the table. This issue is related to SPC-392. | SPC-398 |
LiveReorg | The DataPump data movement method (available for Oracle 12c) can now use the overflow directory/directories specified in the OVERFLOW_DIR_nn parameter/parameters. | SPC-363 |
LiveReorg | When connected to Oracle 12c, the Reorg Manager now allows you to specify the following options for the DataPump data movement method: a maximum file size and the number of parallel processes to use. See New Feature in this release for more information. | SPC-321 |
Object Properties | (Oracle 12c) Corrected an issue that caused an "Unable to cast object of type" error when attempting to view Object Properties of a table. This issue occurred when connected to an Oracle 12c database. | SPC-388 |
Feature | Enhancement / Resolved Issue | Defect ID |
---|---|---|
Reorg Manager | Improved performance when the analysis option "Restore original statistics in data dictionary for the CBO" is selected on the Scripting Options page of the Reorg Manager. | SPC-241 |
Scripts/Job Monitor | When deleting a script group, if the Detail pane is open, the list of scripts no longer persists in the Details pane after the group is deleted. | SPC-122 |
SQL Editor | Corrected an issue that caused an "access violation" error when attempting to edit a very large script or enter characters very quickly. | SPC-243 |
SQL Editor | Corrected an issue that caused Space Manager to become unresponsive when attempting to run a SELECT statement containing duplicate column names. | SPC-244 |
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center