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
(1-25 of 117)Companies can't remove reviews or game the system. Here's why
January 06, 2024
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 data is stored in the form of tables. We usually retrieve the data using the SQL queries. The oracle database helps me to easily retrieve the complex data. By implementing permission and altering user activities, we can simply prohibit unauthorized access and provide separate access to users.
- Easily retrieve complex data using SQL queries
- Provides high level of security from unauthorized access.
- Data can be easily recoverable it it is deleted by mistake
- Installing in windows machine is easy
- Price is one of the reason, as its licensing cost is expensive. Rest is good
January 03, 2024
Oracle Database - Harnessing the Power of Data
Oracle Database is being used in the compnay as SOR database for many business products. I am an active user or it in Banking and Mortgage Businesses.
- The Native PL/SQL Language is very simple to learn and use. Stored Procedures created are easy to maintain as well.
- Data Recovery Setup is very effective and easy to use
- Database Administrative tasks impact the DB performance
- No support for Unstructured Data
Oracle [Database] is used by [a] couple of departments to maintain Animation assets and for couple of applications in the Animation movie making workflow.
- Oracle's High Availability setup is very durable
- Performance of the database is very good for large databases
- DR setup is very reliable and can be setup easily
- ASM Storage management makes life easy in managing the datafiles
- Licensing cost is very expensive
- Sometimes getting an expert in Oracle support might be a challenge
May 01, 2021
Why and why not to use Oracle12c Database?
We do support our client's Oracle12c databases hosted in two data centers - One in Plano, Texas and One in Cherokee, Oklahoma. We support approx 400 plus DB instances running in different version of Oracle db- Oracle10g, Oracle11g, and Oracle12c. Our client business is in Aviation Industry. This industry demands state-of-art Technology to better serve their customer with the best quality service at affordable cost. This industry demands High Availability and High-Performance system for quick decision making.
- Oracle12c Data Guard ensures high availability, data protection, and disaster recovery for enterprise data. It is one of the oracle finest solution for disaster recovery and data corruption. In this setup - You have one Primary and one or more standby DB in two or more different geographical locations. So, if the database hosted in one location goes down due to planned or unplanned outages, you can easily operate business from remote location database.
- Oracle12c RAC provides Scale-up architecture. Oracle RAC ensures High Availability. In RAC architecture you have at least two or more physical servers with same configuration connected thru interconnect network. So, if one server goes down, you still have database running from the other(surviving) nodes. In this architecture - You can have appropriate on-demand services. You can easily scale up Servers, CPU, Memory.
- Oracle12c has amazing Performance Tuning framework. You can very easily fine-tune databases running on Oracle12c. Some of the great features are Oracle ADDM, AWR report, ASH report, SQL report, SQL Plan Management, Tuning Advisor - SQL Tuning Advisor, SQL Access Advisor.
- Oracle12c has great Back and Recovery solution using Oracle RMAN(Recovery Manager). Without much intervention and work, you can easily restore the database backup whenever and whereever you want.
- Oracle12c provides great security standards that meet fundamental data security requirements - Data Confidentiality, Data Integrity and Data Availability.
- Oracle Label Security, Oracle Data Redaction, Oracle Data Masking and subsetting, Transparent data protection, database storage encryption, Unified Auditing, and Oracle fine-grained audit are some great oracle features.
- In Oracle Data Guard - Oracle standby database is most of the time passive and nothing happening on it other than applying the log. Even in Oracle Active Data Guard configuration - You can not do more than running the business SQL query on the standby. Oracle must come up with solution such that standby database can also be fully utilized as a full operational database.
- Oracle should improve on Oracle internal locking mechanism, latch, and data concurrency. I have seen databases which runs fine with less number of ACTIVE user sessions. When ACTIVE user sessions are increased in the same database - db performance is deteriorated proportionately. If the database kernel has designed correctly, there won't be any db performance issue regardless of any number of user connections/sessions.
- In current time - DB growth is very common, today your db size is 20GB, It may be 500GB at the end of the year, so on and so on. With respect to db size increase, Oracle must improve on RMAN(Recovery Manager) backup tool. The expectation is that faster backup and restore as and when needed. There is always a debate that - Please don't run RMAN backup,data pump export backup, and gather stats job during business peak hours as it will impact DB performance. Oracle database should have designed in such that Administrative jobs like Backup, data pump export and DB gather stats should not have db performance impact anytime, at any cost. Even Oracle claims that Oracle DBRM (Database Resource Manager) is solution to this problem, but, in actual, it doesn't address the problem in much better way.
April 29, 2021
Review
Oracle 12c is used to support the shopping website of the organization, it's very robust, high performing and THE database is scalable to the needs of increasing traffic on the site. It addressed especially the problem with consolidating databases and scaling, much needed performance of apps using Oracle database.
- Multitenant architecture has reduced the DB foot print and maintenance.
- Refreshing test database from production has become affordable and manageable.
- Restoring and recovering tables with Rman has become easy with 12c.
- Like MySQL Oracle also should provide a way to manage both unstructured and structured Data in same DB.
- More free training through OTN (self study videos) about 12c performance and how to adapt to it.
- Plan stability without adapting to use SPM when upgrading to newer versions. SPM has caused problems like taking up too much memory in the DB server when implementing it to overcome the shortcomings of upgrade with optimizer behavior altering the performance. In a way a more adaptable approach would be beneficial for DBAs for upgrade not compromising performance which I think is one of the biggest challenges upgrading .
April 13, 2021
Oracle Database a tool that can sotre
Oracle Database software has been used by our organization form past few years, mainly it is used by our Information Technology department for backup of data and recovery.
The main business problems it addresses are database conversation, backups and the best part is that it supports multiple programming languages as well. We can save huge amount of data without any instability.
The main business problems it addresses are database conversation, backups and the best part is that it supports multiple programming languages as well. We can save huge amount of data without any instability.
- Best thing about it is that it supports PL/SQL which is helpful in writing complex quarries easily.
- Its storage capacity , backup and recovery features make it the best database storage tool available.
- Other thing I like about this software is its interface is so good.
- Nothing much I could think of but ya it is very tough to understand it's functions and it's use.
- It is quite expensive as well.
April 02, 2021
My review of Oracle Database
A lot of our applications are using Oracle Database as their data store.
- High stability and reliability
- A complete set of database features
- Performance is sub-optimal when data size is large.
- Non-trivial effort to setup. We have to build some automation so developers can save some time to set it up on their local machines.
December 17, 2020
Oracle Database 12c for for your business needs
Score 8 out of 10
Vetted Review
Verified User
We use across the organization. We are just now making use of the new features in 12c.
- Pluggable databases really help with consolidation.
- Restore a table or table partition easily using RMAN.
- Online migration of a Table Partition or Sub Partition.
- License on virtual infrastructure.
- Technical support needs to improve.
- Data Guard setup needs to simplify and troubleshooting is still too complex.
February 18, 2020
Excellent experience using Oracle products over the past 18+ years.
We use Oracle Database for storing relational data for our OLTP/warehouse DBs. We also use it as a high availability solution (Data Guard). It is being used enterprise-wide. It helps to store, retrieve, and run analytics on data. The Dataguard also helps offload the queries from primary and helps with performance.
- Highly performant/reliable and good technical support
- ACID -- Supports ACID transactions
- Non-structured Data -- XML, hard to use
- High Availability -- Real application clusters are available but it is difficult to set up and maintain
November 06, 2019
Looking for scalable and reliability? answer is Oracle!
It is being used as a customer user-managed database and we use many geo spatial capabilities such as spatial aggregation, intersection, spatial filters, buffering features etc.
- I really like the robust architecture it provides.
- It is a very detailed database and is much more scalable than other competitors.
- Documentation is great and very detailed.
- Sometimes it gets really complex at writing some large geo spatial queries.
- Spatial indexing could be easier.
- It requires some level of expertise to operate.
October 18, 2019
Why Oracle Database is right for you
I work for Intuit and here Oracle is used by almost all product teams across all verticles. At our team we primarily use it for recording various application configurations as well as for our data warehouse solution. So we effectively use oracle database products for OLTP and Data warehousing. This helps to make our applications modular as the state is captured constantly within the Oracle DB.
- The query execution and optimization engine are just great in Oracle. A simple "Explain Plan" statement will give a thorough analysis of the query execution plan.
- We store huge amount of data in our Oracle database, if we partition well and plan the loads correctly, the database is very fast and provides top performance.
- For us to represent a persona and its relations is more convenient using a graph database rather than a relational DB like Oracle.
- Oracle DB is a little more expensive than the other comparable products out there in the market. It will help if the licensing costs are reduced.
October 14, 2019
Oracle Database Review
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.
October 04, 2019
Database 12c offers great new features
Oracle Database 12c is used by multiple departments at our company. It is the backend database for a number of applications that we run, both Oracle provided applications and supported applications. It addresses the performance and daily functions of our business. We use it for a variety of functions from customer-facing to internal apps.
- Oracle 12c offers many new features that are performing well. Online partitioning has been a large benefit that was not offered in past versions.
- From a larger perspective, I think that Oracle 12c Database offers better performance than Microsoft SQL Server does.
- Oracle 12c allows the ability to restore just one table via RMAN and that allows us to save time.
- Oracle 12c has some slight differences from version 12.1 to 12.2 that have forced us to recode or alter DDL to allow the same features to work.
- I wish that RMAN would error out at the beginning instead of the end when there are version discrepancies.
October 04, 2019
Database Administrator Review of Oracle
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
September 30, 2019
#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.
I upgraded all Oracle production databases (about 15 production databases) from 11g R2 to 12c R2. The Oracle 12c databases are used university-wide, and are really critical to the university business.
- I believe other users have reviewed the pros already. I am addressing only the Cons of 12c R2.
- SYSAUX tablespace grows rapidly. I didn't need to add space to SYSAUX last a few years in 11g. But after upgrading to 12c R2 12.2.0.1, SYSAUX grows daily, and I have to add space to SYSAUX regularly, about every 2 weeks. I am currently opening an Oracle SR and working with Oracle Support on this issue.
- Some of our small databases only use about 5GB excluding SYSAUX. But SYSAUX uses 5GB alone!
- Almost all universities (if not all) in the USA have been using Banner application. But Banner app users fail to log on 12c Release 2 databases after upgrading to 12c R2 from 11g because of an Oracle Bug related to password-protected profile. I applied an interim bug to work around this issue. However, since Oct 2018, the PSU patching will not work. I must rollback the interim bug, and then patch the PSU, and then apply the interim patch again to resolve the Oracle bug. I asked Oracle to include the interim in the PSU in Oct 2018. But up to PSU Jul 2019, Oracle didn't implement it yet!
September 19, 2019
Oracle Database 12c review
Oracle Database is being used by my organization as the primary database for data storage. We use it with hibernate to be able to develop in Java and use the database in an object-oriented way.
- Reliability.
- Performance.
- Scalability.
- It's hard to set up in different environments.
September 19, 2019
Great for the Banking World!
Oracle Database 12c is being used across the whole organization. We use it to store payment and card-related data. We prefer Oracle because data consistency is very important to us.
- Data Consistency
- Slow Availability
September 19, 2019
Oracle 12c usage feedback for financial sector firm.
We primarily use Oracle in our organization, except for a few applications which use other databases like PostgresSQL, SQL Server, etc. Primarily DB is used to manage data for various applications all across the organization by multiple applications. Now, with some of the new applications, they are using some AWS or third-party databases as well.
- First of all DB needs to be upgraded to Oracle 12c for support prospective from Oracle.
- Oracle 12 has some great features with respect to auditing.
- Keeping the data with respect to hot and cold rows is also a great features helping in managing data well.
- It had installation issues where it needed to have a patch applied before installation could begin. Downloaded software should have been tested before providing it to the user.
- Oracle 12.1 was not very stable so we had to migrate it to 12.2 after some time.
September 19, 2019
Database 12C in site
It is used to store all student and business data throughout the university.
- Speed
- Security
- Up-time
- Usability
- Ease of use
- Setup
September 18, 2019
Reliable DB for Gov
Most of our data is housed in Oracle Database 12c. It is used lots with other BI tools to get a pulse on the data and pull reports for the organization.
- Ease of use
- SQL syntax is robust
- Reliable
September 18, 2019
Oracle Database 12c Review
We use Ellucian Banner for the college. The backend is an Oracle database. We are currently on 11.2.0.4 and are planning to upgrade to 12.2.0.1. I also have some databases on 12.1.0.2.
- Easy to manage and maintain.
- Backup and cloning to development instances are easy.
- Restoring a full database or a particular table is easy.
- Performance was better compared to 11gR2.
- Oracle LOBs is still an issue.
- Function-based indexes are still a problem
- Query optimization needs improvement.
September 18, 2019
Oracle Database 12c Rocks
80-85 percent of data from the university is stored on an Oracle Database and all apps connect to our DB.
- Recovery. Recovering the database is more reliable than any other I know of.
- Speed and performance.
- Reliable.
- Querying large amounts of data, fast.
- Recovery of a database to a point in time needs to be easier.
September 18, 2019
The Oracle Way
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.
September 18, 2019
Oracle and VSE Corp
The Oracle database is currently what houses our data in relation to our corporate ERP system. The database sits on an Oracle Database 12c appliance for ease of access and use. On the ODA, this Oracle Database 12c is 1 of 5. Also running in parallel are another five that run for production, testing, and development. This database and architecture were selected for performance and security reasons
- Performance - We have several ERP systems all running on various platforms. By far the best performance in terms of consistency being up and available is our Oracle platform. To put into scale, out of all three platforms, since I have been employed, Oracle has not been down once, while the other two have been down multiple times, to the point that my attendance at OOW2019 is focused on migration from other platforms to Oracle.
- Security - The matter of security is huge. One of the biggest points in choosing an Oracle database and appliance over anything else is the security it provides in counter to anything else on the market.
- Training - While there is an enormous amount of training available, there are still gaps in terms of availability for classroom-style learning. I have found it more effective to be in a classroom setting where one is held accountable at that moment in time as opposed to self-paced (pure personal preference).
- Cost - While we love the databases and appliances, the cost of maintaining is becoming an issue when competitors are coming in at such a lower point. Pushing this to a more profits oriented C-level makes justification difficult at times.