Space Manager with LiveReorg (SAP)
(module of Quest Central for Oracle suite)

If you are not reorganizing your SAP R/3 database once or twice a year, your system is not performing as well as it could be. A bold statement, but it’s true, even for medium-sized SAP installations.

After a SAP Archiving an Oracle Database reorganization is required.

Poor performance and response time:

As database size increases, the performance of mission-critical applications deteriorates. The larger the database, the more time it takes to load, unload, search, reorganize, index and optimize. Response time slows. Service levels decline.

Increasing TCO for maintaining the service level agreement

IT organizations often spend millions of dollars in hardware and software license fees per year just to keep the service level. Still, this short-term tactical approach does not address the root cause of the problem - excessive data volume.

Slow Disaster Recovery

With oversized databases, both active and inactive data must be restored, just to get business data back online. Restoring large volumes of rarely accessed data, in addition to the operational data, can slow the recovery process by hours or even days.

Complying with Data Retention Regulations

Data laws require companies to retain data longer and make them available upon request. The cost of retaining large volumes of historical data online in production databases can be prohibitive; yet, the penalties for noncompliance are severe.

Space Manager with LiveReorg (SAP) allows you to optimize performance of SAP by reorganizing and restructuring your SAP Oracle database with minimal downtime. As a result you can maximize the SAP hardware and disk resources that you already have, saving disk space and its associated costs.

With Space Manager with LiveReorg , Quest’s patent-pending technology, e-businesses and ERP systems like SAP are freed from the downtime imposed by traditional reorganization methods. Space Manager with LiveReorg online capabilities reorganize 24x7 SAP databases "live" while users remain online.

Large, heavily used SAP tables and their associated indexes can be reorganized with minimal downtime. During the SAP LiveReorg reorganization process, the table data remains fully accessible to application users for both read and write access.

Key Benefits

Improves SAP database performance without causing costly outages
Maximizes the SAP hardware and SAP disk resources that you already have, saving disk space and its associated costs
Enables you to predict SAP space constraints and plan proactively
Completely eliminates downtime for most SAP tables

Key Features

Space Manager with LiveReorg (SAP) , reorganizes and restructures even very large SAP Oracle database objects while the application and users are still up and running
Reorganize individual partitions or the entire partitioned table while the application and users are up and running
Leverages Quest's proven, log-based SharePlex® replication technology
Enables live reorganizations at the partition level
Provides comprehensive SAP space management , including fault prediction, object sizing and capacity planning
Offers fast, flexible data movement to support both live and traditional reorganization processes
If a reorganization failure is encountered, you can resume at the point of failure saving valuable time and resources
Designed for for SAP and 24x7 e-commerce applications
Automates the use of Oracle’s online redefinition package

Quest Central for Oracle integrates Quest Software’s industry-leading Oracle tools that have been successfully used for years. Check out the other components: Spotlight performance diagnostics, Database Administration, Database Analysis, 24x7 Monitoring, SQL Tuning and Performance Analysis.