In my previous blog , I was talking about five important features of oracle database 12.2. In this blog I am going to continue the discussion and talk about 5 more important features for the oracle database version 12.2. Lets start with the sixth item now.
The sixth feature is the real time refresh . In addition to ON COMMIT and ON DEMAND refresh, the materialized join views can be refreshed when a DML operation takes place, without the need to commit such a transaction. This is done at the statement level, so it does not update the MV itself. If we query the MV directly, we can also use the FRESH_MV hint to do the same and get the up-to-date data. During the process of retrieving the recent data, Oracle merges the MV log data with the MV itself to return the correct result.
The seventh is the Big Data Management System Infrastructure which takes care of the 4V’s of Big Data volume, variety, velocity and veracity. This feature allows more users of Hadoop to combine map-reduce processing with the essential database qualities that many applications require. It can access with any language like REST,Java,SQL,Python,R, Scala etc. it can also do analysis of any type of data like SQl , Spark, Graph, Spatial , Machine Learning etc. It can use databases like NoSQL, traditional database and Hadoop data which can be accessed by External tables. External tables are used by both SQL*Loader and Oracle Data Pump, and thus also by the ORACLE_LOADER and ORACLE_DATAPUMP access drivers. The Hadoop Distributed File System (HDFS) and Apache Hive are the other two most important data sources here.
The eighth is the hot cloning of a PDB without application outages/downtime. Cloning of a pluggable database (PDB) resolves the issue of setting the source system to read-only mode before creating a full or snapshot clone of a PDB. With this feature, you can now clone your production PDBs and create point-in-time copies for development or testing without any application outage. This feature eliminates the need to create application outages for the purpose of cloning.
The nineth is the In-Memory FastStart. In-Memory Column Store allows objects (for example, tables, partitions, and subpartitions) to be populated in-memory in a compressed columnar format. Until now, the columnar format has only been available in-memory. That meant that after a database restart, the In-Memory Column Store would have to be populated from scratch using a multiple step process that converts traditional row formatted data into the compressed columnar format and placed in-memory. In-Memory FastStart enables data to be repopulated into the In-Memory Column Store at a much faster rate than previously possible by saving a copy of the data currently populated in the In-Memory Column Store on disk in its compressed columnar format. In-Memory FastStart significantly reduces the time it takes to repopulate data into the In-Memory Column Store after a system restart. This allows businesses to start taking advantage of the analytic query performance benefits of accessing data in a columnar format faster.
The tenth is the Improving Security Posture of the Database. DB Vault is an important security feature in Oracle Database.When we implement DB vault on an existing application, there is always a chance the application will break due to some DBA/human errors. DB vault 12.2 can be enabled in simulation mode to take care of this issue in 12.2. While in simulation mode, nothing will break and subsequently can be fixed with details from the log where we see all the blocked state. Hence, we can work proactively and make sure that everything works and fix all the problems before the actual implementation.Encryption, decryption, and rekeying of existing tablespaces with Transparent Data Encryption (TDE) tablespace is possible now. A TDE tablespace can be deployed, encrypted for migration to an encrypted tablespace without any stoppages. This feature enables automated deep rotation of data encryption keys used by TDE tablespace encryption in the background again without any downtime. Encryption is important, but until now, had to be done offline for existing data. Oracle 12.2 allows online encryption and re-key operations. The command will effect a datafile, copying it to a new encrypted one, then will change the database to start using the new encrypted file, and everything will be done online. Now it is possible to encrypt internal tablespaces (system, sysaux, undo, etc) as well.
In the last 2 blogs I talked about the top 10 features for the new release for oracle 12.2. As I told in my last blog, the new features look very promising but are available in the cloud version presently. We hope it will work well in its on premise versions as well.