Integrating comprehensive solutions for the automation of database administration is a common cost-cutting strategy, marked by its ability to provide quick ROI. Several of the new features in Toad for Oracle address the critical role automation plays for DBAs tasked with managing multiple complex databases in their organizations.

Top new features included in Toad for Oracle and associated suites include:

All Editions:

• Predictive editing – auto-populates the most likely object names, variables, etc. into the code as it is written, based on context, providing users with quicker access to content they use most frequently.
• Code Road Map – provides a highly visual, graphical view of code interdependencies and relationships to other objects, improving the user’s understanding and minimizing the risk of errors during code maintenance.
• Auto debugging – automates the generation of DBMS_OUTPUT statements for developers who prefer to debug their code using standard PL/SQL output statements.

Toad for Oracle Xpert Edition and the Toad Suites:

• Auto Optimize – allows users to optimize SQL directly within the Toad Editor in a few clicks, providing a simple approach to SQL optimization.

Toad DBA Suite for Oracle and Toad DBA Suite for Oracle – RAC Edition:

• Automation Designer enhancements – automate additional DBA tasks, such as data pump import and export, comparing databases, copying table data, and generating schema and database script.
• Spotlight® on Oracle integration – includes additional contextual launch points from Toad to Spotlight to help users diagnose the root cause of performance issues.

Quest also will release an updated version of Toad for Oracle freeware, which will ease the user’s transition to the commercial version, and includes added features from the previous freeware release.