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.
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
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.
Tour
Automation Designer
Automate complex and repetitive tasks like schema compare, script execution, administration, reporting and more.
Specifications
- Windows 8.1
- Windows 10
- Windows 11
- Windows Server 2012 R2 - 2 CPU required
- Windows Server 2016
- Windows Server 2019
- Windows Server 2022
- 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.
Resources
Toad for Oracle Datasheet
Develop and manage Oracle databases with less time and effort.
Upgrading Quest Toad for Greater Security
This Technical Brief details Quest’s adherence to software security standards for continually testing and delivering versions o...
Toad for Oracle Tips and Tricks
Whether you are new to Toad or have been using it for several years, there are always features that you may not be aware of tha...
Toad for Oracle - Which Edition is Right for You
Develop and manage Oracle databases with less time and effort.
How Toad for Oracle DBA Edition Complements Oracle Enterprise Manager
Technical Brief: Toad for Oracle DBA Edition Complements Oracle Enterprise Manager
Full E-book: Enabling Agile Database Development with Toad
This paper will show you how, by implementing Toad for Oracle Developer Edition and Toad DevOps Toolkit, the database developme...
The Top Five Reasons to Choose Toad Over SQL Developer
In this tech brief, Toad® expert John Pocknell reveals how it's not only possible, but is in fact quite likely, that you'll win...
Keep Using Toad for Oracle With Databases in the Cloud
In this technical brief, the changing roles of database administrators (DBAs) in the widespread migration of Oracle databases t...
Get started now
Modernize your Oracle database operations to enable business agility