OOW Day 1: Oracle OEM Database Express 12c & Extreme Database Management

My second session today was about Oracle Extreme Database Management with the latest generation of database technology by Leng Leng Tan, Senior Vice President of Oracle Development.

The new Oracle database 12c announced yesterday by Larry Ellison is fully integrated with Oracle Enterprise Manager 12c. The main goal is to deliver the highest service quality with lower risk and effort.

There also is a new feature called Oracle Enterprise Manager Database Express 12c which is an embedded GUI management tool for database administration. This tool has not to be installed, it runs inside 12c, it is pre-configured and installed with the database, uses less disk storage and consumes also less memory than the old database control. The GUI interface is quite similar to EM Cloud 12c and is a subset of EM 12c Cloud features.

In short, the database self-monitors performance issues, detects bad performance trends, analyses high CPU, I/O spikes, and proactively identifies a problem before it threatens the application performance.

An interesting new feature also comes with the future Oracle 12c database, it concerns data masking. We often have to copy production data to test environment and it is necessary to mask the data in the test environment. Before Oracle 12c, the production data was copied then masked. Now the sensitive data is masked at the source before it leaves the production DB. The staging copy is no more required.

Oracle announced a high performance data masking with an Oracle 12c database based on a benchmark realized on an exadata v2.2 full rack. For example: 600 billion row table masking in 33 minutes!