Toad for Oracle Reviews

We use Toad for Oracle for various database management tasks, including CRUD operations such as create, replace, update, and delete, and for DDL and DML tasks. We rely on Toad for managing the data structure and monitoring connected users.

Toad for Oracle simplifies the process of managing database sessions, which is particularly useful for database administrators. It allows us to handle sessions that are blocking other processes efficiently by surfing through the session browser and ending problematic sessions.

I am currently using Toad for Oracle for reporting purposes. In the past, I have used it for Oracle E-Business Suite Financials, and currently, I am using it for Oracle Cloud. While using Toad, I have also worked with SQL queries written in Java.

If I talk about my work-related tasks, using Toad for Oracle minimizes the time required for queries, and its performance is exceptional. I use it for Oracle reporting purposes.

I use it for developing packages and procedures, as well as running queries. Additionally, I use it for monitoring the DBA setup.

One thing I can say is that it helps identify issues, especially with the Flashback component. In case of an issue, we're able to drill in and pinpoint where the issue is coming from.

It can easily point you to where you need to be looking.

I wouldn't say I am a heavy user of the solution since I was running only basic SQL queries. On the solution, SELECT statements and a couple of JOINs are the things I use.

At our company, we use Toad for Oracle to test data integrity. Since our data primarily resides on database servers, we need a reliable and sturdy tool for the job. Toad for Oracle has proven to be better than other tools since we have never experienced any crashes. We have noticed that other tools, such as Microsoft SQL Server, can take a while to execute queries, sometimes up to five minutes. However, we have not encountered this issue with Toad for Oracle.

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.

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.

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.

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

Our use cases include database management and development.

Simply the best GUI software for administration is the most valuable aspect for me. Many features are built-in or already included, rather than the other software. 

We use the product to run SQL scripts in the Kubernetes environment.

The product's most valuable features are UI and monitoring.