Thursday, December 14, 2017
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.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 does not support Oracle database releases later than 220.127.116.11.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.
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
The following is a list of issues addressed in Space Manager 8.4.1
|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|
The following is a list of issues addressed in Space Manager 8.3
|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|
The following is a list of issues known to exist at the time of this release.
|Feature||Known Issue and Workaround (if applicable)||Defect ID|
Some wizard screens do not display correctly on Windows 7 if your text size setting is greater than 100%.
Set text size to 100%.
|Oracle 12c Support||
Space Manager does not support Oracle database releases later than 18.104.22.168.0.
|Oracle 9i Support||
Tablespaces using Oracle-managed files. When you add datafiles to tablespaces with Oracle-managed files, be aware that Tablespace Properties will automatically put ORA_ at the beginning of each new file name. However, tablespaces using Oracle-managed files can only have one datafile named ORA_%. If you leave ORA_ in place for a new file, the following error will occur when you run the script to add it.
“ORA-01276. Cannot add a file with an Oracle Managed Files file name.”
To avoid the error, remove ORA_ from the beginning of a new file name before you run the script.
Reorganizing tables with Domain indexes. Space Manager provides limited support for Domain indexes when performing reorganizations and warns that you might encounter a problem because of the Domain index. Space Manager scripts the reorganization of the domain index correctly. However, the underlying implementation of the index type may be very complex, and some unforeseen dependencies may cause runtime errors.
Important: It is recommended that you test the reorganization of a table with a Domain index on a non-production version of the table to make sure Space Manager reorganizes both the table and index correctly before you reorganize your production table.
|General||When running the Space Manager client (64-bit) in a 64-bit environment, some users might encounter the following error when attempting to submit a standard or live reorg script: “Error creating script group: Could not load file or assembly ManagedQP5.dll or one of its dependencies. is not a valid Win32 application.”||SPC-409|