Chat now with support

Get Live Help
Complete Registration

Sign In

Request Pricing

Contact Sales

Space Manager with LiveReorg 9.0 - User Guide

Table of Contents

Smart Start for Space Manager

Welcome to Space Manager Additional Resources Smart Start for Space Manager Connect to Databases Reorganization Method Selection Chart Oracle License Compliance Space Manager License Key User Requirements Usage Feedback

Collect Statistics

Collect Statistics About the Repository What Is Supported for Statistics Collection

Profile DML Activity

Smart Start for DML Profiler Generate DML Profile Reports

Monitor Storage from the Explorer

Monitor Storage from the Explorer Monitor Database Storage Monitor Tablespace and Object Storage Use Advanced Search Monitor Datafile and Extent Storage View Recycle Bin and Free Space

View Reorg Need

View Reorg Need from the Explorer How Reorg Need Ratio Is Calculated Reorg Need Factors Reorg Need and Statistics Collection Methods Reorg Need Ratio After Reorganization

Manage Storage with Object Properties

Manage Storage with Object Properties What Is Supported for Object Properties Open Object Properties View Object Properties View Partition Information View Size and Statistics View Extents View Column Definitions View Constraints View Dependencies View Triggers View DDL

Manage Storage with Tablespace Properties

Open Tablespace Properties Create Tablespaces Alter Tablespaces Tablespace Properties Descriptions

Resize a Datafile

Reorganize Objects with Reorg Manager

About Reorganization Wizards Identify Objects That Need to Be Reorganized Move Objects to Tablespace Reclaim Space Resize Datafile About Standard Reorg with Reorg Manager

About Standard Reorganizations What Is Not Supported for Standard Reorganizations

About Live Reorg with Reorg Manager

About Live Reorganizations What Is Not Supported for Live Reorganizations Concepts and Terms Best Practices for Live Reorganizations About Switch Modes Change Approval Method Approve the Switch

Getting Started with Reorg Manager

Select a Reorganization Method Smart Start for Standard Reorganizations Smart Start for Live Reorganizations Launch Reorg Manager

Specify Options - Reorg Manager and Partitioning Wizard

Select Global Reorg Options Select Scripting Options Customize Object Allocations Choose a Scheduling Method (LiveReorg) Schedule Script Execution Schedule Script Generation (LiveReorg) Save Reorg Manager Settings Run Scripts from the Editor

More Options for Reorg Manager

About Selecting Target Tablespaces Target Tablespace Considerations About Data Movement Methods More About Scripting Options (LiveReorg) Select a Partition Reorganization Method Set Storage Strategies About Statistics Collection Options Review Space Usage Respond to Checks for a Posting Index

Partition Tables with the Partitioning Wizard

About the Partitioning Wizard Smart Start for the Partitioning Wizard Launch Partitioning Wizard How the Wizard Streamlines Partitioning What Is Not Supported for the Partitioning Wizard Key Concepts for the Partitioning Wizard View Partitioning Schemes Specify Partitioning Method Specify Partitioning Key Columns Specify Partitioning Parameters Specify Partitioning Key Values

Specify Partitioning Key Values Best Practices for Partitioning Key Values Key Value Grids for Range-Partitioned Objects Key Value Lists for List Partitioned Objects Respond to Checks for a Posting Index

Specify Partition Names Select Scripting Options Customize Object Allocations Schedule Script Execution Save Settings As Default Run Scripts from the Editor More Options for Partitioning Wizard

About Statistics Collection Options Review Space Usage

Run and Monitor Scripts

Run and Schedule Scripts

About Running and Scheduling Scripts Schedule Scripts Schedule Script Execution in Wizards Run Scripts from the Editor Schedule Recurring Scripts to Run Manage Scheduled Scripts

Restart Scheduled Scripts

Restart Scheduled Scripts Restart for Live and Partitioning Scripts Restart for Standard Scripts Restart Commands

Monitor Scripts

How to Monitor Scripts Job Monitor Job Monitor Display Options Use Script Properties to Monitor Execution Monitor Live Reorganizations Change Approval Method Approve the Switch Enable SMTP Email Notification Enable SNMP Traps Notification Configure Additional Notification Events Use LiveReorg Shell Manage and Monitor QSA Monitor Statistics Collection Scripts

Manage Windows Scheduled Tasks

