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

About Standard Reorg with Reorg Manager

About Standard Reorganizations

Standard reorganization is an offline reorganization method. This means that the objects being reorganized are not available and should not be accessed during a standard reorganization. DML or DDL activity should not be performed against these objects by users or applications. If either type of activity is performed, data loss can occur.

Note Standard reorganizations for objects from anywhere in a database can be performed with Reorg Manager.

Advantages of Standard Reorganization

One of the main advantages of standard reorganization with Reorg Manager is that it supports more object types, datatypes, and options than any other method.

What Is Not Supported for Standard Reorganizations

This topic lists which Oracle features are not supported for standard reorganizations. Use the information in this topic when selecting which reorganization method to use and which objects to include in a reorganization.

Category	Oracle Feature Not Supported
Tables and Indexes	Temporary tables
	Tables with dimensions
	Advanced Queuing tables
	Replication tables; objects that are part of a replication group
	External tables
	Domain indexes (including interMedia and ConText indexes)
IOTs and Clusters	Bitmap indexes on IOTs
	Clusters that contain tables with LONG columns
User Defined Data Types	Object tables (data types for tables)
	Nested tables
Various Data Types	XMLType tables
Miscellaneous	Oracle Label Security

About Live Reorg with Reorg Manager

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating

© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center