Case Study
The State of Vermont’s IT staff uses Toad DBA Suite for Oracle to easily find bottlenecks, saving hours of database administration time each week.
Read now »
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 »
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 DBA Suite for Oracle

Simplify Oracle Database Administration

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. It helps you resolve issues before they impact production and automates routine tasks, ensuring more accuracy than ever before. You can also greatly reduce the risks associated with database vulnerability, performance bottlenecks, upgrades, patches, and more. With the Toad DBA Suite for Oracle, you can work smarter, not harder — no matter how much experience you have as a DBA.

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

Sys Reqs

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

Videos

Docs