Getting a Handle on Oracle 10g

By Lisa Vaas  |  Posted 2003-09-15 Print this article Print

Tools ease handling of Oracle database.

The long-anticipated unveiling of Oracle Corp.s grid computing vision at OracleWorld here last week introduced new requirements for managing databases that DataMirror Corp., Embarcadero Technologies Inc. and Oracle itself aim to fulfill.

In addition to the splashy debut of the 10g version of its database, Oracle at the show introduced OEM (Oracle Enterprise Manager) 10g.

OEM 10g, which sits on top of the database and the new Oracle Application Server 10g, introduces automated management that lets database administrators enforce policies, manage service levels, and rebalance computing resources and applications as business requirements shift.

Central to OEM 10gs grid management is the Grid Control feature, said officials of the Redwood Shores, Calif., company. It monitors and manages grids, including databases, applications and storage, within one console. At its core is a control repository with performance, availability and configuration data that lets Grid Control offer recommendations on those topics. Grid Control also transforms and configures data into usable information.

DBA toolshed

  • OEM 10g Automates enforcement of policies, management of service levels and rebalancing of computing resources

  • DataMirror iReflect 1.5 Provides better data availability and easier administration

  • Embarcadero Job Scheduler 3.0 Gives DBAs centralized control of cross-platform, enterprisewide job scheduling

  • Jeremy Forman, a computer systems analyst for the New Mexico Department of Transportation, in Santa Fe, is beta testing Application Server 10g and OEM 10g with the goal of better managing a large multimedia database with some 5 million stored images. Eventually, Formans department wants to construct a virtual drive-through of the states roads. Its not the grid that gets Formans approval—rather, its the self-management aspects of the new architecture.

    "Im the only DBA in the department," Forman said. "10gs offering so many automation features. Ive used OEM extensively. Im excited about production with 10g because it allows me to automate day-to-day stuff: managing table spaces, and performance tuning, more than anything. It offers you a fix on the fly without having to go through the process of finding it out yourself."

    Separately at the show, DataMirror, of Markham, Ontario, introduced iReflect 1.5, which is designed to help administrators of Oracle environments build a near-zero-latency environment when it comes to downtime, officials said. Enhancements include extended support in DDL Refresh to refresh an objects function before its data. iReflect 1.5 also offers master-to-master replication. This bidirectional data replication can be used to maintain data integrity while performing load sharing between servers.

    For its part, Embarcadero, of San Francisco, rolled out Job Scheduler 3.0, which officials said will give DBAs centralized control of cross-platform, enterprisewide job scheduling. The software manages tasks in Embarcaderos DT/Studio, its software for data extraction, transformation and loading.

    Lisa Vaas is News Editor/Operations for and also serves as editor of the Database topic center. Since 1995, she has also been a Webcast news show anchorperson and a reporter covering the IT industry. She has focused on customer relationship management technology, IT salaries and careers, effects of the H1-B visa on the technology workforce, wireless technology, security, and, most recently, databases and the technologies that touch upon them. Her articles have appeared in eWEEK's print edition, on, and in the startup IT magazine PC Connection. Prior to becoming a journalist, Vaas experienced an array of eye-opening careers, including driving a cab in Boston, photographing cranky babies in shopping malls, selling cameras, typography and computer training. She stopped a hair short of finishing an M.A. in English at the University of Massachusetts in Boston. She earned a B.S. in Communications from Emerson College. She runs two open-mic reading series in Boston and currently keeps bees in her home in Mashpee, Mass.

    Submit a Comment

    Loading Comments...
    Manage your Newsletters: Login   Register My Newsletters

    Rocket Fuel