We performed a comparison between Oracle Enterprise Manager and Toad for Oracle based on real PeerSpot user reviews.
Find out in this report how the two Database Development and Management solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."It is the best monitoring tool for Oracle databases."
"Oracle Enterprise Manager is a scalable solution."
"There are a number of different user interfaces you can choose from."
"Oracle Enterprise Manager helps to control servers."
"The most valuable features of Oracle Enterprise Manager are the data guide and online monitoring."
"It's easy to implement as it's made by Oracle for Oracle."
"It is a comprehensive, end-to-end solution for managing database consolidation, something that has been missing and difficult to do."
"I like that it's stable."
"The most valuable feature is the navigation within the UI, where you can right-click on an object in an SQL query and go right to it, versus going through all of the menus to find what you are looking for."
"Simply the best GUI software for administration is the most valuable aspect for me."
"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."
"Toad for Oracle has proven to be better than other tools since we have never experienced any crashes."
"I find Toad easy to use and I love the Workspace feature, which allows me to set up projects so that I can open SQL files applicable to what I am working on at any particular time."
"Oracle has advanced query optimization and tuning features that help improve the performance of SQL queries."
"It is very easy to manage all of the objects."
"Toad has a lot of features that are very useful, fast, and well developed."
"I rate Oracle Enterprise Manager six out of 10 for affordability. It's expensive."
"They should improve the hover text context. This would provide assistance whenever a task is attempted by a DBA."
"It needs to support the Database versions lower than 10.2."
"We have encountered performance issues when the load is huge."
"Reporting and statistical charting is largely still left up the end-user to develop custom solutions."
"Oracle Enterprise Manager's scalability is an area with certain shortcomings where improvements are required."
"The solution's agents work with Java, and the Java code sometimes consumes a lot of memory on the CPU."
"The product must improve its support team."
"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."
"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."
"An area where the solution could use some improvement is in terms of user-friendliness. During the initial setup phase, the solution was not very intuitive when attempting to establish connections."
"Sometimes it works in some areas, but in others, it doesn't. Like when you copy, you find that it's blank and doesn't copy anything. So, there are some objects that do copy, and sometimes they don't."
"There should also be a better "cancel query" option as sometimes one cancels a query, but then it still might run for a long time, and then one has to crash Toad in order to cancel the query."
"In future releases, the product can be more intuitive. It has to be lighter than what it is because sometimes it is not responding quickly. If I do some features at the same time, it's not supporting. I have to wait sometimes to get the action. It's dependent on the resources of the workstation, but it has to be improved in this area. The faster processing is needed."
"There may be an issue with processing limitations but this cannot be confirmed as a problem with the product or with the newest releases."
"Toad for Oracle does not have a particular resolution within the application."
Oracle Enterprise Manager is ranked 1st in Database Development and Management with 122 reviews while Toad for Oracle is ranked 3rd in Database Development and Management with 15 reviews. Oracle Enterprise Manager is rated 8.4, while Toad for Oracle is rated 8.8. The top reviewer of Oracle Enterprise Manager writes "Provides good stability and has an easy implementation process". On the other hand, the top reviewer of Toad for Oracle writes "Advanced query optimization and tuning features ". Oracle Enterprise Manager is most compared with Zabbix, Quest Spotlight, Dynatrace, Quest Foglight for Databases and Nagios XI, whereas Toad for Oracle is most compared with Toad Edge, Aqua Data Studio, DbVisualizer, Redgate SQL Toolbelt and Quest Foglight for Databases. See our Oracle Enterprise Manager vs. Toad for Oracle report.
See our list of best Database Development and Management vendors.
We monitor all Database Development and Management reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.