Short list of innovations in Oracle 12c

An hour ago, there was an On-line presentation of the 12th version of the Oracle RDBMS.
On YouTube slammed in good quality

Too lazy to watch and translate - briefly squeeze in a post.

The concept of the 12th version:
Generally 12c means CLOUD - the bottom line is that it is proposed to merge all your databases (PluggableDB = PDB) into a single cloud (CloudDB = CDB)
The technology itself is called the Multitenant Database.
Important - all pdb db. updated to version 12c.
Up to 255 PDB can be connected to a single CDB.
')
DBA Chips:

The patch rolls 1 time on all CDBs - then it replicates to all PDBs automatically.
2 PDB combined in CDB can be MERGE.
ONLY 1 general backup is written to all PDBs. Rolled too 1 time at once on everything.
The Privileges Analysis utility allows you to track issued rights and roles, to prevent “extra” rights.
The service process DataOptimization - compresses the "cold" blocks of tables.

The main features of the encoder (there are more than 500):

New data type for PK - Identity. Itself creates a sequence, which (apparently) creates a trigger Before Insert and pulls it.
A similar thing has long been in PostgreSQL - called SERIAL.
NOT NULL a field can now be assigned a DEFAULT VALUE even if it has data. NULL cells will instantly update to DEFAULT
DB type VARCHAR expanded from 4000 char to 32000 char (as in PL / SQL)
In the queries, you can select any lines by numbers - select ... TOP 10 or choose 3.5 and 10 lines
New format f-ii syntax in regular expressions (you can do a flexible search).
On-line movement of partitions of tables (you no longer need to stop Instance, everything gives on the fly).
Explain plan is optimized, takes into account statistics, and hot blocks (see the feature HeatMap).
New types of histograms when collecting statistics tables.
Logs are no longer written to UNDO and REDO from TEMPORARY tables. Now these logs are written in temporary tables themselves.
HeatMap feature (map of calls) - collects statistics of calls to each block. There are 3 types: HOT, WARM, COLD.
Moves the “hot” blocks in front of the “cold” and “warm” ones. Places this data in table statistics. Further takes into account when reading.
Feature Transaction Guard - prevents repeated transactions like "finger trembled, pressed 2 times."

Source: https://habr.com/ru/post/186268/

All Articles

Short list of innovations in Oracle 12c

More articles: