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.…
Oracle Database: The Best in Business & Totally Worth
Oracle Database - Harnessing the Power of Data
Money Well Spent!
Non-stop traffic with Oracle Database
Oracle Database is still King of databases (minus the licensing cost ;-) )
Stable but Expensive and Tough to Use Enterprise Database Platform
Why and why not to use Oracle12c Database?
Review
Oracle Database a tool that can sotre
My Succinct Oracle Database Satisfaction Recap
My review of Oracle Database
Oracle Database 12c for for your business needs
Oracle Database for critical workloads that can scale
Excellent experience using Oracle products over the past 18+ years.
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
Pricing
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?
164 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 Video
Oracle Database Competitors
- PostgreSQL
- MariaDB Platform
- Microsoft
Oracle Database Technical Details
Operating Systems | Unspecified |
---|---|
Mobile Application | No |
Frequently Asked Questions
Comparisons
Compare with
Reviews and Ratings
(1193)Attribute Ratings
Reviews
(1-4 of 4)Why and why not to use Oracle12c Database?
- 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.
Scenarios where Oracle12c DB is well suited:
1. Oracle12c DB with ODA(Oracle Database Appliance) is well suited for small to medium OLTP shops, where you don't have much DB workload. Oracle12c with ODA provides DB high availability, High redundancy, and good DB performance.
2. Oracle12c DB in EXADATA with IORM implementation is well suited for mixed DB environment. Mix DB environment is the one in which some databases are development DB, some are Test DB, Some are QA DB, Some are OLTP, and Some are Data Warehouse DB.
3. Oracle12c is well suited for Banking, Financial, Retail, and Aviation Industry.
Scenarios where Oracle12c DB is less appropriate:
1. Oracle12c is less appropriate for small shops like Restaurant business, Hotel/Motel Business, Burger Shop and Coffee House.
2. Oracle12c is less appropriate for Research and Scientific work, Data Analysis, Big data Analytics. The data computational speed is not so good in Oracle world.
3. Oracle12c is less appropriate for Data Messaging industry.
- Positive Impact - I have been serving as a DBA to a Aviation Industry customer since 2009. Aviation Industry User community believes that Oracle database product is best product in the world. The reason would be it has been in the market for many years, more reliable product and the customer has more confidence in Oracle than others, has good market reputation, so many oracle expertise easily available whenever and where ever needed in affordable cost.
- Positive Impact - Oracle12c with - ODA, Exadata, Big data appliance, Super cluster, and Oracle12c cloud offering are becoming popular day by day.
- Negative Impact - Oracle licensing cost has been one of the most debatable topics in business user community every year.
2. We have oracle premium support for Oracle19c db which are hosted in Oracle Database Appliance.
3. We have extended oracle support for Oracle 12.2.0.1 dbs.
2. Oracle has zoom call and chat session option linked to Oracle SR. Whenever you are in Oracle portal - you can chat with the Oracle Analyst who is working on your case. You can request for Oracle zoom call thru which you can share the your problem server screen in no time. This is very nice as it saves lot of time and energy in case you have to follow up with oracle support for your case.
3.Oracle has excellent knowledge base in which all the customer databases critical problems and their solutions are well documented. It is very easy to follow without consulting to support team at first.
On April 4/26/2021 at 8:30AM CDT - one of my ODA system server patching (from version 19.9 to 19.10) failed at step - configure ASM priv network - Dup Subnet for .17.* privasm.
We requested for oracle zoom call. Oracle Analyst Charles Lucas from USA MST time zone opened Oracle zoom session. He collected all the information needed to analyze the problem. He applied all his experience to solve this issue. This was one of the unique problem and this type of problem was never encountered with this ODA 19.10 patch bundle. He engaged Oracle ODA Development team for further analysis. Oracle development team took little time to analyze this issue and provided the solution. Oracle Analyst Matt Casaddy joined zoom session on 4/27/2021 and guided me to follow some of the steps of MOS Note - 2612963.1. The problem was finally resolved. It was an exceptional support from Oracle Analyst - Matt Casaddy. I learned a lot of Oracle RAC networking concepts from this Oracle SR request.
Oracle database version with wonderful features and user friendly which helps to overcome limitations of older versions
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
- 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
- Product Features
- Product Usability
- Implemented in-house
- 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
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
- 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 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.
- Product Features
- Product Usability
- Product Reputation
- Prior Experience with the Product
- Vendor Reputation
- Implemented in-house
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
- 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.
- 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.
Oracle Database use at a Hospital
- Fast
- SQL and PL/SQL are very powerful
- New releases have very nice features like compression, obfuscation, XML and JSON
- License is sometimes is very expensive
- A very good DBA is always needed to solve daily issues
- Help online
24/7 operations
Solid database
Need for speed and performance
Not good for Big Data scenarios
- we can trust in our database and feel out data is safe
- Develop in PL/SQL .Is stable,easy and fast and we have no "new releases" problems