Best Relational Database- Oracle Database
I have used this Database for storing and retrieving the data for a web application. As it is a relational database management system and …
Overview
What is Oracle Database?
Oracle Database, currently in edition 23c, offers native support for property graph data structures and graph queries. If you're looking for flexibility to build graphs in conjunction with transactional data, JSON, Spatial, and other data types, we got you covered.…
Recent Reviews
Awards
Products that are considered exceptional by their customers based on a variety of criteria win TrustRadius awards. Learn more about the types of TrustRadius awards to make the best purchase decision. More about TrustRadius Awards
Reviewer Pros & Cons
- In memory feature - very fast. Earlier queries used to run in fetching data used to take time now it is very fast. We can even select which table shou...
- Oracle Database restoration and recovery is complex. RMAN backup recovery has quite a lot of steps and is complex. In other databases, it is very much...
Pricing
N/A
Unavailable
What is Oracle Database?
Oracle Database, currently in edition 23c, offers native support for property graph data structures and graph queries. If you're looking for flexibility to build graphs in conjunction with transactional data, JSON, Spatial, and other data types, we got you covered. Developers can now easily build…
Entry-level set up fee?
- No setup fee
Offerings
- Free Trial
- Free/Freemium Version
- Premium Consulting/Integration Services
Would you like us to let the vendor know that you want pricing?
167 people also want pricing
Alternatives Pricing
What is Microsoft SQL Server?
Microsoft SQL Server is a relational database.
What is TeamDesk?
TeamDesk is a low-code development platform for online database creation. Business owners or managers can build a unique web database solution without any programming to facilitate working with data, organize routine work and create an accessible data source for teams.
Product Details
- About
- Competitors
- Tech Details
- FAQs
What is Oracle Database?
Oracle Database, currently in edition 23c, offers native support for property graph data structures and graph queries. If you're looking for flexibility to build graphs in conjunction with transactional data, JSON, Spatial, and other data types, we got you covered. Developers can now easily build graph applications with SQL using existing SQL development tools and frameworks.
Oracle Database Video
Oracle's Converged Database
Oracle Database Competitors
- PostgreSQL
- MariaDB Platform
- Microsoft
Oracle Database Technical Details
| Operating Systems | Unspecified |
|---|---|
| Mobile Application | No |
Frequently Asked Questions
Oracle Database, currently in edition 23c, offers native support for property graph data structures and graph queries. If you're looking for flexibility to build graphs in conjunction with transactional data, JSON, Spatial, and other data types, we got you covered. Developers can now easily build graph applications with SQL using existing SQL development tools and frameworks.
PostgreSQL and MariaDB Platform are common alternatives for Oracle Database.
Reviewers rate Support Rating highest, with a score of 10.
The most common users of Oracle Database are from Enterprises (1,001+ employees).
Comparisons
Compare with
Reviews and Ratings
(1191)Attribute Ratings
Reviews
(51-75 of 178)Companies can't remove reviews or game the system. Here's why
September 18, 2019
Johnny Rotten's Oracle Database Review
Oracle Database 12c is being used to store data which is used to process and pay benefits for Canadian military veterans. It is used by the entire organization to provide services and financial support to still serving and released soldiers.
- It is able to store large amounts of data in a structured environment making complex development and maintenance more manageable.
- It is able to perform large and complex queries required for display in front-end systems, for reporting purposes and for trouble-shooting. Oracle functions, procedures, and packages are very useful in developing complex functionality for display and input on the client-side.
- It is very transparent; the data is easy to access, see and understand, which is significant for troubleshooting and maintenance.
- Upgrades have been relatively painless.
- SQL Developer is missing some of the easy to use GUI tools used to check dependencies, grants and synonyms, and other simple DBA functions used by developers.
- SQL Developer interface is slow, and code completion assistant is unresponsive at times.
- I would like to see a cleaner way to process data results without re-retrieving data in cursors. We are currently using object types.
September 18, 2019
Review of Oracle Database 12c
We have multiple in-house developed systems using Oracle 12c Databases deployed at multiple levels.
- Allows fast retrieval of large amounts of data.
- Stores many gigabytes of digital images.
- Is easy to maintain and restore.
- The developer tools packaged with 12c require some enhancements for speed and stability.
September 18, 2019
Oracle Database 12c Review
We use it in a persistence layer. It does what databases do.
- Document-based database persistence
- Indexing
- Distributed database
- Sharding, etc.
September 18, 2019
Oracle Review 12.2
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
September 18, 2019
12c works great for online processing
We use it across the organization. We use Oracle Database 12c to store large amounts of customer hardware repair data. It scales very well for our company's needs.
- JSON support
- Heavy online transaction support
- Overall online support
- Unstructured data
- Easier tools for developers to analyze database performance
September 18, 2019
Oracle Database products
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.
September 18, 2019
Great Performance at a Price Point
Oracle Database 12c is being used across our whole organization. For example, the HR department uses the database to keep track of various details about the employees such as compensation benefits. Our core development team is using it to store all of the user data coming from our commercial web solutions.
- Active Data Guard does a great job of ensuring data protection, disaster recovery, and high availability. These features allow Oracle Database 12c to be a reliable solution.
- OLAP is fairly simple and easy to use allowing users to quickly create analytical graphs and calculations for business intelligence.
- The wide variety of partitioning options allow users with all types of use cases to increase availability/performance and decrease costs of maintaining Oracle Database 12c.
- Licensing and compliance agreements need to be a bit more direct and precise. Many important details are written in the fine print and are easily overlooked.
- There is a lack of first-party documentation for the product. Often times, I see myself referring to third-party sources to find the solutions to my queries.
- Compared to many other database solutions out there, Oracle tends to be a bit expensive. Pricing models should be adjusted according to the competition.
September 18, 2019
The 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.
September 18, 2019
My Review of Oracle Database
We are largely into Oracle Database 12c. We have our legacy data mart build using Oracle Database. It is used mainly by the enterprise information system, i.e. my team and application development team. All of our data-related issues are addressed since our data warehouse is built on top of Orcale.
- My main work is creating procedures and code using Oracle. This comes handy when we have to house the data from different source systems in our data warehouse.
Oracle Databases are used across our development department for many applications. This is the primary data source for almost all of our applications. Our problem was where we stored the data and this addresses that issue.
- Oracle 12c Database introduced and expanded a number of JSON management tools that have helped with integration with REST APIs.
- Oracle Databases provide a number of functions and tools for efficiently retrieving data, even with complex data structures.
- Oracle 12c Databases have a number of different management tools that make fine-tuning performance and troubleshooting application issues more effective.
- Although 12c did introduce several JSON utilities, there is still room for ways to improve the usability of JSON in tables. I believe this has been addressed more in later releases.
September 18, 2019
Must for mission critical workloads where downtime will cost you money
It's our main production database which is used company-wide by a number of applications.
- Auditing and debugging compared to other databases and the ability to go to a point in time using the ASH and see what was going on in the database is very useful.
- Oracle flashback, the ability to restore a table to a point in time without having to restore from a backup, is helpful. Also, the ability to see how a row has changed over time is great.
- APEX, which comes free for developing front end user applications.
- The ability to use online re-def for tables that have identity columns would be very useful.
- Native support for CQN queries in APEX.
September 18, 2019
Oracle Database 12c works for me
The database is being used across the entire organization. It is used to host all of the data for our homegrown software solutions. In addition, it is used to host our data warehouse and integrate the data between all of our enterprise applications. Oracle Database is used along with PL/SQL interfaces and Oracle SOA Suite.
- Oracle Database 12c makes the development of REST Endpoints through the use of ORDS extremely easy, making for faster development
- Oracle Database 12c makes it easy to store and retrieve data as well as integrate different systems and keep data flowing between systems.
- Oracle Database 12c has a very strong PL/SQL interface which makes writing the business logic into the back end of our applications fast and easy.
- Oracle Database 12c has some bugs which sometimes make it difficult to tune queries and improve the performance of our applications.
- Oracle Database 12c has a very robust and complicated interface which makes it powerful but difficult to train new employees on how to use.
- PL/SQL is a proprietary programming language for Oracle Database which makes it difficult to find knowledgeable job candidates fresh out of college.
September 18, 2019
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.
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
September 18, 2019
Oracle DBs
In our environment, we use Oracle Database from 10g until 18c. The product is stable and supporting critical applications across our whole environment. We are challenged with onboarding new versions to our portfolio.
- Stability
- Reliability
- License model
September 18, 2019
My experience with the new Oracle 12c
Oracle 12c is being used by DIR to create relational databases for transmission of CA workers comp claims. We use it to manage data regarding any occupational illness or injury. This includes doctors, patients, injury, and prescription information. We then run reports on the data to get analytics on various things like opioid usage and the amount of injured employees in California in a given month.
- New bug fixes
- Easy for structure design
- Easy to switch from older Oracle versions
- The current private/public cloud options are very black/white
- Performance was lacking in some cases as wait times increased
- In moving to 12c, there was a lot of workarounds needed for our current system to be fully functional
September 17, 2019
Best Database Option
Oracle Database is currently used for banking data storage. It's very fast and makes it easy to store and manage the data.
- Fast - Data retrieval and manipulation is very quick.
- Simple - The language PL/SQL is easy to work with.
- None that I can think of.
September 17, 2019
Oracle Database Review
My organization uses Oracle Database in our IT department. It is used to manage all of the company's critical/sensitive data across the organization.
- Easy to use.
- Better performance than other solutions - Overall a better product experience.
- It is more expensive than other RDBMS system.
September 17, 2019
Oracle Database Rocks
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.
September 17, 2019
Oracle Database 12c adds color to your life!
We have been using Oracle Database 12c very intensively. It is being used across the whole organization. It does address the availability and reliability of our database instances.
- Availability.
- Reliable.
- Advanced Optimizer features. It has a better execution plan for a SQL statement, which results in faster runtimes and better performance.
- Optimizer behaviour. In 12.1, when you upgraded from version 11, the behavior was not great. We had to apply a patch for the optimizer to work effectively. Lots of customers have had bad experiences because of this 12.1 update.
- Patches. Oracle is not very specific about the patches they offer. You have to figure out which patch you need for which problem, and the information to find that is often difficult.
September 17, 2019
The Best Choice For Our Company
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.
September 17, 2019
Oracle Database for the Public Sector
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.
September 17, 2019
Oracle Database is the most secure
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.
September 17, 2019
Oracle is the best solution for Database.
Compared with Oracle 11g, Oracle 12c is more stable and has more functions and features that help our developer to have an easier implementation.
We use it in different areas of Oracle like transportation, supply chain management, and other small, medium to large applications using Oracle database to store our important data.
We use it in different areas of Oracle like transportation, supply chain management, and other small, medium to large applications using Oracle database to store our important data.
- High availability of RAC
- Easy to install
- Stable and reliable
- Various support
- Price is a bit high
- Some enhanced features cost extra money
- Need to test thoroughly for complex SQL as sometimes the result might be wrong
September 17, 2019
The cloud offering makes it seamless for deployment.
This is the backend to the Boardwalktech platform that I prototype. The option is to use SQL Server or Oracle, and I have both deployments.
- It is the standard that the company have a license for so I don't have to do a separate purchase
- It can be coded in PL/SQL which I am familiar with
- It is pretty seamless so I'm good with the product
September 17, 2019
Oracle Database Review
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.