Notice: quest.com will be retired soon. Please visit our new site at software.dell.com
Quest Support
  • Global Coverage
  • Highly Skilled Engineers
  • Commitment to Customer Satisfaction
  • Flexible Support Offerings
Learn more »
Toad DBA Suite
for Oracle
Visit shop.quest.com to buy this product online.
Buy Online »
Toad World adds value to your Toad experience by providing free education and revealing new functionalities — along with
time-saving tricks and tips.
Visit the community »
Tech Brief
Learn how to collect and analyze performance metrics to predict the future behavior of your Oracle databases in this tech brief about predictive diagnostics.
Read now »

Toad DBA Suite for Oracle - RAC Edition

Simplify Oracle administration and solve RAC performance bottlenecks quickly

The Toad™ DBA Suite for Oracle is a complete set of Oracle DBA tools that enable you to become more proactive by automating maintenance, ensuring optimal performance, and mitigating the risk of change. The RAC Edition extends those capabilities by adding Spotlight® on Oracle RAC, which provides a graphical view of performance diagnostics for a better understanding of your RAC environment. In addition, the Toad for Oracle and Benchmark Factory® components of the suite automatically detect the presence of Oracle RAC and have their own productivity- and performance-enhancing functionalities for RAC environments.

And be sure to check out Quest Backup Reporter for Oracle. This free beta product, which is available in the Toad for Oracle community, helps you manage Oracle RMAN backups with ease.

Features

  • Ensure proper maintenance, performance, and change
  • Predict the impact of changes on production instances
  • Manage and maintain schemas, including compare and sync
  • Replay database workload in development or on test databases to simulate the production environment
  • Administer databases, including users, roles, infrastructure and utilities, and manage, synchronize, and deploy schema changes 
  • Manage Oracle user accounts efficiently and accurately without the use of scripts 
  • Ensure the best-possible application performance by proactively identifying issues directly from running SQL statements, PL/SQL, or other source code and automate the SQL optimization process 
  • Perform and schedule checks of database instance health and security
  • Deploy high-quality applications that meet user requirements and perform reliably in production
  • Lower the risk of slow transaction response time and downtime
  • Reduce the total cost of Oracle database ownership and decrease development cycles by resolving problems proactively
  • Minimize administration costs by automating tasks and ensuring code efficiency and accuracy
  • Take eight hours of free, web-based training to help you get the most from Toad’s powerful functionality

Videos

Docs

Sys Reqs

Platform1 GHz processor (Spotlight requires 1.2 GHz processor)
Memory924 MB RAM required, 1 GB recommended
Operating System
  • Windows 2000, XP, 2003, Vista, 2008 and Windows 7 (32-bit and 64-bit)
Notes:
  • When running on a 64-bit operating system, you must use the 32-bit Oracle Client.
  • In Windows Vista, you must use a logon with the Admin privilege or if you are logged on as a normal user, you must have the Universal Access Control (UAC) turned OFF.
Product Exceptions
  • Spotlight on Oracle: Requires Windows 2000 (Service Pack 4 or later) or Windows XP (Service Pack 1 or later)
  • Toad Data Modeler: Requires Windows 2000 (Service Pack 4 or later).
  • Toad for Data Analysts: Does not support Windows 2000, Windows 2003 (64-bit), DB2 connections on Windows XP (64-bit only).
Database Client
  • Oracle 8i Client (Net 8)
  • Oracle 9 Client (Net 9)
  • Oracle 10 Client (Net 10) or Instant Client 10
  • Oracle 11 Client (Net 11) or Instant Client 11.1.0.7
Note: Only the 32-bit Oracle client is supported.
Database Server
  • Oracle versions 8.0.6; 8.1.7; 9i; 9iR2; 10gR1;10gR2; 11gR1, 11gR2
Product Exceptions
  • Quest SQL Optimizer for Oracle: Requires Oracle 8.1.7 or later
  • Spotlight on Oracle: Requires Oracle 9.2.0.4 or later and SQL*Net 2.3.4 or later
  • Toad for Data Analysts: Requires Oracle 9i or later
Additional Requirements
  • VGA monitor, 1024x768 resolution, small fonts (Spotlight requires 1280x1024 or larger)

 

Toad now supports the following cloud databases

Oracle on Amazon EC2as well as the following virtualized environments:

Application:
  • Citrix support on Windows Server
  • 2003 (Service Pack 2) using the MetaFrame Presentation Server 4.0 and Citrix Presentation Server Clients 10.2
Desktop (VDI):Quest vWorkspace 7.0 on Windows XP Professional 32-bit (Service Pack 2)
Server:
  • VMWare ESX Server 3.5 and VMWare
  • Server Console 1.0.10 on Windows Server 2003(Server Pack 2)