|

Space Manager with LiveReorg

The next industrial revolution is here. Technology won’t rule the world but it will power it. See How ›

Simplified database capacity optimization.

Enables you to reorganize Oracle data, optimize I/O performance and maximize database capacity.


 

 

Space Manager with LiveReorg™ enables you to reorganize Oracle data, optimize I/O performance, and maximize database capacity. You can prevent application and database downtime by performing online Oracle reorganizations to reclaim space. The Oracle partitioning tool also allows you to resolve performance issues due to fragmentation when archiving Oracle data. You’ll find this especially useful for business-critical ERP applications, such as Oracle e-Business Suite, Siebel and SAP, where high-transaction volumes require you to routinely archive data.
Oracle reorganization and space reclamation
  • Reorganizes data to reclaim your wasted space and optimize your database capacity and performance on archived tables, eliminating the need to buy additional disk space.
  • Prevents your organization from experiencing application and database downtime by performing online reorganizations.
  • Determines indexes and tables to reorganize data. Enables you to perform proactive analysis and planning by reclaiming maximum space and tracking historical reorganization activity.
  • Supports multiple datatypes and objects for standard and live reorgs, including individual partitions, domain indexes, user-defined datatypes, and tables with both LOB datatypes and LONG columns.
  • Automatically resumes script execution from point of failure or clean up of residual objects by providing restart and clean-up capabilities for failed reorganization scripts.
Database capacity optimization
  • Using simple charts, easily view existing space usage and future growth in databases that use the same storage resources.
  • Estimate your organization’s future storage needs based on detailed trend charts showing historical growth rates, as well as hypothetical “what if” scenarios.
  • Quickly determine where to utilize space more efficiently with alerts on emerging issues, such as limited free space or space reclamation opportunities
