Money Well Spent!
[Our] Entire organizational data is placed in Oracle 12c. We, as an organization are extremely satisfied with the performance and the …
Oracle Database
Top Rated
Oracle Database
Top Rated
Oracle Database
Overview
What is Oracle Database?
The Oracle Database, now in edition 19c, is presented by the vendor as an industry leading database that delivers leading-edge innovations, including machine learning to enable self-driving data management. An enterprise, database cloud service, it is designed to support mixed...
Read moreRecent 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
Top Rated
2022
Reviewer Pros & Cons
View all pros & consVideo Reviews
Leaving a video review helps other professionals like you evaluate products. Be the first one in your network to record a review of Oracle Database, and make your voice heard!
Pricing
View all pricingN/A
Unavailable
What is Oracle Database?
The Oracle Database, now in edition 19c, is presented by the vendor as an industry leading database that delivers leading-edge innovations, including machine learning to enable self-driving data management. An enterprise, database cloud service, it is designed to support mixed workloads through any…
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?
93 people want pricing too
Alternatives Pricing
What is Microsoft SQL Server?
Microsoft SQL Server is a relational database.
What is Grist?
Grist enables users to transform spreadsheets into a custom database where data is actionable. Build a relational spreadsheet with no code.Customize each page of a Grist database into an app-like dashboard. Transform tables into data cards or colorful charts, or create a custom widgets.Drill into…
Product Details
- About
- Competitors
- Tech Details
- FAQs
What is Oracle Database?
The Oracle Database, now in edition 19c, is presented by the vendor as an industry leading database that delivers leading-edge innovations, including machine learning to enable self-driving data management. An enterprise, database cloud service, it is designed to support mixed workloads through any deployment strategy, on premises or in the cloud.
For more information visit https://www.oracle.com/database
For more information visit https://www.oracle.com/database
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
The Oracle Database, now in edition 19c, is presented by the vendor as an industry leading database that delivers leading-edge innovations, including machine learning to enable self-driving data management. An enterprise, database cloud service, it is designed to support mixed workloads through any deployment strategy, on premises or in the cloud.
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
View all alternativesCompare with
Reviews and Ratings
 (1172)
