Oracle 12c is significantly cost savings ,reduced risk and increased flexibility and also provide many technical benefits and business value
1 ) Multitenant and Pluggable Database feature allows to reduce costs by consolidating multiple databases and isolating applications while still sharing the same memory structures and clouding of databases into IaaS, PaaS, and DBaaS deployments. Oracle see multitenant databases as the first step to the cloud, As they allow to move databases between on-premise and the cloud, between cloud providers, or between different parts of a high-availability cloud design.
a) Cloning is fast as only user metadata/data needs to be cloned
b) Upgrades/patch can just unplug from old version and plug into new version
c) Reduces total db usage by not having repeated all the CDB resources.(Less disk space and memory usages)
2) Automatic Data Optimization feature monitors database read/write activity enabling DBAs to easily identify the data that is hot/warm/cold in terms of access frequency. Also smart compression and storage tiering automatically compress and tier data based on the activity and age of the data.
3) In-Memory Caching, Compression, and Column Store –it is a new set of features which allow for large amounts of memory-based data caching beyond the traditional buffer caches, and the cached data is stored in a compressed columnar format. This can dramatically improve performance and optimize server resources, and is surprisingly easy to implement since it is built into the database kernel and transparent to the application.
4) Recovery Manager (RMAN) Compression
Data is compressed before it is written to disk or tape, and doesn’t need to be uncompressed before recovery, leading to a reduction in storage costs of up to five times for backups.
5) Database Compression Technologies for all Data Types -Oracle 12c Database provides a comprehensive set of compression capabilities across all types of data without changes to your application to help customers improve query performance while reducing storage costs
6) Data Guard Network Compression
Redo log data is compressed before it is sent over the network to standby databases, which can double redo transport speed.
Other advantages
High Availability
Further RAC Improvements
–Faster failover of services
–Grid Plug&Play allowing seamless additions/removal of nodes
DataGuard improvements
–Realtime apply and log compressions
–Fast start failover added
Active DataGuard added
–Standby Database can now be queried whilst redo apply is active
--Detection of gaps and automatic resolution
Legacy Database risk
1) Risk of hitting an issue/bug
2) limited feature which restrict DBA to fine-fune database
3) Oracle support will not help in case of crash and bugs
Premier Support for Oracle 11gR2 ended 31 January 2015 and the free extended support ends 31 May 2017. Bug fixes, security and other support for Oracle 11gR2 will no longer be provided.
and will be charged for extended support for Oracle 11g from June 2017. Extended support for release 11.2.0.3 ended on 27th August 2015 so you need to apply a bundle patch immediately if you are on 11.2.0.3 or lower.
Extended support for Oracle 11g ends completely on 31st January 2018. By then, we need to have upgraded to Oracle 12c.
1 ) Multitenant and Pluggable Database feature allows to reduce costs by consolidating multiple databases and isolating applications while still sharing the same memory structures and clouding of databases into IaaS, PaaS, and DBaaS deployments. Oracle see multitenant databases as the first step to the cloud, As they allow to move databases between on-premise and the cloud, between cloud providers, or between different parts of a high-availability cloud design.
a) Cloning is fast as only user metadata/data needs to be cloned
b) Upgrades/patch can just unplug from old version and plug into new version
c) Reduces total db usage by not having repeated all the CDB resources.(Less disk space and memory usages)
2) Automatic Data Optimization feature monitors database read/write activity enabling DBAs to easily identify the data that is hot/warm/cold in terms of access frequency. Also smart compression and storage tiering automatically compress and tier data based on the activity and age of the data.
3) In-Memory Caching, Compression, and Column Store –it is a new set of features which allow for large amounts of memory-based data caching beyond the traditional buffer caches, and the cached data is stored in a compressed columnar format. This can dramatically improve performance and optimize server resources, and is surprisingly easy to implement since it is built into the database kernel and transparent to the application.
4) Recovery Manager (RMAN) Compression
Data is compressed before it is written to disk or tape, and doesn’t need to be uncompressed before recovery, leading to a reduction in storage costs of up to five times for backups.
5) Database Compression Technologies for all Data Types -Oracle 12c Database provides a comprehensive set of compression capabilities across all types of data without changes to your application to help customers improve query performance while reducing storage costs
6) Data Guard Network Compression
Redo log data is compressed before it is sent over the network to standby databases, which can double redo transport speed.
Other advantages
High Availability
Further RAC Improvements
–Faster failover of services
–Grid Plug&Play allowing seamless additions/removal of nodes
DataGuard improvements
–Realtime apply and log compressions
–Fast start failover added
Active DataGuard added
–Standby Database can now be queried whilst redo apply is active
--Detection of gaps and automatic resolution
Legacy Database risk
1) Risk of hitting an issue/bug
2) limited feature which restrict DBA to fine-fune database
3) Oracle support will not help in case of crash and bugs
Premier Support for Oracle 11gR2 ended 31 January 2015 and the free extended support ends 31 May 2017. Bug fixes, security and other support for Oracle 11gR2 will no longer be provided.
and will be charged for extended support for Oracle 11g from June 2017. Extended support for release 11.2.0.3 ended on 27th August 2015 so you need to apply a bundle patch immediately if you are on 11.2.0.3 or lower.
Extended support for Oracle 11g ends completely on 31st January 2018. By then, we need to have upgraded to Oracle 12c.
