Oracle Coherence is database management and development software.
N/A
Toad Database Developer Tools
Score 8.0 out of 10
N/A
Toad by Quest is a database management toolset that database developers, administrators and data analysts use to simplify workflows, create code free from defects, automate frequent or repetitive processes, and minimize risks. Editions include Toad for Oracle, which automates administration tasks and helps proactively manage databases while embracing performance optimization and risk mitigation. Similar editions exist for IBM DB2, SQL Server, SAP, or MySQL and Postgres environments (Toad Edge).
$229
per year
Pricing
Oracle Coherence
Toad Database Developer Tools
Editions & Modules
No answers on this topic
Toad Edge For MySQL
$229
per year
Toad Edge For Postgres
$229
per year
Toad for SQL - Pro Edition
$437
per year
Toad for Oracle - Base Edition
$550
per year
Toad for DB2 z/OS - Base Edition
$636
per year
Toad for SAP - Base Edition
$636
per year
Toad for SQL - Xpert Edition
$763
per year
Toad for Oracle - Professional Edition
$829
per year
Toad for SQL - Dev Edition
$930
per year
Toad for DB2 z/OS - Pro Edition
$996
per year
Toad for Oracle - Professional DB Admin Edition
$1,370
per year
Toad for DB2 z/OS - Xpert Edition
$1,529
per year
Toad for SAP - Xpert Edition
$1530
per year
Toad for Oracle - Xpert Plus Edition
$1,753
per year
Toad for DB2 z/OS - Dev Edition
$1,861
per year
Toad for SAP - Dev Edition
$1863
per year
Toad for SAP - Xpert+ Edition
$2099
per year
Toad for SAP - DBA Edition
$3661
per year
Offerings
Pricing Offerings
Oracle Coherence
Toad Database Developer Tools
Free Trial
No
Yes
Free/Freemium Version
No
No
Premium Consulting/Integration Services
No
No
Entry-level Setup Fee
No setup fee
No setup fee
Additional Details
—
—
More Pricing Information
Community Pulse
Oracle Coherence
Toad Database Developer Tools
Features
Oracle Coherence
Toad Database Developer Tools
Database Development
Comparison of Database Development features of Product A and Product B
Oracle Coherence
8.7
Ratings
2% above category average
Toad Database Developer Tools
8.5
Ratings
0% below category average
Version control tools
9.00 Ratings
8.90 Ratings
Test data generation
8.20 Ratings
6.00 Ratings
Performance optimization tools
9.30 Ratings
9.00 Ratings
Schema maintenance
9.00 Ratings
9.00 Ratings
Database change management
8.00 Ratings
9.50 Ratings
Database Administration
Comparison of Database Administration features of Product A and Product B
It literally all boils down to the budget a team has. Nowadays, even investment banks look for every opportunity to cut cost. Oracle Coherence is a pretty robust and highly configurable cache application that every team should use if they can afford. If they can't, then open source code is their answer.
Well suited for development of stored procedures, packages, running scripts, and each and every DBA operation. Not very well suited for quick and simple querying. Toad seems to be overkill for simple things. Also, it's not very well suited for non-Oracle developers, who might be scared of by the endless amounts of options, tools and windows that Toad offers.
I appreciate the library feature that enables me to label and store previously created statements. These are saved off to a network share for future use.
I also really like the describe function that lists all fields in a table. This helps as I build new queries.
I wish I was better at using the tuning function. I have seen others use it and am very impressed with the graphical depiction of query costing.
The date/time settings in Toad are kind of difficult to figure out. I have to use an ALTER SESSION command to format the dates so I can actually query date/time fields.
It seems to be updated too often. I get notifications very frequently about new versions being available.
I give is an 8 because nothing is a 10 and there is always room for improvement. I believe the user who is not as technologically inclined would be better suited with an easier way to identify the options for setting the layout up for Toad's GUI. To some it is very cumbersome and confusing.
Oracle Coherence support team is responsive and knowledgeable. We contacted them to ask a couple of design questions about how we were setting up Oracle Coherence based on how we used IBM's Datapower Extreme Scale. They were able to guide us so that we got the design correct the first time and didn't have to go back and re-architect our design later.
I give the overall support for Toad for Oracle a 10/10. This is because whenever there has been an issue with this software, our team has got an immediate response. The same can not be said for similar software. The most recent example of this is when we needed to renew our licenses. Some employees were unable to log in to code with the given license key. Support was able to resolve the issue quickly.
Coherence kicks Redis's butt when it comes to performance and feature set. However, it lags far behind in terms of market penetration and cloud readiness.
We didn't make a decision of choosing one and dropping the other. Our database guys have their own preference of tools. Since SQL Developer is a free-to-use tool and light weighted tool, we used it for education materials. For those who need advanced functions, database administrators for example, we bought an enterprise license of Toad and distributed them to developers. For enterprise level of analytics running Oracle based databases, I believe SQL Developer and Toad are two basics and safe choice to start with, unless one has very particular need (or preference).
Quick and easy query development helps reduce man-hours in a project which converts to real dollars.
Query analysis and tuning result in low database overhead and low latency, thus translating into real dollars because a system can thus handle more requests from customers.
Ease of use makes it easy to deploy greenhorns in projects with minimal training, thus helping save money. Otherwise menial and simple jobs would have required experienced DBAs.
