Toad DBA Suite for Oracle

• 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

System Requirements

Platform

• 1 GHz processor (Spotlight requires 1.2 GHz processor)

Memory

• 924 MB RAM required, 1 GB recommended

Operating System:

• Windows 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 7 or Windows XP (Service Pack 1 or later)

• Toad Data Modeler: Requires Windows 7

• 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 EC2 as 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)

Languages Supported:

• US English

• Product Demo: Toad DBA Suite for Oracle

  Learn how to be a more proactive DBA by simplifying common database administration tasks and ensuring code remains at peak performance in production with the Toad DBA Suite.

  View demo »

• Toad DBA Suite for Oracle Product Overview

  Learn about the Toad DBA Suite for Oracle, Quest Software’s comprehensive set of DBA tools for automating maintenance, ensuring performance and mitigating change risks.

  Watch the video »

• What's New for DBAs in Toad for Oracle 11.5

  Learn what’s new for DBAs in version 11.5 of Toad for Oracle from Quest Software - Simply the Best Productivity Tool for Oracle Database Professionals.

  Watch the video »