Attribute Ratings
Reviews
(1-5 of 5)- Popular Filters
Companies can't remove reviews or game the system. Here's why
November 03, 2021
Non-stop traffic with Oracle Database
We use Oracle 12c databases to store information from many of the critical modules of our MLFF (Multi Lane Free Flow) tolling solutions. Oracle Database 12c can handle variable workloads, maintaining throughput at peak moments. Our solutions utilize many different technologies, but rely on Oracle Database as a key component.
- Oracle Database 12c has the ability to scale to support intensive workloads.
- PL/SQL provides an efficient way to develop data-intensive processes that are able to interact with data without transferring it to an app server
- Partitioning, Compression and Encryption are some of the optional features that enhance performance, reduce costs and secure the information stored in Oracle Database 12c
- New (actually it is more than five years old) multi-tenant architecture is not as straightforward as SQL Server, but it has been enhanced in Oracle 12c Release 2 and later 18c and 19c.
- Many features require additional licensing (either as options or as packs) that increase the total cost
- As a software center, we are able to work with a proven platform that is recognized by our customers as a solid and secure Database, leveraging their previous knowledge and experience with Oracle.
We use SQL Server for other modules of our MLFF Tolling System, so I work on a daily basic with both database engines. Oracle is recognized and distinguished by scalability and performance, ensuring a secure environment to host our critical data that comes from multiple roadside sites and from partner agencies, guaranteeing the availability and stability of stored data.
200
All development roles, including Software Architects, .Net Developers, Testers, Configuration Managers and Database Developers. We design, develop, deploy and test our Multi Lane Free Flow tolling systems using Oracle Databases
5
Configuration Managers install and deploy Oracle Database instances, on Development, Testing, Performance and User Acceptance environments. The Database Developers program with PL/SQL and review SQL embedded on the App layer, and also conduct performance testing.
- Our software solution -- most critical modules use Oracle Database to store critical information
- PL/SQL Programming is simple and powerful, allowing efficient data processing on the data layer
- Features like ASMM (Automatic Shared Memory Management) allow DBA to focus on important things rather than dealing with frequent configuration updates
- Installation and deployment process using the relatively new CDB (Container + Pluggable Databases) architecture is more complex than a non CDB architecture
No
February 15, 2019
Oracle database version with wonderful features and user friendly which helps to overcome limitations of older versions
Score 9 out of 10
Vetted Review
Verified User
As a Oracle Database administrator I administrate various Oracle Database versions in my organization for my client. We have Oracle Database 12C installed in more than 35 production server environments and we are in process of upgrading our 11G databases to 12C. Oracle company introduced Oracle Database 12C with huge number of new features to overcome the limitations of its older versions like 10g ,11g etc. I do installation of Oracle 12C version databases and upgrade my database from 11g to 12c version and administrate Oracle 12c databases. It's really amazing to see Oracle come up with wonderful technologies and features like
1) OEM 12C ,using which I can monitor heterogeneous databases along with Oracle databases, host monitoring, creation of groups, One link for OEM administration whereas in older versions we used to have one OEM link per server and it is really difficult to manage OEM links in huge database server enviornment. 2) Multitenant database 3) Recover table using Rman 4) Full database caching. 5) In 12C we can move data files online. Whereas in prior database versions we had to offline of shutdown the database in order to move data files depending on type of tablespace. 6) Single node RAC, Flex ASM, Flex cluster and many more features.
I had great experience working on Oracle 12C and I highly recommend using 12C as it helps you to secure your database in many ways and gives you wonderful features hence allows easy administration.
1) OEM 12C ,using which I can monitor heterogeneous databases along with Oracle databases, host monitoring, creation of groups, One link for OEM administration whereas in older versions we used to have one OEM link per server and it is really difficult to manage OEM links in huge database server enviornment. 2) Multitenant database 3) Recover table using Rman 4) Full database caching. 5) In 12C we can move data files online. Whereas in prior database versions we had to offline of shutdown the database in order to move data files depending on type of tablespace. 6) Single node RAC, Flex ASM, Flex cluster and many more features.
I had great experience working on Oracle 12C and I highly recommend using 12C as it helps you to secure your database in many ways and gives you wonderful features hence allows easy administration.
- OEM 12C allows cloud monitoring. We can install OEM on one server and monitor all my databases (11G R2 and above) hence I need to manage just one link. It also allows heterogeneous database monitoring, host monitoring, out offline patching.
- We do not have an option to recover tables from Rman backup prior to 12C hence we had to be only depending on logical backups.
- But using 12C database we can recover tables as well.
- When we look for availability RAC comes to our mind and Oracle Database 12C came up with new features related to ASM and RAC like Flex cluster and Flex ASM using which if at all ASM instance goes down in a RAC node it can make use of asm that is running in other node hence ensuring availability. In Flex cluster we need to have Flex asm and the leaf nodes. There will be no database/ASM instances running in leaf nodes but only the application servers. The incoming connection come to leaf node and then to the actual hub server. Leaf nodes reduce the cost as there is no need for internode communication between leaf nodes. The internode connection should be there within hub nodes.
- I don't see any such disadvantages but the multitenant structure seems bit complicated and same should be presented in simpler manner
- Oracle Database 12C had just positive impact on our overall business objectives as we could make full use of Flex cluster, Flex ASM and it saved our transactions during node failure.
- We have installed OEM 12C in one server using which we monitor Oracle 11g, 12C databases and we monitor hosts and goldengate which has eased the server administration
30
They are the Oracle Database administrators and we all work as a team in our organization. We perform installation, upgradation, patching, RAC administration, goldengate creation and management together. Team lead guides us in critical issues and whenever there are critical issues we start webex TRT call and coordinate with each other. It's a great experience for all of us working on 12C.
25
We need database administrators who can support as L1,L2 and L3 based on the issue priority. All the administrators should have a good understanding of the database architecture, instance and database administration. They need to have experience on Rman, datapump, RAC,Godengate, ASM etc
- We used flex asm feature of Oracle 12c which helped us to achive high availability
- We recovered table using Rman as there was a table dropped in production
- We created CDB and PDB's for all databases which simplifies administration of databases
- We have been able to recover tables using rman backup which was not available in prior versions
- We have enabled full db caching which gives good performance
- We create multiple indexes on columns which is very helpful in achieving good performance
- We are still in process of upgrading some of our databases from 11g to 12C and once we are done with all upgradation, we will be able to include all our databases under multitenant architecture
Yes
We replaced Oracle 11G version with Oracle12C as it gives too many new features like Flex cluster, Flex ASM, recover table from Rman, Multitenant architecture, Full DB caching,single node RAC etc and these are very helpful in achieving availability,scalability and performance
- Product Features
- Product Usability
We have RAC database enviornment in our organization and it is implemented to achieve high availability. Oracle 12C introduced Flex asm/Flex cluster which added advantages to RAC in order to achieve better availability in case of failure
I do not want to change my selection as I am quite happy with the oracle 12c database features and we are getting full benifits out of it
- Implemented in-house
No
- We did not face any such issues and it was smooth installation. The up gradation from 11G to 12C also was smooth as 12C provides parallel option to upgrade which makes the medatadata upgrade faster
No
1)I asked for help suring my multitenant migraton and ORACLE-SUPPORT guided me.
2)I face issue in oracle 12C flex cluster
3)I face issue in oracle 12C flex asm
4)We faced performance issues and we took help from ORACLE-SUPPORT
5)We took help in goldengate implementation between heterogeneous enviornments
2)I face issue in oracle 12C flex cluster
3)I face issue in oracle 12C flex asm
4)We faced performance issues and we took help from ORACLE-SUPPORT
5)We took help in goldengate implementation between heterogeneous enviornments
- Implementing Flex cluster and flex asm is quite challenging
- Easy to monitor databases using OEM 12C and performing out off line patching reduces downtime while patching
- I don't see many things in this category but CDB /PDM administration could be challenging
Score 9 out of 10
Vetted Review
Verified User
Ours is a software product development company (SaaS). All our databases including OLTP and Data Warehouse are on Oracle 12c. It is the most reliable, scalable, performance focused and manageable database available in the industry to the best of my knowledge and experience. It gave us the flexibility to scale easily and manage our complex requirements.
- The Oracle optimizer is getting smarter in every Oracle release. In 12c, the adaptive query optimization features helped a lot to improve query performance.
- In 12c, we can restore a single table from RMAN backups - it's a very useful and time-saving feature when we need to recover a particular software module.
- I see the scope of improving the optimizer capabilities to automatically handle run-away queries better, meaning, if a SQL suddenly comes up with a bad execution plan, the database needs to be able to handle it smoothly, rather than affecting other SQL.
- Oracle database 12c is very stable, it reduced a lot of downtime for us, thus we have a greater ROI.
It's easy to scale an Oracle database compared to any others, it's easy to manage many Oracle databases together with lots of administrative and security features.
30
The web-based software application development is done on Oracle Database 12c version, all the health care information is saved and served through the 12c database. Also, the Business Intelligence built on the 12c data warehouse.
10
The DBA team having at least one years + experience supports the 12c databases on development environment, testing and production environment as well.
- It is the main production Transactional Database for web-based applications
- It is the underlying Data Warehouse Database for Business Intelligence applications
- It helps us to scale the software product and services at ease with a lower operational and management cost
- We did not have to do any tweak to use 12c databases, all the features behaving according to the expectations. We are taking advantages of advanced compressions which reduced our storage usage about 40% and with greater performance.
- We are looking forward to using multitenant features of 12c which will help us consolidates many databases altogether and will reduce overall cost drastically.
No
- Product Features
- Product Usability
- Product Reputation
- Prior Experience with the Product
- Vendor Reputation
The features we needed, the stability and scalability we looked for, I believe Oracle database was the right choice.
- Implemented in-house
Yes
1. Training, research & PoC implementations
2. Implement and test in development environments
3. Implement and test in beta environments
4. Implement in a secondary site in production with zero downtime
5. Implement in primary site in production
6. Go Live during a weekend when there is considerably low usage and monitor closely
2. Implement and test in development environments
3. Implement and test in beta environments
4. Implement in a secondary site in production with zero downtime
5. Implement in primary site in production
6. Go Live during a weekend when there is considerably low usage and monitor closely
Change management was minimal
All teams must work together and must have ongoing regular meetings during the implementation phase.
- We hit a problem during the upgrade process, the halfway through the upgrade caused error, then it was resolved with the help of Oracle Support.
Yes
Yes most of the time.
When we initially migrate to 12c version from 11gR2, there was a problem in the upgrade process and upgrade failed in the middle-way. It was one of the production databases and we were counting times to bring up the databases. Oracle Support helped us 24/7 basis to get the issue resolved with proper guidelines and documentation - the process was smooth and quick because of Support.
- The online database management and maintenance tasks
- The SQL Plan stability and query performance
- The overall database management, problem diagnosis and tuning
- Nothing mentionable. However, sometimes we hit by a bug, which needed Oracle Support intervention to get resolved.
April 11, 2018
My thought on Oracle Database 12C
The Oracle 12C Database is used as a core business backbone for modeling the process of selling products in more than 25 countries in one of the biggest retailers in the world. The database not only deposit the data but also contains the business logic in PL/SQL packages.
- high performance
- mature and reliable
- rich in features
- can be expensive
- big footprint
- stability
- security
it was not my choice for Oracle 12C, but during the years I've learned on the advantages. If I would choose the Oracle 12C, I'll take it for the possibility to start from Standard and to go to enterprise based on a business case of use. I really like the possibility to have the logic in the database (triggers/ procedures/functions/packages)
80
Application Users
Developers
Business Analysts
Developers
Business Analysts
10
Oracle Database Administration Users
- store/retrieve data
- store business logic
- transfer data
- devops processes with no downtime via EBR
- running Oracle database on docker
- using database for feeding and consuming web services via JSON
- document store
Not Sure
- Product Features
- Product Usability
- Product Reputation
I would choose hard on the edition of the database. Sometimes even the express edition offers all you need for an internal application and if it scales up you can easily change to a standard or even an enterprise edition.
- Implemented in-house
- Professional services company
I can't disclose the company
Yes
Change management was a minor issue with the implementation
- understanding the business needs and implementing them in database
- human factors
- time compression
- administration via EM
- database development via SQL Developer with revers engineering on models
- reporting with APEX
- reading logs
- administering without proper options installed
No
February 27, 2016
Oracle Database - Simply The Best
Oracle Database is being used in the areas of data warehousing and transaction processing across the whole organization. The business problems it addresses are various log data collection, search engine marketing, and website content optimization. In addition it is used to cleanse, aggregate, load and transform data in the data warehouse, with the data eventually consumed by data analysts and data scientists.
- Maintain data integrity: with database supplied primary/unique keys and referential integrity constraints, data integrity is well-maintained in a highly efficient manner. More over, oracle database enforces transaction integrity and read consistency, and it is extremely rare to have data corruption.
- Versatility and flexibility in usage: Oracle is very versatile and has many capabilities that allow for a great variety of usage and creativity. Most of the real life business use cases can be addressed by it, and one just needs to know how to better take advantage of it.
- Rock-solid foundation and exciting new features: Oracle database has come a long way (created in the mid to late 1970s), and evolved to be the best relational database platform. It has also incorporated many new features over the years, either inside the database engine itself or through add-on options/products. It has a strong life even faced with the new-age challenges such as big data analytics.
- It would be nice to have schema-based privilege grants. Currently, the object privileges are granted either per individual objects (very small knife), or on all objects (very big knife). We need something in between: schema-based privilege grants with the ability to cover new objects owned by a particular schema after the grant. For example: one could use "grant select on all tables of A to B;".
- It may be nice to have the ability to issue commit on behave of another session for its completed but uncommitted transactions. Imagine a scenario that one session issues an update on a table, and after some time the update is completed but the person doesn't commit. The table remains to be locked by the session. Another session needs to update on the same rows after the prior session's update, but it has to wait or kill the other session. Killing the other session means rolling back that session's transaction and losing all of its effort. In this case, if we want to preserve the other session's update, it would be nice to commit on behave of that session (instead of simply killing the session and losing its transaction), and then do our update.
- The use of Oracle Database has improved overall availability, performance, and the capabilities of the business systems, and it has a positive impact on ROI.
- Oracle has the reputation of being expensive. If not planned, sized, and estimated appropriately, one could over spend on things that are not necessary. That will inevitably result in a negative impact on ROI.
- Think about long term, and the availability of people's skill sets within the organization, and the skills accessible outside. Use the right tools for the jobs.
- Data manipulation and query
- Data processing and transformation
- Loading data into the database
- Unload massive amount of data out of the database
- Some analytics queries and functions
- Monolithic nature of the database storage layer
No