Free Newsletters:
DatabaseJournal  
DBANews
Database Journal
Search Database Journal:
 
MS SQL Oracle DB2 Access MySQL PostgreSQL PHP SQL Etc SQL Scripts & Samples Links Database Forum DBA Videos
internet.com

» Database Journal Home
» Database News
» DBA Videos
» Database Articles
» Database Tutorials
MS SQL
Oracle
MS Access
MySQL
DB2
» RESOURCES
Database Tools
SQL Scripts & Samples
Links
» Database Forum
» DBA Jobs


internet.commerce
Partner With Us














internet.com
IT
Developer
Internet News
Small Business
Personal Technology

Search internet.com
Advertise
Corporate Info
Newsletters
Tech Jobs
E-mail Offers

Database Journal | DBA Support | SQLCourse | SQLCourse2 | Swynk



Database Tools

Data Access/Reporting | Development | Management | Performance | Servers/Software
Submit Products *

DBControl Online

SAP Certified Oracle Data Administration and Online Reorganization

DBControl Online provides the capability to reorganize a table and its respective objects while transactions are running against it. Tables can be augmented online. In addition to the main online reorganization and partition management functionality, DBControl Online provides a set of database management features.

DBControl's Diagnostics can spot problems such as wasted space, row chaining in tables, and missing object statistics. Diagnostics can be run for a table, index, or entire tablespace.

The Tablespace Map can help the DBA identify objects with incorrect storage parameters, while reorganization features are used to correct and prevent space allocation problems. Once the objects in need of reorganization have been identified, DBControl Online can reorganize or restructure either traditional or online methods.

For a traditional Object Reorganization, DBControl Online uses an unload/reload facility that employs the Oracle Import and Export Utilities, which, according to the vendor, ensures that all referential integrity, privileges, indexes, and dependent objects are intact upon completion of the reorganization. The Tablespace Reorganization feature provides traditional reorganizations when the majority of the objects in a tablespace need reorganizing. Utilizing DBControl Online's unload/ reload facility, all objects in the tablespace are unloaded, dropped, recreated, and reloaded as a group rather than one at a time. The DBA may specify new storage parameters for any tablespace, table, index or cluster. DBControl Online rebuilds the tablespace and associated objects, either immediately or by creating a script file, or, it can be scheduled to perform the reorganization in the future.

product submission by Company Rep

E-Mail this page to a colleague
send info about DBControl Online

Suggest a link
for the DBControl Online fact sheet

fact sheet
DPW id#: 1164056334
date posted: Nov. 21, 2006
category: Database Tools:Management
platform: Console: Windows 95/98/NT/2000/XP/2003. Agent: Windows NT/2000/XP/2003; HP-UX; AIX; Solaris; Tru64; Linux. RDBMS: Oracle 7.3.4/8.0/8.1/9.0-9.2/10.1-10.2 (Online features require 8.0+)
vendor: Bradmark Technologies, Inc
(www.bradmark.com)
vendor's information:
about DBControl Online
about Bradmark Technologies, Inc


Database Tools

Data Access/Reporting | Development | Management | Performance | Servers/Software
Submit Products *

Latest category updates via our RSS feed
RSS



The Network for Technology Professionals

Search:

About Internet.com

Legal Notices, Licensing, Permissions, Privacy Policy.
Advertise | Newsletters | E-mail Offers