For Oracle Database Manager, Things Go Better With Quest - InformationWeek

InformationWeek is part of the Informa Tech Division of Informa PLC

This site is operated by a business or businesses owned by Informa PLC and all copyright resides with them.Informa PLC's registered office is 5 Howick Place, London SW1P 1WG. Registered in England and Wales. Number 8860726.

IoT
IoT
Software // Information Management
News
9/30/2005
07:25 PM
Connect Directly
Twitter
RSS
E-Mail
50%
50%

For Oracle Database Manager, Things Go Better With Quest

Database administrator relies on Quest tools for analyzing query performance and correcting database snafus.

At Stride Rite Corp., Ray LeFebvre, database manager, finds that managing 50 Oracle database systems with a small staff is easier once a third party's graphical-management tools are sitting on top of his Oracle 8i and 9i systems.

Oracle builds numerous management utilities into its database for administrators. But for the last five years, LeFebvre has relied on Quest Software Inc.'s Quest Central and other Quest tools to bring ease of use to the Oracle command line. Stride Rite was a beta tester of the latest Quest Central release 5.5, issued Sept. 19, and now uses it in production.

The $5,900-per-server tool has added capability for analyzing the performance of regular SQL queries or Oracle's PL/SQL queries and identifying problem areas. Quest 5.5 can automatically rewrite SQL queries to optimize them for performance. It also scans source code in the database in the form of triggers and stored procedures, looking for potential bottlenecks.

"We use it a lot to determine performance issues, to pinpoint what's going on inside the database," says LeFebvre, who has a staff of three database administrators. It's possible to do many performance checks without the tool but it means writing your own SQL, PL/SQL, or Oracle database command syntax.

If something goes haywire with a change in the database, Quest has the option of clicking on a symbol to go back to an earlier, unchanged version. It also tells you who made the change that caused things to go wrong, Lefebvre says. "You're not mired down in Oracle syntax," or writing scripts that test for what went wrong, he says.

Transactions in Oracle drive the order-management system at Stride Rite, as customer-service agents visit retailers and place orders for them. "It's critical to us. We couldn't make Oracle work around the clock, seven days a week, without it [Quest Central]. Our order-management system is our lifeblood," LeFebvre says.

Oracle offers some management assistance, in addition to the command-line interface, through tools like its Oracle Enterprise Manager. "It's free, up to a point," LeFebvre says. Once you depend on it, you'll start buying enhancements, he says.

Log Miner is an Oracle utility for pulling information on database activity out of Oracle database log files. An additional Quest tool, Toad for Oracle, makes Log Miner easier to use by "putting a user interface around it. We can restore lost data without having to go to backup tapes," through a few clicks of the mouse, LeFebvre says.

By being able to spot performance problems before they show up in production, LeFebvre says Stride Rite IT has "become a more proactive shop, instead of just being reactive."

We welcome your comments on this topic on our social media channels, or [contact us directly] with questions about the site.
Comment  | 
Print  | 
More Insights
Slideshows
Top-Paying U.S. Cities for Data Scientists and Data Analysts
Cynthia Harvey, Freelance Journalist, InformationWeek,  11/5/2019
Slideshows
10 Strategic Technology Trends for 2020
Jessica Davis, Senior Editor, Enterprise Apps,  11/1/2019
Commentary
Study Proposes 5 Primary Traits of Innovation Leaders
Joao-Pierre S. Ruth, Senior Writer,  11/8/2019
White Papers
Register for InformationWeek Newsletters
Video
Current Issue
Getting Started With Emerging Technologies
Looking to help your enterprise IT team ease the stress of putting new/emerging technologies such as AI, machine learning and IoT to work for their organizations? There are a few ways to get off on the right foot. In this report we share some expert advice on how to approach some of these seemingly daunting tech challenges.
Slideshows
Flash Poll