Introduction
Database Administrator relies on Quest tools for analyzing query performance and correcting database snafus.
More..
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.
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.
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.
Thanks,
Vijay Kumar (Win)
|
No responses found. Be the first to respond and make money from revenue sharing program.
|