For the best web experience, please use IE11+, Chrome, Firefox, or Safari

Toad for Oracle

Modernize your Oracle database operations to enable business agility. Toad® for Oracle is the only developer tool that helps you simplify your workflow, reduce code defects and improve code quality and performance while supporting team collaboration. Automate administration tasks and proactively manage your databases while embracing performance optimization and risk mitigation. Define, search for and protect sensitive data across all your Oracle databases quickly and easily.
Toad for Oracle
Toad for Oracle product overview 01:07

You’re under pressure to take on more database responsibilities and work faster than ever before. Combined with declining resources, this puts your critical databases and cloud native applications at risk. But what if you could use a single toolset to speed Oracle SQL development and database administration while improving performance? With Toad for Oracle, you’ll reduce costs and risks by easily ensuring the health and performance of your Oracle Cloud Platform and on-premises databases.

CI/CD-ready development

Promote DevOps processes and reduce work with continuous integration and continuous deployment.

Reduce technical debt

Ensure functional accuracy and coding best practices to minimize code defects.

Automated performance testing

Ensure production scalability with automated workload replay testing.

Simplified SQL Optimization

Simplify and automate SQL optimization for developers; advanced SQL and index optimization for DBAs.

Risk mitigation

Accelerate application delivery, while minimizing risks associated with database changes.

Database performance diagnostics

Quickly pinpoint and resolve database performance inefficiencies.

95%

of the Fortune 500 trust Quest Software

130K

Customers in 100 countries

4M

Online community members

DevOps-ready development

Team Coding
PL/SQL Unit Testing
Code Review
SQL Optimization
Team Coding

Team Coding

Integrates with your preferred source control system and provides collaborative access to schema objects. This allows Team Coding to reconcile changes with the corresponding files in source control, thus simplifying and streamlining the developer experience.

Key product features

Automation

Reduce the risk of manual errors by automating complex and repetitive tasks like schema compare, script execution, administration, reporting and more. Workflow automations can be shared and scheduled for execution. Automation Designer is available with all editions of Toad for Oracle.

Data modeling

Define the most efficient data structures before building your database schemas or reverse engineer existing data structures into a new data model to make changes or to document. Toad Data Modeler is included with Toad for Oracle DBA Edition.

PL/SQL code profiling

Easily determine why your PL/SQL code is executing slowly by visually exposing performance bottlenecks. The PL/SQL Profiler is available with all editions of Toad for Oracle.

Database health and security

Assess database health quickly by validating performance, configuration and security vulnerabilities through health check reporting. Database Health Check is available with the DB Admin Module and Toad for Oracle DBA Edition.

Team collaboration

Share standards, best practices, code, scripts, artifacts and more and dramatically improve collaboration and consistency across the development organization. Project Manager is available with all editions of Toad for Oracle.

Data privacy and auditing

Find and protect sensitive data and then apply Oracle’s Data Redaction, Data Encryption and audit policies to secure and track data access. Data privacy features require Toad for Oracle Professional Edition and the Sensitive Data Protection Module.

Miami-Dade County

We have SQL Developer from Oracle, which is free, but our people prefer to use Toad. A lot of times, SQL Developer didn't provide enough functionality.

Sue Camner Senior Operating Systems Programmer and DBA Manager, Miami-Dade County Read Case Study

Large health benefits company

Since 2009 we’ve doubled the number of database professionals using Toad for Oracle, compared to all the other toolsets combined pre-2009. Toad has been very rapidly adopted because everyone knows the Toad name and it has… comprehensive capabilities.

Database engineer and executive advisor at large health benefits company Read Case Study

Major financial services company

We found that Toad has come up with new tools and more capabilities in these tools, like Team Coding. So it was a no-brainer for us to pick Toad.

Senior Manager - Database Management Read Case Study

Tour

Automation Designer
Code Review
utPLSQL Unit Test
Collaboration
Data Redaction
Database Health Check
Profiler
Auto-optimize SQL
Team Coding
Automation Designer

Automation Designer

Automate complex and repetitive tasks like schema compare, script execution, administration, reporting and more.

Specifications

  • Windows 8.1
  • Windows 10
  • Windows Server 2012 R2 - 2 CPU required
  • Windows Server 2016
  • Windows Server 2019
  • 1GHz processor
  • 1 GB RAM - Toad for Oracle 32 bit
  • 2 GB RAM - Toad for Oracle 64 bit

Note: The memory required may vary based on the following: 

  • Applications that are running on your system
  • Size and complexity of the database
  • Amount of database activity
  • Number of concurrent users accessing the database
  • 800MB — Toad for Oracle Base Edition
  • 1GB — Toad Developer Edition for Oracle
  • 530MB — Toad for Oracle Professional Edition
  • 2GB — Toad DBA Edition for Oracle
  • 625MB — Toad for Oracle Xpert Edition
  • 2GB — Toad DBA Edition for Oracle RAC and Exadata Editions
  • Oracle Client or Instant Client 10.2.0.5
  • Oracle Client or Instant Client 11.2.0.1/11.2.0.3
  • Oracle Client or Instant Client 12c Release 1 and 2
  • Oracle Client or Instant Client 18c
  • Oracle Client or Instant Client 19c
  • Oracle Client or Instant Client 21c
  • 10g Release 2
  • 11g Release 1 and 2
  • 12c Release 1 and 2
  • 18c
  • 19c
  • 21c (Linux and Oracle Cloud Infrastructure)
  • Application: Citrix XenApp 5.0 and 6.5 have been tested
  • Server: Oracle VM 3.1 has been tested
  • Desktop: vWorkspace 7.0 has been tested
  • VMware ESX Server 3.5, 4.0 and 5.5 have been tested
  • Amazon EC2 Oracle Database as a Service and Oracle Database Cloud Service have been tested.

 

To download the latest release of Toad for Oracle, visit support.

 

Get started now

Modernize your Oracle database operations to enable business agility
Quest Clients Logos
Quest Clients Logos
Quest Clients Logos
Quest Clients Logos
Quest Clients Logos
Quest Clients Logos

Support and services

Product Support

Self-service tools will help you to install, configure and troubleshoot your product.

Support Offerings

Find the right level of support to accommodate the unique needs of your organization.

Education Services

Training courses delivered through online web-based, on-site or virtual instructor-led.