Toad for Oracle OverviewUNIXBusinessApplication

Toad for Oracle is the #6 ranked solution in top Database Development and Management tools. PeerSpot users give Toad for Oracle an average rating of 8.6 out of 10. Toad for Oracle is most commonly compared to Toad Edge: Toad for Oracle vs Toad Edge. Toad for Oracle is popular among the large enterprise segment, accounting for 72% of users researching this solution on PeerSpot. The top industry researching this solution are professionals from a financial services firm, accounting for 19% of all views.
Buyer's Guide

Download the Database Development and Management Buyer's Guide including reviews and more. Updated: March 2023

What is Toad for Oracle?

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. ... On the operations side, you can automate administration tasks and proactively manage your databases while embracing performance optimization and risk mitigation.

Toad for Oracle Customers
intel, ebay, uber, mars, microsoft
Toad for Oracle Video

Toad for Oracle Reviews

Filter by:
Filter Reviews
Industry
Loading...
Filter Unavailable
Company Size
Loading...
Filter Unavailable
Job Level
Loading...
Filter Unavailable
Rating
Loading...
Filter Unavailable
Considered
Loading...
Filter Unavailable
Order by:
Loading...
  • Date
  • Highest Rating
  • Lowest Rating
  • Review Length
Search:
Showingreviews based on the current filters. Reset all filters
Software Developer at a tech services company with 11-50 employees
User
Top 20
Great PL/SQL debugger and "Make Code" feature with technical support that goes above and beyond
Pros and Cons
  • "A quite simple feature that I have not encountered elsewhere is the "Make Code" feature. I can easily export a complex SQL statement to a programming language. This is a great timesaver as I do not have to type in all of the escape/concatenation characters just to create a SQL statement in C# or C++."
  • "Once in a while, I may encounter a memory exception and have to abort the application. On a few occasions, the file that stores the saved connections for the New Connection window will become corrupt and I will lose all of my saved connections. I am not sure if that is a Windows or TOAD issue, but it has happened to all of my developers at some point or another."

What is our primary use case?

I use TOAD for all Oracle database management and development. I've also purchased it for our developers. The resource time I save by purchasing TOAD for my developers easily offsets the cost.

We are a smaller software company and maintain an Oracle database to test new releases. We do database administration, design, and development.

Database management includes tablespaces, data files, rebuilding indexes, tables, analyzing tables, and schema comparison.

PL/SQL development includes creating and maintaining packages.

SQL includes data queries and editing.

How has it helped my organization?

TOAD saves many hours of work by simplifying the redundant maintenance tasks for databases. We attempted to use SQL Developer a few times, but It is not as user-friendly. It seems TOAD was created to make an Oracle Developer's/Admin's life as easy as possible.

Specifically, it helps with: 

  • Schema comparison and promotion scripts
  • Rebuilding table scripts (very helpful when an existing table has been altered and needs promoting)
  • Debugging/Analyzing connected sessions and current SQL

It has a Schema Browser that provides all needed data in a clear and accessible way. This helps our software engineers who are not Oracle experts with the dictionary tables

What is most valuable?

The most valuable feature is honestly that so many features are packed into a single software package. TOAD is one of only a few applications that I have not had to complement with additional software or "add-ons".

The PL/SQL debugger is fantastic and has been a huge time-saver.

A quite simple feature that I have not encountered elsewhere is the "Make Code" feature. I can easily export a complex SQL statement to a programming language. This is a great timesaver as I do not have to type in all of the escape/concatenation characters just to create a SQL statement in C# or C++.

This is not a "software" feature, however, I have contacted Quest when a version had a very specific bug that was affecting my team. They scheduled a meeting to review the issue pretty quickly and I spoke to several knowledgeable people. They had already implemented a fix, communicated when the release would be available, and provided me with a beta version to hold me over until the official release. The level of service they provided was astounding.

What needs improvement?

I honestly cannot think of any at the moment. I am sure there are some, however, I use it every day. Any issues tend to be few and far between. Once in a while, I may encounter a memory exception and have to abort the application. On a few occasions, the file that stores the saved connections for the New Connection window will become corrupt and I will lose all of my saved connections. I am not sure if that is a Windows or TOAD issue, but it has happened to all of my developers at some point or another. The incident rate is only about once every 6 months, so that makes it more palatable.

Buyer's Guide
Database Development and Management
March 2023
Find out what your peers are saying about Quest Software, Oracle, IDERA and others in Database Development and Management. Updated: March 2023.
688,083 professionals have used our research since 2012.

