Its newest version eases standardization, consolidation and automatization tasks of cloud database services. Expenses drop and better management flexibility are its main advantages.
We are used to Oracle software continue improvements, 12c appearance isn’t an exception. Oracle presents huge advantages. The simplification on data consolidation process in the cloud is one of the most noticeable modification. These allows clients to manage several database as a single one, without require to alter their applications.
Security is another remarkable feature: threats on data privacy are contained and new regulations on the issue are adopted. At the same time, 12c version maximizes protection over server and site failure, human mistakes, inactivity timeout and continuity of applications. It introduces Pluggable database design for databases. In this way, having reunited all the information, database can be disconnected from an instance and connect to a new one in seconds.
Expd and impdp tools presents several improvements. These Oracle tools to import and export objects from a database, now allow to export data in a simple way, enabling move tables between instances.
A new benefit is the incorporation of the 32k VARCHAR column, which supports 32k data, in the same way as a BLOB type, text orientated. Also is possible to use the WITH clause in PL/SQL. Throughout time, Oracle developments has included permanent improvement. Since Oracle 10g database motor made progress, so it was born the idea of having several database in a group of servers with splintered storage.
Later, version 11 g allowed some components to be automatically re initiated, also introduced Automatic Storage Management (ASM), a simpler database storage management. Doubtlessly version 12c will turn database management, until Oracle surprise everybody with new improvements.