James LuiTeam Lead - Oracle Applications DBA at a energy/utilities company
Bryan WrenchSoftware Developer at a tech services company
We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
"The most valuable feature is high availability."
"There are a number of different user interfaces you can choose from."
"The 13cR2 updates to the OEM family, strongly integrate Cloud (off-site, hybrid and on-premise) services providing a seamless way to see all of your resources regardless of where they are deployed."
"The tried and tested services that Oracle provides is second to none."
"The product gives us as much control as we can have by providing a complete picture of the whole set of Oracle products."
"SQL Tuning Advisor, ADDM, Top Activity, ASM Space Manager, Incident Notifications"
"The most valuable features are security and speed."
"This solution allows us to quickly drill down when there are issues."
"The best product for working with Oracle databases for support, checking and loading data."
"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."
"Toad has a lot of features that are very useful, fast, and well developed."
"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."
"A quite simple feature that I have not encountered elsewhere is the "Make Code" feature. I can easily export a complex SQL statement to a programming language. This is a great timesaver as I do not have to type in all of the escape/concatenation characters just to create a SQL statement in C# or C++."
"RMAN tools need improvement."
"There's a lot of documentation to go through as a new user."
"Reporting and statistical charting is largely still left up the end-user to develop custom solutions."
"The solution is considered expensive."
"We would like to have a single dashboard for monitoring and controlling all of our products."
"Patching. It's extremely difficult to determine what requires patching and the process to patch each component is slightly different."
"The user interface is not very interactive. It needs improvement."
"The product is pretty comprehensive, but quite resource hungry. This might be due to the majority of the application seemingly being written in Java."
"There may be an issue with processing limitations but this cannot be confirmed as a problem with the product or with the newest releases."
"The way the dialog boxes appear can be improved."
"I would like to see an improvement in the performance because opening the browser and the editor should be faster."
"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."
"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."
"The pricing is very high."
"Based upon 3 days of implementation by a single person, plus licensing costs would be approximately $60,000, including the virtualized hosts."
"We are satisfied with the pricing."
"There are a few bugs with the software which require opening SRs with Oracle Support which contribute to the day-to-day cost. Perhaps 8 hours per month is spent dealing with support, just as a rough guess."
"There is only the standard licensing fee. There are no other costs."
"Evaluate your requirements carefully. Elaborate DR and HA setup of OEM can become expensive."
"Be careful to only enable the packs for which you have a license as this is an issue we see time and again."
"The solution is inexpensive to purchase."
"There are paid and free-for-use versions of the product."
"The professional edition is about $1,000 AUD ($700 USD) and the developer version is about twice that much."
"In my opinion, this solution is a little expensive, but I understand that good programs cost more money."
"My advice is to try to use the three-year maintenance agreement if possible."
As an IT operations professional, your job is more critical than ever because cloud operations are now a fact of life. For example, you must address the concerns of corporate compliance auditors one minute, and the next minute, deal with end users who signed up for cloud services without consulting you first. So, what are you to do?
Not to worry! Oracle provides a single solution for managing both situations. Oracle Enterprise Manager provides a “single pane of glass” that allows you to manage on-premises and cloud-based IT using the same familiar interface you know and use on-premises every day.
For more information on Oracle Enterprise Manager, visit Oracle.com
With Toad for Oracle, you'll reduce costs and risks by easily ensuring the health and performance of your Oracle Cloud Platform and on-premises databases. ... On the operations side, you can automate administration tasks and proactively manage your databases while embracing performance optimization and risk mitigation.
Oracle Enterprise Manager is ranked 1st in Database Development and Management with 12 reviews while Toad for Oracle is ranked 11th in Database Development and Management with 5 reviews. Oracle Enterprise Manager is rated 8.0, while Toad for Oracle is rated 9.6. The top reviewer of Oracle Enterprise Manager writes "Very helpful to have the ability to enable centralized control & administration of Oracle products from a single console". On the other hand, the top reviewer of Toad for Oracle writes "Enables you to query, develop keys, and execute them to store and retrieve data". Oracle Enterprise Manager is most compared with AppDynamics, Quest Spotlight, Nutanix Era, Quest Foglight for Databases and Zabbix, whereas Toad for Oracle is most compared with Aqua Data Studio. 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.