TrustRadius
Oracle Database, or Oracle RDBMS, is an object-relational database management system.OracleOracle Database for critical workloads that can scale2019-10-17T22:01:43.730ZOracle Database forms the primary database (with MySQL as secondary) that is used for the whole organization. It is used to store both internal data (accounts payable, employee records, etc) as well as used for customer data and analytics data sets.,Oracle Database does security and compliance very well out of the box without the need for much configuration.
It works very well across on-prem and cloud deployments where we want part of the database in-house (due to compliance reasons) while the rest can be in the public cloud.
It is also very good in scaling to large datasets and performance numbers ( time to run a SQL query) are much better than DB2, Microsoft SQL Server etc.,Pricing can be improved to make it much more competitive with other RDBMS options in the space
Best practices documents and deployment scenarios for running Oracle Database on non-Oracle cloud platforms would be helpful (for example Oracle Database on Google Cloud and Microsoft Azure).
Certainly room for better integrated and automated SQL tuning.,9,Positive impact on reducing CapEx by needing one less DBA to manage IT.
Positive impact on the business's compliance and security standards with better auditing due to use of Oracle Database.
Reduced need for upfront database license and hence larger ROI through ability to expand database instances in the Cloud when needed.,No,Microsoft SQL Server, IBM Db2 Big SQL, SAP HANA and Amazon Aurora,Apple iCloud, Google Analytics, Oracle Cloud Infrastructure Compute, Salesforce Commerce CloudAditya MohanImmensely complicated2019-09-23T14:39:26.219ZThe Oracle database is currently used in several places throughout the institute. For starters, it works as our website's back end. We don't store any LOB objects, simply base data types. Similarly, we have developed a handful of custom applications that run on top of Oracle. Each application is a bit unique, but overall the underlying structure isn't too much different from the Website. Lastly, we use Oracle to store one of our largest data provider's information. Currently, this is in the realm of 2 billion rows spread across a small subset of tables.,The database itself rarely goes down.
Bringing up new Oracle instances is relatively painless.
With the help of data pumps, moving data from place to place is a breeze.
If you pay for their support, while they aren't the speediest, they are incredibly well informed and are an amazing help.,Immensely complicated. Of all the databases we use, this one has by far the most moving parts.
It is highly recommended to have a dedicated Oracle DBA on staff if you want your databases healthy. We have no such difficulty with Sybase, SQL Server or SAP IQ.
While the Support Team is incredibly informative, they are often very slow to respond and are often unwilling to answer questions that don't directly solve the problem at hand.,5,Initially, we purchased oracle for our website because it had a much lower licensing cost than Sybase (our dominant DB) for such tasks.
Over time, the level of effort required to keep it up, keep replication working, training and the like turned into a far greater expense than simply paying Sybase the extra licensing.
For us, the Oracle database was a financial disaster.,Yes,,SAP Adaptive Server Enterprise, Microsoft SQL Server, SAP IQ (formerly SAP Sybase IQ)Zhann GoloborodkoThe most resilient database right now!2019-09-18T16:37:04.745ZThe database is very robust and resilient. I like that Oracle is continuously developing and improving it's product.
I work mostly on the enterprise and a lot of HA features. RAC has come a long way from its initial release in 9i and has made my job easier when it comes to troubleshooting and fixing issues. ADG has also come a long way and has resolved a lot of our latency issues and performance issues.,Active data guard is an awesome feature to have. It helps unload your workload for read-only stuff
RMAN backup makes it easy to backup and restore your database
RAC has helped us make our application available 24/7,Log collection when troubleshooting
Grid control is very heavy, we need a lighter version just for monitoring and alert triggering
Tablespace fragmentation management tools should be provided
One item in my wish list is that Oracle would make it easier to collect diagnostic files in one command whenever there's an issue. It takes a lot of time collecting TFA files and ADRCI is not enough,9,24*7 availability is possible
Failover/switchover is easy with DG Broker
Restoring the database is easy,No,Nanie AsedilloOracle Database is Unparalleled2019-09-16T22:41:07.688ZI support the decision-makers in deciding the database platform to use, both on-premise and within the cloud. The databases are usually operational ones (OLTP) for both custom and ERP applications. Some are enterprise data warehouses. All are to solve business decisions usually within a retail or financial vertical.,Complex query - this is true for relational databases but more so for Oracle due to its robust implementation of ANSI-SQL and the relational paradigm for data management.
The various options available within the database are second to none. No one has the same level of partitioning as Oracle does for example.
Even though some other databases have similar capabilities no one can match Oracle RAC to any real degree.,Oracle is slowly moving this was but allowing the database to consume more data repositories and query them all from a single interface would be a great enhancement. Oracle Big SQL has this but is a paid option that sits outside of the database and has access to a small number of repositories (HDFS for example).
Make licensing more easily consumable and client-friendly. This is the biggest bone of contention that is pushing customers from what is a truly great product.,9,It is very expensive to run. This takes away from the businesses bottom line and makes the decision-makers look at other options even though those options are not as well suited for their business needs,No,Oracle PeopleSoft HCM, Oracle JD Edwards EnterpriseOne, Oracle WebLogic Application Server and Oracle Java SE,PostgreSQL, Amazon Redshift, Microsoft SQL ServerRui AmaralOracle Database is the best2019-09-16T18:15:28.712ZOur ERP is running on Oracle Database. We have 11 companies using the database, from the finance department, HR, and supply chain. We have issues with optimization and replicating due to slow links.,OLTP transactions are so very fast. We have 5,000 concurrent users and results are shown so fast.
Compatible with different application vendors and require less configuration. We are using SharePoint, Sales Online, and other applications.
Data replication with ADG is very powerfull and requires less latency. Currently, we have real-time replication without much interference.,Oracle should have a single implementation method for all platforms regardless of different operating systems.
Migration tool for other databases should be quick, without a user interface.
Data cleansing and data validation tools needed.,10,We have been using it for the last 20 years. It has much less downtime and really helps us run the business.
Our business achievements & gains are far more than what we have invested in Oracle Database.
Overall growth of the business has not negatively impacted the business objective, with Oracle Database helping us grow.,Not yet, but I'm interested in Oracle user groups,Microsoft SQL Server,Oracle eBusiness Suite, Oracle Exadata Database Machine, Oracle WebCenter PortalHabeeb AkbarOracle Database Review2019-09-18T22:23:34.713ZOracle Database is the principal database engine for the operations of my company because is a big enterprise, it is managing millions of records of information about final users. Great features combined like Real Application Clusters, Dataguard, and ASM are just a few of the great things that Oracle Database offers. In addition, we are an Oracle partner and deploy Oracle database in the infrastructure of external customers.,Complex engine with powerful flexibility.
Recoverable at the lowest level.
Works worldwide.,SQL plus rendition like in Windows environments.,10,No negative impacts, all positive.,Not yet, but I'm interested in Oracle user groups,,Oracle WebLogic Suite, Oracle Enterprise Manager Cloud Control, Oracle Business Intelligence Cloud ServiceRaul MolinaOracle and Visual Studio 2019... no developer tools yet!2019-09-18T19:48:17.381ZMultiple departments use Oracle and different software use connections to multiple databases that are in Oracle. It allows connectivity with all applications and it's useful for all the reporting tools we have. We can keep all our customer data in one central location.,Oracle allows you to connect to multiple reporting tools.
Oracle has extensive patches and distributes them in a timely manner when they release them.
They can handle multiple databases and hold tons of data history.
It is very reliable and doesn't crash like other products.,SQL Developer lacks functionality that would be useful, like displaying all records at once when you query
SQL Developer crashes a lot and it is buggy. We would love to use it more but it is hard to use at times.
They haven't or don't release Oracle Data tools for Visual Studio 2019. We are almost at the end of the year 2019 and still no data tools yet.
Connection to .NET is kind of complicated and not very easy as compared to Microsoft SQL Server that allows you to connect easier.
Oracle, in general, doesn't compare in terms of use with SQL Server. Data takes a little bit longer to get pulled when you create .Net applications.
Connections have to be opened and closed or else you can end up with multiple connections open. As opposed to SQL Server where it opens the connection and it is closed immediately with very little code.
Oracle doesn't provide many examples of how Oracle implements and interacts with .NET.,8,We don't have to worry much about security because of security encryption.
It can handle large amounts of data and backups are easy to recover.
We can keep historical data for a long time and be sure that the data is secure.,No,Microsoft Visual Studio Code, Sybase Aleri Streaming PlatformFrank LupercioOracle Rocks!!!2019-09-18T18:45:51.176ZWe are using Oracle Database for all of our critical applications for both OLTP and DW usage. It is used across the organization. It provides us a single platform to store all of our critical data and then extract it to use for analytics. It provides us an efficient OLTP database for managing high traffic processing applications,Nice SGA management
Easy to apply profiles on poorly performing SQLs
One platform for both OLTP and analytics,Auto SQL tuning
Better LOB management
XML Processing,10,Positive rate of transaction
Scalable
Fail over safe,Yes,Microsoft SQL Server,Toad for OracleSubrat MishraMy Oracle Database Review2019-09-18T18:18:50.986ZWe use Oracle Database in our department for storing critical data.,Performance is good if we have the right technical resources.
Good analytics functions.
Easy to use.,Built-in querying tools
Make it easy to install/improvements in installing the database.,8,Too many resources to maintain. Once it's installed, it's easy to use so make installation easy.,No,Microsoft SQL Server,Talend Data Integration, Tableau Desktop, Microsoft SQL Serveranand sreeramOracle Database products2019-09-18T17:24:00.921ZOracle Database is used in many of our applications across the whole organization. It provided the backend database processes for many critical applications.,Oracle Database provides stable environments.
High availability, such as RAC, DG.
Great monitor tool and integration with OEM.,Patching process can be improved, such as the online process.
Performance troubleshooting should be made easier.,10,It meets our business objectives with its great functionalities.
HA and scalability are great features.,Yes,,Oracle eBusiness Suite, Oracle SQL Developer, Oracle Enterprise ManagerJohn TaoOracle Database Rocks2019-09-17T21:09:38.721ZWe use the database for many OLAP and OLTP applications. The database works really great. The error messages could be more informative, however.,Very robust.
Works great if initial set-up is done correctly.,Error messages that are displayed can be improved.
Need to improve performance tuning.,9,It's all been great so far.,Yes,,EndecaPradeep VattemThe Best Choice For Our Company2019-09-17T20:08:08.648ZWe used Oracle Autonomous Data Warehouse for our industry in retail and banking because we need the best performance and a high level of security.,Scaling.
Integration.
Security.,Commercial department.
Bank opportunity.
Unique client target.,8,Time to market.
Fast delivery.,No,Oracle Big Data Cloud Service, Kubernetes and HPE ProLiant MicroServerAndres PeraltaOracle Database Review2019-09-17T18:30:46.632ZOracle Database is being used by our accounting department as well as for our customer service solution and customer experience department. It helps with billing and service connect/disconnect for our city in terms of efficiency with other organizations.,Oracle helps keep our customer information safe. It contains very strong security standards and good encryption of sensitive data for PCI compliance.
It works well with other products like SSRS reporting tools and .Net applications.
Another strength of Oracle is that we receive updates and great customer support if we have problems.
Training is also a plus. Oracle offers many options and they are supported by many training facilities all over the US.,I would like to see more compatibility with .Net, it doesn't quite compare with SQL Server but it is getting there. I would like to see more samples or support with applications the same way that SQL Server does. You can find tons of examples on the web but not as many Oracle examples.
Oracle offers a free SQL Developer tool it is quite nice and simple, however, it is kind of buggy and doesn't offer some features that can be helpful.
You should be able to have an option to go directly to the last record of a query. Instead you have to scroll down over and over until you reach the end of your last record. If your query retrieves 250,000 records you have to scroll for a long time. A button that sends you to the last record would be very useful.
Also, SQL Developer should allow you to drag and drop your column header from the data results view. In case you want to re-write your query and use fewer columns and you have to type this column again. If the column is listed below on your results you should be able to drag and drop the column name to your query.
SQL Developer should also be able to retrieve or create a DLL based on a function or a query. It is not very easy to do this.,8,Positive,No,Microsoft SQL Server,Microsoft Visual Studio Code, dbForge Data Generator for SQL ServerFrank Lupercio#1 Database on the market!2019-09-30T23:25:00.756ZWe have over 40 Applications running on Oracle Database. Oracle Database is used by the entire organization in dev, test, staging, training and production environments. I can't, unfortunately, go into details of the business problems it addresses.,Oracle Database Security - #1 on market - Database Vault, Transparent-Data-Encryption (TDE), Audit Vault, Label Security, User Security, Fine Grain Auditing, SQL Injection, Network Encryption, Virtual Private Database (VPD), and etc.
RMAN backup/restore.,Oracle CPU patching - A nightmare to manually deploy it to every single database every quarter.
In OEM, there are limited functionalities for SQL server.
SID limited to 8 characters.,10,I can't image our applications running without Oracle database - a relational database is a must to store data, especially with many features provided by Oracle and keeping improving and enhancing.
No negative impact I can think of.
The multi-cloud innovation will keep our databases running in Oracle.,No,Microsoft SQL Server,Oracle SQL Developer, Oracle Enterprise ManagerVerified UserOracle Database - They are expensive for a reason2019-09-19T22:13:29.613ZOracle database is the primary backend data storage software at the client. Multiple instances installed across the network support both custom-built applications and Oracle’s applications like OID and OBIEE.,Redundancy and High Availability via grid setup has a proven track record in securing data availability across applications
Speed of data access across the network is another critical point in which Oracle consistently outperformed others
Support from Oracle is another reason for clients to keep Oracle databases,Oracle databases have started coming in different flavors, from express to enterprise, but a consolidated management tool that can cater to an enterprise can be improved.,9,While Oracle has increased the operational costs of implementing its products, customers usually get peace of mind in terms of stability and usability,No,Verified UserOracle Database for the Public Sector2019-09-17T20:03:08.633ZWe use Oracle databases on a daily basis to manage USDA AMS and APHIS data for internal and public usages.,Data management
Data quality
Data integration
Performance,New AI and ML features.
More tools for data analytics.
More integration with VMWare, Azure Clouds, and free performance tuning tools.,9,ROI needs to be justified with longer years.
Performance is much better than SQL server.
More performance tuning features compared with its competitors.,Yes,,Microsoft SQL Server, Oracle Java SEVerified UserOracle Database is the most secure2019-09-17T19:02:52.258ZWe currently use Oracle Database to store business data. Oracle Database is more secure and stable than Postgres or MySQL. It has good replication support, which I think makes it stand out from the other products.,Relational Database Management System
Great support
Very stable and reliable solution as compared to other platforms,From a security perspective, there are lost of patches that come at long intervals. Would like to see them released more frequently.
Not happy with the current version, quite a few bugs
Data security - with how the data is stored. This solution doesn't have a lots of encryption options. We have to pay for additional add ons and isn't as competitive with new technology.,5,Great database, it has all complexity needed to support the environment.,No,MySQL,KeepSolid OEM VPN UnlimitedVerified UserOracle Database, bringing it back.2019-09-16T18:28:07.977ZOracle Database supports critical OLTP and OLAP environment. The database performance and security is the key aspect of our organization, as we deal with customer data. Oracle perfectly matches the business challenge in this.,Performance
Security,Stability,8,Oracle support - support time is very slow, staff knowledge is lacking, and often support staff doesn't know the products. We get passed around too many support staff during the support process.,Yes,Oracle WebLogic Application Server and Oracle Exadata Database Machine,MongoDB, dbForge Data Compare for MySQLVerified UserOracle Database Review2019-10-14T00:21:53.442ZOracle Database is being used by all Oracle Utility Applications and is a single option for all data needs. The Oracle Exadata Hardware with Oracle Database helped with a lot of performance issues and dealing with terabytes of data.,High performance.
Robust.
Excellent support for all kinds of integration.,Documentation needs to be better.
Compatibility.
Costs.,8,Performance.
Stable.
Licensing complexity.,No,,Oracle Service Bus, Oracle BI Foundation Suite, Oracle Access ManagementVerified UserDatabase Administrator Review of Oracle2019-09-19T16:08:02.342ZOracle Database is used as our OLTP databases. It is being used by a couple of departments at my company.,Autonomous database
Exadata
RAC,Big data
Data Analytics
ERP,9,Oracle is expensive
More efficient,Not yet, but I'm interested in Oracle user groups,Microsoft SQL Server and Teradata Database,Microsoft SQL Server, Teradata Data Warehouse Appliance, PostgreSQLVerified UserThe Oracle Way2019-09-18T19:35:38.399ZOracle Database is being used for applications used by different business units across the organization.,The database is extremely fast compared to other databases we evaluated.
Queries can be easily diagnosed with different toolsets that Oracle provides. You need to have experience to read it, but once you are able to, the information is valuable to decide what options to improve SQL performance.
SQLPlus is essential for me to easily create dynamic or run-time queries to be executed in the Oracle Database.,The information from the Oracle toolsets to diagnose performance can be a bit daunting if you do not know what to look for.
It would be cool to easily identify issues such as stale indexes, missing indexes, etc. with a click of a button. The execution plan should show that issue easily.,8,Queries are much more efficient compared to the other databases we reviewed.
The business units using our application are extremely happy with the performance of the Oracle Database product.,No,PostgreSQL and SQL Data Warehouse,Red Hat JBoss Enterprise Application Platform, Amazon RedshiftVerified UserPowerful tool for business users2019-09-18T19:09:31.981ZOracle Database is great. We work with it every day and it's an important tool to provide value & info to our senior management. I manage a 20 person team and we are intensive users. We have to extract and process profitability information for reports, quickly. We know we can trust it and that our information is safe and easily accessible.,We have our really sensitive information and we trust our information is secure.
It's fast, and we need that for our everyday work.,The Oracle client could have some discovery tools, like graphic reports
We could use some machine learning capabilities
It would be great if we could generate some graph directly from the client tools,10,Positive: we have all our key data and indicators.
Positive: it makes our work easier.
Positive: the speed that it provides allows us to trust in the performance.,No,MySQLVerified UserReview from Oracle Open World2019-09-18T18:54:00.035ZOracle Database is used across the whole organization. We use it for data collections and index calculations for various in-house government programs. We also have front end applications written in Java using Oracle Database.,Very strong relational database
Easy to maintain
Access to support 24/7,Should be able to create temporary tables, like we do in Sybase, dynamically inside code,10,User-friendly products.,Yes,Redgate SQL Data Compare, Redgate SQL CompareVerified UserOracle Review 12.22019-09-18T17:39:46.988ZOracle Database helps our mission-critical operations run safely and securely flawlessly. Security and the availability of our data are our main goals while running daily operations. Oracle provides the right tools and technologies that help me to run databases with peace of mind.,Safeguarding database - with Oracle advanced security features
Oracle encryption helps point to point data safety
Backup tools, such as RMAN, helps with faster backup and recovery,Better error logging
Data compression
Easier monitoring
Poor Tech Support,9,Robust and secured RDBMS with better and faster recovery.,Yes,MySQL,VMware Fusion, Azure SQL Database, dotConnect for MySQLVerified UserThe database that you can trust.2019-09-18T17:10:31.539ZThe organization uses Oracle Database to store and process day-to-day transactions. The database is used by most areas of the business to perform the end to end business process. We've been using Oracle products for the past 5 years or so and find it reliable.,The system is stable and helps the business function without interruption.
Highly scalable, thus provides the expected results when the business needs it.
Lower maintenance overhead due to its robustness.,Autonomous capabilities in an on-prem system may help the business achieve higher efficiencies.,9,You can always rely on Oracle Database's ability to support enterprise systems with large data sets.,Yes,,Microsoft SQL Server, Oracle Business Activity MonitoringVerified User
Unspecified
Oracle Database
725 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