Report Basics Generate Reorganization Reports Generate Reorganize Candidates Reports Generate DML Profile Reports Generate Largest Segments Report Generate Fastest Growing Segments Report Generate Tablespace Growth Report Preview and Export Reports Manage Scheduled Report Generation

ReorgNeed Optons Repository Schedule Options Explorer Object Lists Reorg Manager Options Partitioning Wizard

Defaults Partitioning Keys Estimates

Server Agent Options Miscellaneous Options

Troubleshooting

Troubleshoot Script Execution Errors Status Codes for Script Execution Error Messages

Administration Functions

License Key Install Server Objects Reinstall Server Objects Uninstall Server Objects About QSA Server Agent Start/Stop Server Agent Specify Server Agent Parameters Server Agent Parameters Server Agent Locks Reporting Parameters Server Agent Locking Strategies Install Server Agent on UNIX or Linux Install Server Agent on Windows Uninstall Server Agent Oracle Upgrade Change Repository Update Schedule Install/Uninstall Demonstration Data Install Analysis Packages Manage and Monitor QSA

Use the Find Long LONGs Package

Use the Find Long LONGs Package Populate the Find Long LONGs table Query the Find Long LONGs table

Defragment Tablespaces and Coalesce Free Space

Defragment Tablespaces Defragment with an Interim Tablespace Empty a Tablespace Before You Defragment

How Live Reorganizations Work

How Live Reorganizations Work Stages of a Live Reorganization Estimate the Time Needed for a Live Reorganization Posting Indexes

Posting Indexes How Space Manager Chooses a Posting Index Prompts to Validate Constraints All Columns Posting Method ROWID Posting Indexes Set the Posting Parameter

Collection Triggers and the Collection table The Posting Procedure and OCI Calls LiveReorg Objects and Their Tablespace

LiveReorg Objects and Their Tablespace A Look at LiveReorg Objects A Look at the LiveReorg Tablespace Space for LiveReorg Objects

LiveReorg Commands

Global Operations for Space Manager

How Space Manager Supports Global Operation How Space Manager Uses Locale Settings Requirements and Recommendations for Global Operation How Space Manager Reports Locale Settings Use the SQL Editor for a Certain Locale

About Us Third Party Contributions Copyright

View Partition Information

The Partitioning tab of Object Properties is displayed when a partitioned object, partition, or subpartition is selected in the object tree. The fields in this tab change according to which of these objects is selected.

View Size and Statistics

View the Size and Statistics tab in Object Properties to see storage statistics for a selected object. This tab is displayed for objects that are supported for statistics collection. It is not displayed for objects such as LOBs.

Along with the Reorg Need value, the Size and Statistics tab can help you determine whether the object would benefit from being reorganized.

The Source for Statistics

The Statistics tab displays statistics from the Space Manager Repository.

Tablespace Statistics

Block Size—This field displays the data block size for an object’s database or tablespace (in databases that allow block sizes to vary by tablespace).

Allocated Space

Segment Size—This field displays total space allocated for an object.

Space Manager Statistics

Actually Used—This field displays the amount of space used by an object that currently contains data.

Data Dictionary Statistics

Row Count—This field displays the number of rows in a table.
Chained Rows Count—This field displays the number of chained rows in a table.
Average Row Length—This field displays the average length of rows in a table. The length value includes row overhead.

View Extents

View the Extents tab in Object Properties to see a list of the extents allocated to an object.

Extent Statistics

File Name—File name of the datafile for an extent.
Status—Whether a datafile is available or not.
Autoextensible—Whether a datafile is autoextensible.
Extent ID—Sequence number reflecting the order in which an extent was allocated.
Block ID—Starting block number of an extent.
Blocks—Number of data blocks.
Extent Size—Size in kilobytes.
Number of Extents—This field displays the total number of extents used by an object.
Average Size—This field displays the average size of the extents used by an object.
Minimum Size—This field displays the size of the smallest extent used by an object.
Maximum Size—This field displays the size of the largest extent used by an object.

The maximum number of extents listed is 500.

View Column Definitions

View the Columns tab in Object Properties to see column definitions for a table, index, cluster, clustered table, or IOT. A yellow key symbol identifies columns that are included in a table's PRIMARY KEY.

The Columns tab is not displayed for partitions and subpartitions.

Note: If a table contains a user-defined datatype or XMLType datatype, the Columns tab displays all hidden columns associated with that datatype.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating

© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center