For how long have I used the solution?

I've been using the solution for 16 years.

What do I think about the stability of the solution?

The solution has been very stable. 

The stability issues I have encountered have been memory exceptions which can cause the application to crash. Since I use the application intensely on a daily basis, these do not occur with enough frequency to cause disruption. The memory exceptions have reduced in likelihood with each new release. If I had to put a "rough" number I would say once every month or so.

What do I think about the scalability of the solution?

The solution seems easily scalable. The developers that use it have no issues keeping new versions updated. 

How are customer service and support?

The one time I used the customer service, it was excellent. Everyone I spoke with was very knowledgeable and customer-focused. I shared that experience many times afterward because I was so impressed that there are still companies with that level of support.

Which solution did I use previously and why did I switch?

I have tried SQL Developer but it was missing several "of the nice to haves" that made TOAD very convenient.

How was the initial setup?

The setup was easy. I downloaded TOAD and an Oracle Client.

What about the implementation team?

We handled the deployment in-house.

What was our ROI?

I do not have specific numbers, but the ROI has been positive. I want my developers to focus on logic and not on the nuances and minutia of Oracle.

What's my experience with pricing, setup cost, and licensing?

If you or your team regularly develops within Oracle, the convenience and time-saving are well worth the cost. On the surface, the initial cost may seem steep. However, my thoughts are that:

  1. The renewal rate is reasonable so look at the multi-year cost. 
  2. If a developer saves 20 hours annually by utilizing TOAD's functionality, the software has easily paid for itself just in saved productivity alone.

Which other solutions did I evaluate?

No, I did not evaluate anything else prior to using TOAD.

Which deployment model are you using for this solution?

On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Manager of Migration of Oracle Forms Applications at CIEMAT at Aubay Spain
User
Fast, good data management, and helps in the development of code
Pros and Cons
  • "The tool evaluates non-optimized queries and generates the queries in a way that is more optimal - in addition to giving us some good practices for code development."
  • "Query optimization is still very resource-intensive."

What is our primary use case?

I use the solution mainly for database queries and updates since it allows you to see the result of those queries in a multi-record block where you can browse the different records.

I also use it to develop code within the database itself, such as procedures, functions, packages, et cetera, thanks to the rapid development tips it has.

Another function that I use is the comparison of structures and code between the different environments. We currently have three environments, and I can see the differences in each environment.

How has it helped my organization?

The development of applications that use an Oracle Database and PL/SQL for their data management are developed much faster. 

The different aids that the tool has for the development of code in the database speed up the development. While it not only helps in the development of code, it also helps in the maintenance of the applications by being able to analyze the data and the queries of the applications that do not work correctly. In this regard, the fact that you can see the different results in a multi-registry and that you can navigate in it helps a lot. Toad saves you time.

What is most valuable?

One of the features that I like the most is the result of queries in multi-record blocks that you navigate through. This data can also be exported to other formats. The export to Excel format is especially useful to provide them to the end user so that they can create more specific reports.

Another feature that I really appreciate is the ability to analyze non-optimized queries. The tool evaluates non-optimized queries and generates the queries in a way that is more optimal - in addition to giving us some good practices for code development.

What needs improvement?

Although the tool has come a long way since I started using it, there are still some things that need to be improved.

For example, query optimization is still very resource-intensive, and sometimes it is slow to get the results. On some occasions, I have had to leave it analyzing for more than 12 hours.

Another thing that could be improved is the reporting. In particular, it seems to me that it is difficult to be able to make a report using the tool. Currently, I have to make the queries in Toad and transfer them to other tools (for example, SQL*Plus, Oracle Reports, et cetera).

For how long have I used the solution?

I've used the solution for about 20 years. I've been using Toad since 2003.

Which solution did I use previously and why did I switch?

Before using Toad, I started using its source, SQL Navigator. I changed due to the fact that Toad is more complete.

At one time, when there were no Toad licenses on the development team, we used the Oracle SQL Developer tool. During that time, it was more difficult for us to carry out development.

Which deployment model are you using for this solution?

