Toad for Oracle

Modernize your Oracle database operations to enable business agility

Reduce the time and effort required to develop and manage Oracle databases

You're taking on more database responsibilities than ever before. The business demands you move faster but when combined with declining resources critical databases and applications are at risk. What if you could use a single toolset to speed Oracle development, administration and management to reduce cost and risk and without compromising reliability and performance?

Whether your Oracle database is on premises or in the cloud, Toad® for Oracle is the only solution of its kind that will simplify your workflow, help reduce code defects and improve code quality and performance while supporting team collaboration. On the operations side, you can automate administration tasks and proactively manage your databases while embracing performance optimization and risk mitigation.

DevOps-ready development
Integrate teams into source control. Reduce rework with repeatable processes that can be validated throughout the development cycle.
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.
OF THE FORTUNE
trust quest software
customers
in 100 countries
online
community members

DevOps-ready development

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.

PL/SQL Unit Testing

PL/SQL Unit Testing

Simplifies and automates the process of creating functional tests for all your PL/SQL code. Your test definitions are stored in a repository which can be leveraged by others for regression testing, thereby supporting a DevOps process.

Code Review

Code Review

Define coding standards from a selection of over 200 rules to ensure development teams can correct code as they type and consistently improve overall quality. This makes it easier to maintain code in the future and reduces the likelihood of defects.

SQL Optimization

SQL Optimization

A simple interface that really solves the problem of SQL tuning for developers and reduces the burden on DBAs. SQL Optimizer’s patented re-writing algorithm quickly finds alternative versions of the original SQL statement that will run faster in the database.

Product feature add-ons

Automation

Reduce the risk of manual errors by automating complex and repetitive tasks like schema compare, script execution, administration, reporting and more.

Data modeling

Define the most efficient data structures before building your schemas and reverse engineer existing data structures.

PL/SQL code profiling

Easily determine why your code is executing slowly by visually exposing performance bottlenecks.

Database health and security

Assess database health quickly by validating performance, configuration and security vulnerabilities through health check reporting.

Team collaboration

Share standards, best practices, code, scripts, artifacts and more with your team or across the development organization.

Data privacy and auditing

Leverage Oracle’s Data Redaction, Transparent Data Encryption features and audit policies to secure and track data access.

    Automation Designer

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

  • Code Review

  • Ensure consistent code quality standards to reduce problems in production and improve the maintainability of the code for the future.

  • Code Tester

  • Reduce production code defects with automated unit test creation and reporting.

  • Collaboration

  • Share standards, best practices, code, scripts, artifacts and more with your team or across the development organization.

  • Data Redaction

  • Protect selected data that is shown to users in real time without requiring changes to the application.

  • Database Health Check

  • Ensure the health of all Oracle databases with configurable checks.

  • Profiler

  • Times the execution of each line of PL/SQL code, storing the data in a repository and representing it graphically to display performance bottlenecks.

  • Auto-optimize SQL

  • Automatically generate and compare alternate SQL rewrites and choose the best alternative.

  • Team Coding

  • Controls and monitors the check-out/check-in of the PL/SQL code files in source control.

Award-winning database performance monitoring

See why Toad for Oracle was named "Best Database Management Solution" in the 2018 DBTA Readers' Choice Awards.

Specifications

  • Windows 7 (32-bit and 64-bit) to Windows 10
  • Windows Server 2008 R2 to 2012 R2 (64-bit)
  • 1GHz processor
  • 32-bit: 1GB RAM
  • 64-bit: 2GB RAM
  • 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 10g R2 through 12c R2
  • Oracle 10g R2 through 12c R2
  • Toad has been tested on Oracle Exadata 2.0 running Oracle database 12c R2
  • 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.

Resources

Toad for Oracle
Datasheet
Toad for Oracle
Toad for Oracle
Develop and manage Oracle databases with less time and effort.
Read Datasheet
Which Toad for Oracle Edition is Right for You?
Datasheet
Which Toad for Oracle Edition is Right for You?
Which Toad for Oracle Edition is Right for You?
Develop and manage Oracle databases with less time and effort.
Read Datasheet
How Toad for Oracle DBA Edition Complements Oracle Enterprise Manager
Technical Brief
How Toad for Oracle DBA Edition Complements Oracle Enterprise Manager
How Toad for Oracle DBA Edition Complements Oracle Enterprise Manager
Technical Brief: Toad for Oracle DBA Edition Complements Oracle Enterprise Manager
Read Technical Brief
Full E-book: Enabling Agile Database Development with Toad
E-book
Full E-book: Enabling Agile Database Development with Toad
Full E-book: Enabling Agile Database Development with Toad
This paper will show you how, by implementing Toad Development Suite for Oracle and Toad Intelligence Central, the database development organization can actually become agile.
Read E-book
How Are DBAs Really Managing Their Data?
Infographic
How Are DBAs Really Managing Their Data?
How Are DBAs Really Managing Their Data?
See the infographic for more information about database management trends – and how to best utilize the insights gained from all types of data sources.
View Infographic
The Top Five Reasons to Choose Toad Over SQL Developer
Technical Brief
The Top Five Reasons to Choose Toad Over SQL Developer
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 wind up saving more money with Toad than you will with SQL Developer — even though the latter is free.
Read Technical Brief
Getting Agile with Database Development
E-book
Getting Agile with Database Development
Getting Agile with Database Development
Once your organization becomes convinced of the advantages of agile development, there is no going back. Shorter time to value, lower risk and greater flexibility are among the most frequently cited benefits of the agile mentality.
Read E-book
Major financial firm advances DevOps with trusted database tools
Case Study
Major financial firm advances DevOps with trusted database tools
Major financial firm advances DevOps with trusted database tools

Senior executives at a major financial firm committed to Agile development and DevOps to spur innovation. But their database professionals needed proof that integrating the company’s vital da

Read Case Study

Get started now

Modernize your Oracle database operations to enable business agility

Support & 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.