Oracle partitioning
  • Use a built-in partitioning wizard to minimize downtime by partitioning objects live, while users and applications remain online.
  • Partition, repartition, and remove/add/modify partitions to identify best fit for data access to data.
  • Confirm that you have sufficient space available to ensure reorg success with multiple automatic space-check audits.
  • Requirements for the Client Computer


    The Space Manager and Capacity Manager clients must be installed on the same computer, and their requirements are the same unless otherwise specified. The computer must meet the following requirements:

    Oracle® Client
    Supported by both Space Manager and Capacity Manager:
    Oracle Net version 9.2, 10g, 11g, 12c (32-bit)
    Note: Space Manager and Capacity Manager do not support the 64-bit version of the Oracle Client.

    Operating System
    Supported by both Space Manager and Capacity Manager:
    Windows Vista®
    Windows® 7
    Windows Server® 2008
    Citrix® Metaframe XP
    Windows® 8
    Windows Server® 2012

    Processor
    1 GHz Processor (recommended minimum)

    Memory
    2 GB of RAM

    Display Settings
    A resolution of 1024 x 768; true color or high color; small fonts

    Disk Space
    Space Manager: Approximately 800 MB
    Capacity Manager: Approximately 13 MB

    .NET Framework
    Microsoft® .NET Framework 4 (including update 4.0.3)
    Note: The .NET Framework 4 Full Profile is required. The Client Profile is not sufficient.

    Requirements for Databases

    Each database being managed with Space Manager must meet the following requirements:

    Oracle Database
    Supported by both Capacity and Space Manager:
    Oracle 9.2
    Oracle 10.2
    Oracle 11g
    Oracle 11g R2
    Oracle 12c. Space Manager provides limited support for new Oracle 12c features. See Known Issues for more information.
    Note: Space Manager supports Oracle Enterprise Edition and Standard Edition databases.

    Database Server Operating System
    Space Manager supports the following operating systems:
    HP-UX 11 and 11i on PA_RISC
    HP-UX 11i on Itanium
    Sun Solaris 2.8, 2.9, 10, and 11
    IBM® AIX 5.1, 5.2, 5.3, 6.1, and 7.1
    Red Hat® Linux Advanced Server 3.0, 4.0, and 5.1
    Oracle® Linux® 4, 5, and 6
    Oracle Linux 5 with Unbreakable Enterprise Kernel
    SuSE Linux Enterprise Server 9, 10, and 11 SP2
    Windows Server 2008
    Windows Server 2012
    Note: When using Oracle 11.1 or earlier on 64-bit systems, the installing user must be configured to use the Oracle 32-bit client libraries. For Oracle 11.2 or later on 64-bit systems, the installing user can use the Oracle 64-bit client libraries.

    Disk Space
    Disk-space requirements are:
    80 MB for statistics tables
    20 MB for scripts tables
    20 MB contiguous free space for LiveReorg objects in the LiveReorg tablespace (set with QSA’s LW_TABLESPACE parameter)
    40 MB in the filesystem for QSA executables and logs

    Oracle Packages
    Space Manager:
    DBMS_SQL, DBMS_PIPE, DBMS_LOCK, DBMS_SPACE_ADMIN
    QSA: DBMS_SQL, DBMS_PIPE, DBMS_OUTPUT, DBMS_APPLICATION_INFO
    Find Long LONGs feature: UTL_RAW
    Email notifications: UTL_SMTP

    Oracle's Partitioning Option
    Required for the Online Switch (a feature available for live reorganizations) and the Partitioning Wizard; Partitioning Option must be installed and licensed.

    XDB Schema
    Required for XMLType datatypes.

    Requirements for the Capacity Manager Repository


    The database used for the Capacity Manager repository must meet the following requirements:

    Oracle Database 
    Supported for the repository:
    Oracle 9.2
    Oracle 10.2
    Oracle 11g
    Oracle 11g R2

    Disk Space
    8 MB recommended per monitored database assigned to a repository (accommodates one year of growth in repository objects)

    Job Scheduler
    One of the following schedules is needed for snapshot jobs, report scheduling, and Windows scheduling:
    Oracle DBMS_JOBs is used for scheduling snapshot jobs on Oracle8i and Oracle9i.
    Oracle DBMS_SCHEDULER is used for scheduling snapshot jobs on Oracle10g.
    A third-party job scheduler can be used instead of an Oracle DBMS package.

    Oracle Initialization Parameters
    Oracle initialization parameters should be set as follows:
    OPEN_LINKS—The value for OPEN_LINKS initialization parameter should be equal to or greater than the number of monitored databases assigned to a repository. The default value for this parameter is 4; the maximum is 255.
    JOB_QUEUE_PROCESSES—The value for the JOB_QUEUE_PROCESSES initialization parameter should be greater than zero in Oracle 9.2 databases. For optimal performance of snapshot jobs, it should be equal to or greater than the number of monitored databases assigned to a repository. The maximum is 1,000.

    Character Set 
    Must be a superset of the character sets for all monitored databases. A UTF8 character set is recommended.

    Activity Level
    Light activity level.

    Language Supported


    US English
Documents Documents
Download printable materials to gain insight on how this product can help you simplify IT challenges.
   
Events Events
Peruse webcasts and in-person activities near you to explore the technology behind this product.
   
Community Community
Get the most from this product as you join your peers and Dell experts to access tools and learn best practices.
Chat

Go ahead. Ask us anything.

You've got questions, we've got experts that can help. Find out now.
Chat Online
2016 Global Excellence Silver Award Winner: Endpoint Security

KACE K1000 Systems Management Appliance

2016 Global Excellence Silver Award Winner: Endpoint Security
Learn More
Dell Financial Services

Improve the speed of doing business.

0% Finance Lease rate available on Dell SonicWALL systems.** Based on a 36-month Finance Lease.

Learn More
Dell Software | Contact Us

Contact a Dell Expert

Get help with all your business needs.

Learn More
Dell Software | Support

Software Product Support

Single location for all your product needs.

Learn More
 You can only compare up to 7 products. To compare this item, deselect one of the other 7 products.
close
 
 
P20-CS05