On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Flag as inappropriate
PeerSpot user
Buyer's Guide
Database Development and Management
March 2023
Find out what your peers are saying about Quest Software, Oracle, IDERA and others in Database Development and Management. Updated: March 2023.
688,083 professionals have used our research since 2012.
Senior Oracle Apex Developer at Abu Dhabi City Municipality
Real User
Top 10
Easy to install, simple to manage, and offers excellent management
Pros and Cons
  • "It is very easy to manage all of the objects."
  • "I'd like reporting to be more available. If it was a feature that was already installed, more people would take advantage of it."

What is our primary use case?

I primarily use the solution a developer query, or for triggers, to use and manage all tables and objects for Oracle.

What is most valuable?

I like the features on offer. If I need to manage my data for analysis, analysis data for tuning, debugging, or whatever, it's easy. 

It does offer a free trial. 

The installation process is very easy.

It is very easy to manage all of the objects. 

What needs improvement?

I'd like to have a free version. Once I move companies, I do not have a license. I only have limited days of a trial. I'd like to be able to show the company what it can do. However, now, I've shifted to a different service since I don't have my Toad license. 

There are limitations to its use. If you do not have a license, some features are not allowed. 

There is a trial, however, after this trial, I can't use the Toad as not all features are there since you have to pay for them.

I'd like reporting to be more available. If it was a feature that was already installed, more people would take advantage of it. 

For how long have I used the solution?

I've used the solution for more than nine years.

What do I think about the stability of the solution?

The stability has been good. It doesn't creak down. There are no bugs or glitches. It doesn't crash or freeze. 

What do I think about the scalability of the solution?

We have about 50 people using the solution. 

How are customer service and support?

I've never had to reach out to technical support. I don't know how helpful or responsive they are when you need help. 

Which solution did I use previously and why did I switch?

I've shifted use to PSQL since I've changed companies. 

How was the initial setup?

The initial setup is very simple and straightforward. It's not overly complex. 

What's my experience with pricing, setup cost, and licensing?

There are some licensing restrictions. You have to pay for certain features. 

It is an expensive product. 

What other advice do I have?

We're a partner of Oracle. 

I'm not sure which version of the solution we're using. We have used both the home version and the version available on the cloud. 

About four months ago, I stopped using Toad as I no longer have a license and therefore cannot access all of the features I need. 

I'd recommend the solution to others. 

I would rate the solution eight out of ten. 

Which deployment model are you using for this solution?

Public Cloud

If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?

Other
Disclosure: My company has a business relationship with this vendor other than being a customer:
Flag as inappropriate
PeerSpot user
Data Warehouse Analyst at Qatar Airways
Real User
Is stable and has no issues with regard to scalability
Pros and Cons
  • "I haven't seen any issues with scalability. We have about 1000 people on our IT team who use the solution."
  • "Improvement wise, for the user it should show the minimum features on the screen and not all the features. Toad has a lot of features, but most users will use only 5 or 10 based on their role. Nobody needs all the features, and they should provide the option to choose only the required features. Only minimum requirements should be enabled by default. When all the features are shown, the performance is not good; it loads slowly and has hundreds of popups and unnecessary questions."

What needs improvement?

Improvement wise, for the user it should show the minimum features on the screen and not all the features. Toad has a lot of features, but most users will use only 5 or 10 based on their role. Nobody needs all the features, and they should provide the option to choose only the required features. Only minimum requirements should be enabled by default. When all the features are shown, the performance is not good; it loads slowly and has hundreds of popups and unnecessary questions.

If they could provide some basic instructions performance wise and list which settings will achieve the best performance or make it more user friendly, then it would help new users and old users alike.

For how long have I used the solution?

I've been working for more than 10 to 15 years with this solution. We use it individually on our laptops.

What do I think about the stability of the solution?

It is stable. However, if you ignore the initial configurations you may encounter problems. That is, if you don't do the Toad options, it will try to connect to a Quest site every time you open it.

What do I think about the scalability of the solution?

I haven't seen any issues with scalability. We have about 1000 people on our IT team who use the solution.

How was the initial setup?

Implementation is okay, but we continue to encounter problems with Toad for Oracle. When we try to download it, it gives us a lot of other options and loads so many other things that make our client's software heavier.

What other advice do I have?

If you're using the latest version, you should know how to migrate your existing scripts. You should do some research on how to copy your script or backup and look for store options, default options, and settings. You would need to find out how to automatically push whatever you have done in the old version to the new tool. You may need to do it manually. Otherwise, Toad will crash.

