Working with Oracle Database made easy
January 18, 2019
Working with Oracle Database made easy
Score 10 out of 10
Vetted Review
Verified User
Overall Satisfaction with Toad for Oracle
My client organization is a big enterprise with thousands of Oracle Database instances. We bought unlimited organization level license of Toad for Oracle. This was done because almost everyone who works directly with Oracle Database used Toad, be it DBAs, developers, or testers. We have been extremely happy with the choice. I personally work on Toad for Oracle as a database administrator and developer. It gives you tons of features and makes working with Oracle Database super convenient.
- Schema Level Administration: Toad for Oracle allows you to create and maintain schema objects conveniently. It's GUI interface is the best in this class of software. It's easy to learn and get used to.
- Performance Monitoring: You can monitor database performance and long running transactions using Toad for Oracle interface. For most of the performance issues reported, i prefer using Toad for Oracle over Oracle's native tools like SQLPLUS or OEM.
- Data Modelling: You can develop data models for your database design and generate scripts to create the objects in the database instance.
- I like the ease with which Toad for Oracle lets you use features like SQL Loader, Export/Import, etc.
- It sometimes hangs up if you are working on multiple Toad instances in parallel.
- If you are running some few thousands statements through Toad, it's better you do it directly through SQL Plus interface. It takes way longer if you do it through the Toad for Oracle interface.
- Toad for Oracle should consider including some graphs and histogram charts for performance monitoring . This will be especially useful for non-technical users like project managers.
- Toad for Oracle was the product of choice and we have been extremely satisfied with it.
- Usually, DBAs prefer to use their command line scripts, but even our DBAs have been extensively using Toad for Oracle due to convenience reasons.
- Toad for Oracle has proved value for money for us. Our project delivery time has considerably improved, especially for database development and debugging phases.
[Toad offers:]
Better interface
More advance features
Better performance
Better interface
More advance features
Better performance
Toad Database Developer Tools Feature Ratings
Evaluating Toad for Oracle and Competitors
Yes - We were earlier using SQL Developer for connecting and working with Oracle Database. We started using Toad for Oracle instead and this has helped us improve our development and debugging times.
- Product Features
- Product Usability
- Product Reputation
- Prior Experience with the Product
Product Features: Toad for Oracle has tons of valuable features that made it our product of choice.
I don't really think I would change anything substantial in my selection process and evaluation of Toad for Oracle. We are pretty much content with what we chose.
Using Toad for Oracle
| Pros | Cons |
|---|---|
Like to use Relatively simple Easy to use Technical support not required Well integrated Consistent Quick to learn Convenient Feel confident using Familiar | None |
- Creating database queries.
- Database performance monitoring.
- Export/Import Schemas and Database.
- Running large batch jobs slows down and sometimes hangs Toad for Oracle, causing locks.