Previously scheduled for release on the 15th, version 12.2 was released on Wednesday (March 1). With a series of improvements and new features, this release offers several benefits, some of which are highlighted below. Check them out:
• Plugable Databases (PDBs):
Support – Important note regarding support: in version 12.2, the old non-PDB architecture still exists, but will no longer be supported and may be removed in the next version of Oracle Database. The PDB architecture can be used in 12.2 at no additional cost for one PDB, requiring additional licensing (plugable database option) for additional PDBs.
Character set – possibility of having PDBs with different charactersets from CDBs;
Hot Clone – allows PDB clones to be executed in hot mode, i.e., with the PDB in read-write mode, which was previously a limitation;
Local Undo – possibility for the PDB to have its own UNDO, which was previously shared;
IOPS Limit – we can now limit IOPS (I/Os per second) in PDBs, preventing an I/O load in one PDB from affecting another;
Flashback – possibility of performing a flashback on one PDB without affecting the others.
• In-Memory
In-Memory for Active Standby Databases – possibility of using In-Memory in active standby;
Dynamic Resize – we can dynamically resize in-memory column storage; previously, it was necessary to restart the database;
Fast Database Startup – with data stored in a disk lob, the event of populating data in the in-memory cache became much faster, making the database start faster.
• Oracle Sharding
This feature enables the scalability and availability of OLTP applications with the distribution and replication of data across Oracle Database pools that do not share the same hardware or software. The database pool is presented to the application as a single logical database. Applications scale data, transactions, and users to any level, on any platform, by simply adding new databases (shards) to the database pool.
• Security
Internal Tablespaces Encryption – possibility of encrypting internal database tablespaces, such as: sys, sysaux, etc.;
Database Vault Simulation – ability to view commands that would be blocked by Database Vault, but without actually blocking them;
Online Data Encryption – Previously, encrypting existing data had to be done offline, but now it can be done online.
For a complete list of new features in Oracle Database 12.2, visit: https://goo.gl/z6KGP6
EBSDBA is an Oracle Platinum Partner with several specializations in Oracle Database 12c, and can support your company in planning and upgrading to this new version. Visit our website and learn about all our solutions: http://bit.ly/2kbf7sf
