TrustRadius
Oracle Database, or Oracle RDBMS, is an object-relational database management system.Oracle Database for critical workloads that can scaleOracle 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 CloudImmensely complicatedThe 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)The most resilient database right now!The 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,Oracle Database is UnparalleledI 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 ServerOracle Database is the bestOur 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 PortalOracle Database ReviewOracle 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 ServiceOracle and Visual Studio 2019... no developer tools yet!Multiple 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 PlatformOracle Rocks!!!We 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 OracleMy Oracle Database ReviewWe 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 ServerOracle Database productsOracle 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 ManagerOracle Database RocksWe 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,,EndecaThe Best Choice For Our CompanyWe 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 MicroServerOracle Database ReviewOracle 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 Server#1 Database on the market!We 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 ManagerOracle Database - They are expensive for a reasonOracle 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,Oracle Database for the Public SectorWe 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 SEOracle Database is the most secureWe 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 UnlimitedOracle Database, bringing it back.Oracle 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 MySQLOracle Database ReviewOracle 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 ManagementDatabase Administrator Review of OracleOracle 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, PostgreSQLThe Oracle WayOracle 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 RedshiftPowerful tool for business usersOracle 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,MySQLReview from Oracle Open WorldOracle 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 CompareOracle Review 12.2Oracle 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 MySQLThe database that you can trust.The 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 Monitoring
Unspecified
Oracle Database
725 Ratings
Score 8.7 out of 101
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>

Oracle Database Reviews

<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener noreferrer'>Customer Verified: Read more.</a>
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>
Score 8.7 out of 101

Do you work for this company?

Show Filters 
Hide Filters 
Filter 726 vetted Oracle Database reviews and ratings
Clear all filters
Overall Rating
Reviewer's Company Size
Last Updated
By Topic
Industry
Department
Experience
Job Type
Role

Reviews (1-25 of 71)

Companies can't remove reviews or game the system. Here's why.
Aditya Mohan profile photo
Score 9 out of 10
Vetted Review
Verified User
Review Source
Oracle 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.
Oracle Database is suited for for scenarios where the database is large and there is a need for reliability, security and availability at scale. The pricing reflects this. It won't be well suited and will be expensive for mostly dev and test environments or where reliability is not a factor or issue.
Read Aditya Mohan's full review
Zhann Goloborodko profile photo
September 30, 2019

Immensely complicated

Score 5 out of 10
Vetted Review
Verified User
Review Source
The 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.
While Oracle is more or less a bulletproof database server, if you don't have an Oracle DBA on staff you are in for a lot of trouble. We use Oracle, Sybase, SQL Server, and SAP IQ. Of the 4, Oracle is the most painful to troubleshoot when things get weird. Now, if you do have Oracle DBA's on staff, Oracle is a perfectly good database solution, but I can't say that it is in any way better than Sybase and I would say it is a touch less reliable that SQL Server.
Read Zhann Goloborodko's full review
Nanie Asedillo profile photo
Score 9 out of 10
Vetted Review
Verified User
Review Source
The 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
It is the most resilient database that I've used.
Read Nanie Asedillo's full review
Rui Amaral profile photo
Score 9 out of 10
Vetted Review
Reseller
Review Source
I 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.
Oracle Database is well suited for practically any data store. The hardest portion though is using large objects, such as images, and being able to query those objects.
Read Rui Amaral's full review
Habeeb Akbar profile photo
September 16, 2019

Oracle Database is the best

Score 10 out of 10
Vetted Review
Verified User
Review Source
Our 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.
Oracle database is a perfect choice when customers have Oracle hardware and they're looking for relaible OS like Linux and Solaris. Customers who have Oracle applications will find appropriate to have Oracle Database due to single point of support and fewer resource requirements to maintain the data.
Oracle Database will be less appropriate for customers who have a smaller budget and hardware with slower performance.
Read Habeeb Akbar's full review
Raul Molina profile photo
September 18, 2019

Oracle Database Review

Score 10 out of 10
Vetted Review
Reseller
Review Source
Oracle 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.
I would recommend it for telecommunication companies due to the volume of information managed by these companies.
Read Raul Molina's full review
Frank Lupercio profile photo
Score 8 out of 10
Vetted Review
Verified User
Review Source
Multiple 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.
Well suited for large data and for complex applications. It is great, secure, and support, in general, is good.

Not well suited for small companies (cost) and for home projects. There is not a smaller version of Oracle available for home use like SQL Server. You can find many free options for your home or small business without having to pay thousands of dollars compared to Oracle.
Read Frank Lupercio's full review
Subrat Mishra profile photo
September 18, 2019

Oracle Rocks!!!

