Working with Oracle Database made easy
Ravinder Gupta | TrustRadius Reviewer
January 17, 2019

Working with Oracle Database made easy

Score 10 out of 10
Vetted Review
Verified User
Review Source

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
Toad for Oracle is very well suited for all Oracle implementations, be it single instance or RAC. It is best suited for use of Oracle DBA, Developer and Database Engineers.

I don't recommend Toad for Oracle for Project Managers or Solution Architects. This can be a pricier choice for these people. They can do fine with free options like SQL Developer.

Toad for Oracle Feature Ratings

Test data generation
6
Performance optimization tools
8
Schema maintenance
9
Database change management
9
User management
9
Database security
9
Database status reporting
9
Change management
9

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

Easy-to-use interface.
Color scheme for SQLs and PL/SQL codes.
ProsCons
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.