DBControl Online™: Feature Set

When there's no time for downtime, DBControl Online maintains your Oracle database while assuring 24 x 7 availability.


DBControl 3.1.2 GA is now available

Significant enhancements include:

Enhanced Job System
There is a completely new UI for managing jobs in DBControl, and the job system has been enhanced with the following:

  • Hierarchy and dependencies for multi-object reorgs
  • No more 2 or 3 concurrent job limit
    Easily restart failed jobs or job phases
  • Job log kept in the database instead of on the filesystem
  • Multi-database jobs
  • More opportunities to do roll-forward recovery
  • Reorg space analysis stored in the database
  • Filters for the job list based on time and status
  • Grantable role for using the job system

Configurable Ports
The ports and schema used by DBControl can now be configured, to allow custom or multiple (on UNIX or Linux) installations.

Schema Comparison and Evolution

Compare whole schemas between databases and produce jobs that will evolve one database to match the schema of another.

Merged DBControl for Oracle and DB2 LUW

DBControl for DB2 LUW is now part of the main DBControl product line, instead of being a separate product line. Functionality is still different between the Oracle and DB2 LUW products, but you can use the same installation of DBControl Client or Server to connect to either database.

Reorg Advanced Options UI

An Advanced Options UI is available in single-table online reorg that allows you to set several fxconfig.ora options as per-reorg options.

Better support for SAP Business Suite

Online reorg automatically updates SAP control tables with new tablespace information.


Standard DBControl capabilities include:

Reclaiming fragmented space and increasing the speed of data access—Online.
Increase system performance while reducing downtime Reorganizations are performed on Oracle databases to reclaim fragmented space and increase the speed of data access. Keeping your tablespaces and indexes organized is one of the most important steps you can take to maintain and/or improve application performance. DBControl Online improves performance, increases data availability, reduces online transaction processing time, maximizes human resource productivity, and provides efficient service to your customers and prospects.

Maintaining full read/write capabilities during maintenance
Ensure complete data availability during database maintenance. Perform database reorganizations, structural changes or partition management, while users can continue making updates, completely unaware that the DBA is maintaining the database. your business benefits because your data is virtually always available.

sapApproved No Risk Assessment in an SAP environment
In SAP's integration assessment performed by SAP's ICC-Lab in Waldorf certified that DBControl Online for Oracle met test requirements and poses no risk to SAP customers. Bradmark's online reorg tool is the only one in its class to be both certified by SAP and use approved Oracle technology to manage redo logs.

Data reorg When You Want To
You don't have to take your database offline to perform a reorganization. Now, you can reorg any time, day or night—without disrupting your users or staying at the office all weekend. DBControl Online, improves end-user productivity so DBAs can make more efficient and cost-effective use of their maintenance window. Organizations benefit from decreased DBA overtime and increased productivity.

See comparasion of DBControl Online to Oracle's Enterprise Manager (OEM) for online reorg.

Staying Informed
DBControl Online integrates with the Surveillance to keep the DBA appraised of changes in status of the assigned DBControl Online tasks. Notification can be sent by a variety of methods including e-mail and paging.

Complete Control of Your Oracle Database
DBControl Online offers Online Reorganization of Tables, Online Structural Change and Online Partition Management.

In addition, DBControl Online provides additional features including traditional Space Management, traditional Structural Change, Trend Analysis, Security, Schema Object Administration and SQL Tuning.