Score 10 out of 10
Vetted Review
Verified User
Review Source
We 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
Oracle is mostly good for OLTP based transactions. I see it is limited for the micros service, but I am still exploring that area. Invisible column and identity columns are well used in my applications.

A little more effort on making SQL Developer a better tool could drive the usage a lot more.
Read Subrat Mishra's full review
anand sreeram profile photo
September 18, 2019

My Oracle Database Review

Score 8 out of 10
Vetted Review
Verified User
Review Source
We 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.
It's suited to hosting a large volume of data. It has good performance but lacks good querying tools.
Read anand sreeram's full review
John Tao profile photo
September 18, 2019

Oracle Database products

Score 10 out of 10
Vetted Review
Verified User
Review Source
Oracle 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.
Oracle database is the best in the industry for database management.
Read John Tao's full review
Pradeep Vattem profile photo
September 17, 2019

Oracle Database Rocks

Score 9 out of 10
Vetted Review
Verified User
Review Source
We 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.
It is very good for applications where you have OLAP and OLTP's.
Read Pradeep Vattem's full review
Andres Peralta profile photo
Score 8 out of 10
Vetted Review
Verified User
Review Source
We 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.
It's a very good tool if you need high performance and security.
Read Andres Peralta's full review
Frank Lupercio profile photo
September 17, 2019

Oracle Database Review

Score 8 out of 10
Vetted Review
Verified User
Review Source
Oracle 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.
Well suited for a large-sized company and large data storage. Less appropriate for a home or small company due to the cost.
Read Frank Lupercio's full review
No photo available
September 30, 2019

#1 Database on the market!

Score 10 out of 10
Vetted Review
Verified User
Review Source
We 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.
Large scaled, complex, and/or mission-critical applications are well suited to use Oracle Database whether it is OLTP or Data Warehouse. Some COTS software may prefer to use other vendor databases, such as SQL Server. I have also seen vendors use SQL server as metadata repositories for their software.
Read this authenticated review
No photo available
Score 9 out of 10
Vetted Review
Verified User
Review Source
Oracle 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.
Enterprise data management is where Oracle really shines. While open source databases come in handy for smaller environments, Security and Availability are what keep Oracle databases above the competition.
Read this authenticated review
No photo available
Score 9 out of 10
Vetted Review
Verified User
Review Source
We 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.
Oracle Database is a little bit more pricey, and as cost-effective. They should involve and provide more free support on Java and MySQL and other freeware that integrated with Oracle databases.
Read this authenticated review
No photo available
Score 5 out of 10
Vetted Review
Verified User
Review Source
We 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.
Oracle Database is more of a relational database and helps to maintain and integrate data. Would be great for organizations using and processing large amounts of data.
Read this authenticated review
No photo available
Score 8 out of 10
Vetted Review
Verified User
Review Source
Oracle 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
Performance challenges and existing transformation. If you have a new business challenge, it has all the features that you need, very feature rich.
Read this authenticated review
No photo available
October 13, 2019

Oracle Database Review

Score 8 out of 10
Vetted Review
Verified User
Review Source
Oracle 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.
Oracle Database is suited for large data handling and is not suited for medium or low data handling.
Read this authenticated review
No photo available
Score 9 out of 10
Vetted Review
Verified User
Review Source
Oracle 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
If you have two active nodes and each node is in a different location, Oracle has a different solution for it. Oracle Database with Exadata is the best solution for an OLTP or OLAP system.
Read this authenticated review
No photo available
September 18, 2019

The Oracle Way

Score 8 out of 10
Vetted Review
Verified User
Review Source
Oracle 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.
From the databases we evaluated, the Oracle Database was more efficient and effective in running our application.
Read this authenticated review
No photo available
Score 10 out of 10
Vetted Review
Verified User
Review Source
Oracle 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
It can handle enormous amounts of information and we can be sure that the processing will be fast enough. Our company deals with large volumes of information.

It would be great if we could have some graph reports with no need for additional tools so we could avoid to having to develop new tools for reports.
Read this authenticated review
No photo available
Score 10 out of 10
Vetted Review
Verified User
Review Source
Oracle 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
Well suited for running applications using large amounts of data.
Read this authenticated review
No photo available
September 18, 2019

Oracle Review 12.2

Score 9 out of 10
Vetted Review
Verified User
Review Source
Oracle 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
Great database security features, but has upgrade issues.
Read this authenticated review
No photo available
Score 9 out of 10
Vetted Review
Verified User
Review Source
The 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.
Best suited for enterprise-class systems. Less appropriate to be containerized if the code lives in the database.
Read this authenticated review

About Oracle Database

Oracle Database, or Oracle RDBMS, is an object-relational database management system.
Categories:  Relational Databases

Oracle Database Integrations

Oracle Database Technical Details

Operating Systems: Unspecified
Mobile Application:No