Chat now with support
Chat with Support

Space Manager with LiveReorg 9.0 - User Guide

Smart Start for Space Manager Collect Statistics Profile DML Activity Manage Storage Reorganize Objects with Reorg Manager Partition Tables with the Partitioning Wizard Run and Monitor Scripts Run Reports Options Troubleshooting Administration Functions Appendix About Us

Tablespace Properties Descriptions

This section describes options in Tablespace Properties. Descriptions are given in alphabetic order by option name.

Show all


Related Topics

Create Tablespaces

Tablespace Properties Descriptions

Resize a Datafile

Space Manager allows you to easily resize a datafile using the Datafile Resize wizard. You can launch the wizard from the Explorer after selecting a datafile to resize. Use this feature to resize a datafile prior to creating or running a reorganization script.

Note: Previous releases of Space Manager (8.0.2 or earlier) allowed you to add a "script-pause" option to a reorganization script and use the pause to resize a datafile. Beginning with Space Manager 8.1, the script-pause option is no longer available. This is because its main functionality is superseded by the Datafile Resize wizard. Datafile Resize uses LiveReorg, which is preferable to standard reorganization, the method used with the script-pause function.

To resize a datafile

  1. In the Databases tree-list in the Explorer, expand the tablespace node for the selected datafile.
  2. Select the Datafile node to display the list of datafiles in right pane, and then select a datafile.
  3. Right-click the datafile and select Resize Datafile. The Datafile Resize wizard opens.
  4. To increase size, select Increase datafile size and click Next.
    1. Specify a new size in the Resize to field and click Next.
    2. On the Execute SQL page, click SQL Execute to execute the SQL command to resize the datafile.
  5. To decrease size, select Decrease datafile size and click Next. The next page of the wizard displays the available options for resize method and resulting datafile size.

    • If you do not want to reorganize segments, select No Data Movement and then click Next. On the Execute SQL page, click SQL Execute to execute the SQL command to resize the datafile.
    • To use the recommended size and to reorganize segments, select Recommended and click Next. This option uses a live reorganization. The next page of the wizard displays the list of segments to be reorganized and several options. Review the following for additional information:

      In Same Tablespace Select to leave tables in their current tablespace.
      Move to New Tablespace

      Select to move tables to a different tablespace. Then select the new tablespace from the list.

      Note: All tables in the list are moved to new tablespace.

      Turn Off Autoextent for Datafile Select this option if you do not want this datafile to be autoextensible.
      Drop Datafile if Empty Select to drop the datafile if it is empty after a successful reorganization.

      After specifying reorganization options, click Next. Schedule the reorganization and resize script.

      Execute Immediately Select to schedule the script to run immediately
      Start Job At Select to schedule the job to run at a later date and time.

      Click Submit Job. The scheduled script displays in the Script/Job Monitor.


Related Topics

Reorganize Objects with Reorg Manager

About Reorganization Wizards

Reorganization is the main solution for space-use problems such as wasted space, fragmentation, chained rows, and table/index contention.

Space Manager provides two reorganization wizards that allow you to reorganize objects and tablespaces in a variety of ways.

Space Manager also provides two dialogs for performing simple reorganization tasks.

Reorg Manager

Reorg Manager can be used to reorganize and relocate objects from anywhere in a database.

The Reorg Manager provides two methods for reorganization—standard and live. The Standard method is offline; the live method is online.

  • Standard Reorg—Standard reorganization is an offline method. During a standard reorganization, tables are not available for DML activity. See About Standard Reorganizations for more information.
  • Live Reorg—Live reorganization is an online method. During a live reorganization, tables are available for DML activity by applications and users. When the online switch style is used, tables remain available throughout a live reorganization, including the switch from original table to reorganized copy table. Live reorganizations can be performed when the LiveReorg option is licensed. See About Live Reorganizations for more information.

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

To get started using the Reorg Manager, see Launch Reorg Manager.

Tip: You can save Reorg Manager settings as a Reorg Plan to edit and reuse later. See Save Reorg Manager Settings for more information. You can also use saved settings to automate reorganization script execution. See About Scheduling a Recurring Reorganization for more information.

Partitioning Wizard

The Partitioning Wizard can be used to partition, unpartition, and repartition tables and indexes during live reorganizations. This wizard provides a graphic interface that lets you easily visualize a partitioning scheme and specify partitioning options. The wizard also automates tasks such as setting partitioning key values, sizing partitions, and selecting tablespaces for I/O balancing. See About the Partitioning Wizard for more information.

To get started using the Partitioning Wizard, see Launch Partitioning Wizard.

Move to Tablespace Dialog

Use the Move to Tablespace dialog to move an object to another tablespace without opening the Reorg Manager Wizard. See Move Objects to Tablespace for more information.

Reclaim Space Dialog

Use the Reclaim Space dialog to reclaim space without launching the Reorg Manager Wizard. This method performs a live reorganization using the default settings. See Reclaim Space for more information.

Keys Options in Reorganization Wizards

Review the following key options available in reorganization wizards:

  • Target tablespace options—Use target tablespace options to reorganize objects in their current tablespace or relocate them for better I/O balancing. If you choose to leave objects in their current tablespace during a standard reorganization, you can reorganize them using free space in another tablespace on an interim basis.
  • Sort options—Use sort options to sort data and improve its proximity for faster query access. These options are available for standard and live reorganizations.
  • NOLOGGING option—Use Oracle’s NOLOGGING option  to speed up reorganization of indexes.
  • Parallel processing by Oracle—Use Oracle’s parallel processing to speed up reorganization of tables and indexes.
  • Parallel processing by QSA— Use parallel processing by the Quest Server Agent (QSA) to speed up reorganization of indexes and recompile of dependencies.
  • Scheduling options—Use scheduling options to schedule a reorganization script to run at times when database activity is light and the script will have the least impact.


Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating