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
- 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
- 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
- Document-based database persistence
- Indexing
- Distributed database
- Sharding, etc.
September 18, 2019
Oracle Review 12.2
- 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
- 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 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
- 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 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
- 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 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
- 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
- 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!
- 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
- Stability
- Reliability
- License model
September 18, 2019
My experience with the new Oracle 12c
- 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
- 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
- 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
- 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!
- 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
- Scaling.
- Integration.
- Security.
- Commercial department.
- Bank opportunity.
- Unique client target.
September 17, 2019
Oracle Database for the Public Sector
- 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
- 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.
- 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.
- 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 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.