Oracle database 12c comes with greater reliability, scalability and security
Overall Satisfaction with Oracle Database 12c
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.
Pros
- 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.
Cons
- 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.
Using Oracle Database 12c
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.
Evaluating Oracle Database 12c and Competitors
- 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.
Oracle Database 12c Implementation
- 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.
Oracle Database 12c Support
Pros | Cons |
---|---|
Quick Resolution Good followup Kept well informed Immediate help available Support cares about my success Quick Initial Response | Need to explain problems multiple times |
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.
Using Oracle Database 12c
Pros | Cons |
---|---|
Like to use Relatively simple Easy to use Technical support not required Well integrated Consistent Quick to learn Convenient Feel confident using | None |
- 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.
Comments
Please log in to join the conversation