Space Manager with LiveReorg 9.2 - User Guide

Generate Tablespace Growth Report

Size and Growth reports provide information to help you plan future capacity. The Tablespace Growth report predicts growth trends for individual tablespaces.

Use a Tablespace Growth report to predict the growth rate and future size of all tablespaces in a database. The report provides you with current tablespace size, projected growth rate, and projected tablespace size per quarter for each selected tablespace over the next twelve months.

To generate a Tablespace Growth report

1. Select Reports | Size and Growth Reports | Tablespace Growth.

   Note: Alternatively, you can click and select Tablespace Growth.

2. Select the Exclude Oracle internal tablespaces checkbox in order to exclude the internal tablespaces from your report.
3. Click Generate to generate the report.

Note: After the report displays, click a column header to sort rows by that column.

Other Size and Growth reports

• Generate Largest Segments Report
• Generate Fastest Growing Segments Report

Export a report

You can export a report to one of a number of different file formats, such as PDF or Excel. See Preview and Export Reports for more information.

Related Topics

Preview and Export Reports

Preview and Export Reports

You can export a report to one of a number of different file formats, such as PDF and Excel. You can customize the report layout prior to exporting. You can also customize and then print a report without saving it as a file.

To preview and export a report

1. After generating a report, click in the report window to open the Print Preview window.

   Note: In the DML Profile report, click Print Preview.

2. From the Print Preview window, you can customize the report layout, print the report, or export the report as a file. Select from the following toolbar buttons.

   		Click to modify report layout (margins, paper size, orientation) before printing or exporting the report.
   		Click to specify advanced data display options. Note: This option is only available with Predicted Reorganization Benefit, Reorganization History, and DML Profile reports.
   		Click to configure report header and footer options. Note: This option is only available with Predicted Reorganization Benefit, Reorganization History, and DML Profile reports.
   		Click to export the report. Click the drop-down arrow to select a file format. Formats include PDF and Excel.
   		Click to print the on-screen report without saving it to a file.
   		Click to toggle print layout view on and off. Note: This option is not available with Predicted Reorganization Benefit, Reorganization History, and DML Profile reports.
   		Click to add a watermark to the report. Note: This option is only available with Predicted Reorganization Benefit, Reorganization History, and DML Profile reports.
   		Click to change the report background color. Note: This option is only available with Predicted Reorganization Benefit, Reorganization History, and DML Profile reports.

Manage Scheduled Report Generation

A scheduled task is created when you schedule a Space Manager activity such as report generation or script generation. When you schedule one of these activities, a Windows scheduled task is created. You can view and manage these tasks using Space Manager.

Scheduled tasks that are managed using the Scheduled Tasks window include:

• Scheduled script generation for Live Reorg scripts. See About Scheduling a Recurring Reorganization for more information.
• Scheduled report generation, such as Predicted Benefit Reorg reports.

When a scheduled task is executing, Space Manager runs in the background.

To manage scheduled tasks

1. Select Manage | Scheduled Tasks. The Space Manager Scheduled Tasks window opens.

2. Review the list of scheduled tasks. The grid displays the status of each task and the next scheduled run time.

3. Select a task and click one of the following toolbar buttons to perform the action. Or right-click a task and select from the menu.

   	Click to modify the selected task's schedule.
   	Click to enable selected task.
   	Click to disable selected task.
   	Click to run selected task.
   	Click to run selected task interactively.
   	Click to delete selected task.
   	Click to refresh.

Note: You can also manage tasks and view task properties using the Windows Task Scheduler.

Options