Quest Hones Database Management Tools

Tools sport new memory management capabilities and automated advice that can help get DBAs out of tight spots.

Quest Software Inc. is rolling out a version of Quest Central for Oracle that sports new memory management capabilities and automated advice that can help get DBAs out of tight spots, the company announced on Monday.

Quest Central for Oracle 2.7 is a collection of database management tools including Spotlight on Oracle, a diagnostics tool; SQLab Vision, a tuning tool; Live Space Management, a tool for managing space and reorganizing without taking a database down; and Knowledge Xpert, a tool that supplies definitions to help DBAs work through problems.

TOAD (Tool for Oracle Application Developers), a database development product that normally ships with Quest Central versions, is not included in this version. TOAD will appear in Version 4.0, which will ship in the fall, said officials at the Irvine, Calif., company.

Quest Central for Oracle 2.7 enables database performance tuning, administration, performance diagnostics and space management in a single console. The update features an enhanced console that allows for user feedback, browsing thats enabled through a virtual tree, notification of license expiration and an option to automatically check for software updates.

The update will enable database administrators to view temporary and locally managed data files and tablespaces. It comes with new Table VOEs (Visual Object Editors), giving DBAs the ability to modify tables and their parameters. It also features the ability to kill user sessions from the console. As part of the standard console—i.e., shipping with any of the suites components—the software also provides the ability to look into Oracles Trace files through a GUI interface.

Performance diagnostics were updated with new Oracle9i advisories, enhanced startup-up and loading views, and the ability to remember Windows sizing and positioning.