Features and BenefitsToad® for Oracle provides: - Greater efficiency when performing daily tasks
- Greater accuracy when writing, debugging and tuning code
- Flexibility to perform many development and administration tasks from a single tool
- A smooth workflow that allows users to move from one task to another easily
- Extensive reporting capabilities that produce quantifiable data and documentation
- Access to Oracle expertise through various Toad user communities
Toad for Oracle is available in several editions that range from basic querying and reporting functionality, to development and editing, SQL optimization, and advanced administration. Toad for Oracle Toad for Oracle Professional Toad for Oracle Xpert Toad Development Suite for Oracle Toad DBA Suite for Oracle Toad for Oracle DB Admin Module
Toad for Oracle offers a wide range of features for building and maintaining database programs, including PL/SQL and SQL scripts. It includes a PL/SQL and SQL debugging suite and built in knowledge bases: Knowledge Xpert for PL/SQL and Knowledge Xpert for Oracle Administration. You can: - Visually create queries and execute them
- Construct and manage database objects
- Share project assets such as templates, scripts, and code snippets, with other team members using Project Manager
 - Record workflow steps and play them back later with Action Recall
- Profile your PL/SQL code to find performance bottlenecks and check for code coverage
Toad for Oracle also has its own team collaboration utility called Team Coding. Team Coding works with Toad's editor to control code access.
Toad for Oracle Professional includes all of the features in Toad for Oracle, plus CodeXpert, which automates code quality reviews for an objective and consistent review process. By incorporating rules from experts such as Steven Feuerstein, you have a virtual expert at your fingertips to advise you on your code. And, Code Reviews generate a quality and performance scorecard for your code.
Toad for Oracle Professional also includes an Export File Browser, unique functionality that simplifies the extraction of useful information, including objects and data from an Oracle export file, instead of having to import the entire file. Finally, this Edition of Toad, includes Oracle import/export utility wizards, which makes it easier for you to work more efficiently.
Toad for Oracle Xpert includes all of the features in Toad for Oracle Professional, plus integrated SQL performance tuning through SQL Optimizer's SQL Scanner. This utility automatically identifies the SQL statements that may perform poorly in production. It then rewrites SQL for you and offers alternate implementations to improve performance. Toad for Oracle Xpert can also generate virtual indexes and provide advice on the impact of changes to improve the performance of a set of SQL statements. Learn more about Quest® SQL Optimizer for Oracle Download Toad for Oracle Xpert Trial
Toad Development Suite for Oracle provides an easy, automated way to leverage a wide range of Toad capabilities. It ensures high-quality applications that meet user requirements and perform reliably under production conditions. The suite comprises Toad for Oracle Xpert, Quest Code Tester for Oracle and Benchmark Factory® for Databases. It helps you focus on three areas to deploy the best possible code to production: Learn more about the Toad Development Suite for Oracle Download Toad Development Suite for Oracle Trial
Toad DBA Suite for Oracle simplifies common database administration tasks and helps DBAs become more proactive in solving database-related performance issues before they impact the production environment. The Toad DBA Suite provides an integrated set of tools to ease database administration tasks, quickly diagnose problems and automate SQL tuning and optimization. - Manage, synchronize and deploy schema changes
- Administer your databases – including users, roles, infrastructure and utilities
- Diagnose and resolve database performance issues in real time
- Identify problematic SQL statements directly from source code or execution in Oracle
- Optimize SQL statements automatically through SQL rewrite and indexing
- Manage database storage
- Perform and schedule checks of database instance health and security
- Replay database workload to simulate production environment in development/test databases
Learn more about the Toad DBA Suite for Oracle Download the Toad DBA Suite for Oracle Trial
Toad for Oracle DB Admin Module (formerly Toad DBA Module) helps maintain database health and stability. It ensures the best possible efficiency and performance while minimizing the impact of changes to your database environment. The DB Admin Module not only automates administration and reporting tasks, but it also provides a workflow that allows you to easily transition from one task to another. The Toad for Oracle DB Admin Module facilitates database administration tasks with a powerful browser-based view of performance information across multiple database instances, right down to the user session level. With the Toad or Oracle DB Admin Module, administrators can quickly: - Navigate across multiple databases and perform object management with the Database Browser
- Generate synchronization scripts, and compare and synchronize database schemas
- View Oracle performance metrics using StatsPack Browser or the AWR (Automatic Workload Repository) Browser
- Manage Oracle user accounts
- Execute a 86-point health check, complete with 23 vulnerability assessment checks
- Utilize the export file browser
- Perform tablespace management
- Schedule batch jobs
|