The product is good, but it comes with a lot of default settings that you may not need and may slow you down. Because of this, I would rate Toad at nine on a scale from one to ten.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
Flag as inappropriate
PeerSpot user
Razaul Karim - PeerSpot reviewer
Manager (Oracle EBS ) at PRAN-RFL Group
Real User
Top 20
An Oracle developer and database administration software tool that is very flexible and helpful in query accuracy, analysis, and data visualization
Pros and Cons
  • "I like that it's very flexible and helpful in query accuracy, analysis, and data visualization. I also like the move facilities available in Toad for Oracle. Overall, I think it's a fantastic product for analyzing SQL queries and managing all kinds of queries."
  • "It would be better if they had an online option allowing me to connect from anywhere on any device. Sometimes I face some errors, depending on the network and setup. It's not a big issue."

What is our primary use case?

We are using SQL and are pretty skilled, and it's convenient to write SQL queries in Toad. When I write something, it shows the name and column, and the output is very fast.

The Oracle EBS system is the largest database system, and our company is big in Bangladesh. This is the largest group of companies, so we have a lot of daily transactions, and our database size is approximately 10 TB. We are analyzing all types of transition queries and lots of things.

What is most valuable?

I like that it's very flexible and helpful in query accuracy, analysis, and data visualization. I also like the move facilities available in Toad for Oracle. Overall, I think it's a fantastic product for analyzing SQL queries and managing all kinds of queries.

What needs improvement?

It would be better if they had an online option allowing me to connect from anywhere on any device. Sometimes I face some errors, depending on the network and setup. It's not a big issue.

For how long have I used the solution?

I have been using Toad for Oracle since 2012.

What do I think about the stability of the solution?

Toad for Oracle is a stable product.

What do I think about the scalability of the solution?

Toad for Oracle is a scalable product. Our company has an IT department and a technical support team. Everybody is using these tools for analysis and executing queries. More than 30 people are using Toad for Oracle.

How was the initial setup?

The initial setup is straightforward. I have done it many times on many different laptops and servers. The deployment time depends on the people involved and their skill level.

What about the implementation team?

We implemented this solution.

What other advice do I have?

I would tell potential users that this is a very good product. I'm using it right now, and it's the best for me.

On a scale from one to ten, I would give Toad for Oracle an eight.

Which deployment model are you using for this solution?

On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Flag as inappropriate
PeerSpot user
Jarle Vestrheim - PeerSpot reviewer
Billing Consultant at Hoberg & Vestrheim
Consultant
Top 10
The fashion browser and the Schema browser are valuable features, it is a complete solution
Pros and Cons
  • "The most valuable feature of Toad for Oracle is the fashion browser and the Schema browser. It is very complete."
  • "Toad for Oracle could improve code completion, it is very slow."

What is our primary use case?

The solution is deployed on public cloud and on premises. One on each developer's computer.

We use Toad for Oracle mainly to create procedures in the database, and to make an API. We have three people in our IT department using the solution in our company.

What is most valuable?

The most valuable feature of Toad for Oracle is the session browser and the Schema browser. It is very complete. There is also good tools for database management.

What needs improvement?

Toad for Oracle could improve code completion, it is very slow. When you type and code completion is on, you'll have to wait for up to 10 seconds while Toad looks in the database to list suggestions for table and field names.

For how long have I used the solution?

I have been using Toad for Oracle for 10 years.

What do I think about the stability of the solution?

The solution is scalable.

What do I think about the scalability of the solution?

Toad for Oracle crashes a couple of times per month.

How are customer service and support?

I would rate technical support a 5 out of 5.

How would you rate customer service and support?

Positive

Which solution did I use previously and why did I switch?

We use both Toad for Oracle and DataGrip. Toad for Oracle's code completion is very slow when compared to DataGrip.

How was the initial setup?

The initial setup of this solution is very easy. Basically, it is an install and forget solution.

What about the implementation team?

We deployed in-house, it takes only five or ten minutes to deploy.

What was our ROI?

Very good, we are a consultancy and it does not take many hours to pay for the annual fee.

What's my experience with pricing, setup cost, and licensing?

Our company pays licensing fees. It is not a cheap solution.

What other advice do I have?

The solution is easy. I would rate it an 8 out of 10.

Which deployment model are you using for this solution?

On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Buyer's Guide
Download our free Database Development and Management Report and find out what your peers are saying about Quest Software, Oracle, IDERA, and more!
Updated: March 2023
Buyer's Guide
Download our free Database Development and Management Report and find out what your peers are saying about Quest Software, Oracle, IDERA, and more!