Toad for Oracle Reviews

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

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

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.

We use Toad as a solution for packages and day-to-day tasks, like calling and finding, when we have some support queries or need to check if there is a data issue. We also use it when we want to develop objects. For those kinds of sites only we use Toad. Sometimes we use it to load data from a third-party source.

It just gives us another tool to use when working with clients to solve issues.

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.

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.

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.