Oracle Database has always given an ease to its customers’ efforts to standardize, consolidate, and automate database services on-premises and the cloud. Imagine a situation where you have to create two different schemas in the same databases, but both with the same name. A typical example is in the case of an application which has a specific schema name, let’s say, SYSRMS and this can’t be changed. So if you want to install two RMS applications in the same database, you will soon discover that it’s not possible since you can’t have two schemas named SYSRMS in the same database. So, what’s next?
Well, you can create two different databases. In fact, prior to Oracle Database 12c, that was your only choice. But with two different databases comes two different sets of overheads – two Oracle instances (the memory areas such as SGA and the processes such as pmon and smon) which consume memory and CPU cycles in the host. The more databases you have, the more the CPU and memory usage, all because you want to create multiple schemas in the same name. Switching to Database Consolidation in Oracle 12c will bring cost and management benefits as it enables us to save energy, space, time and money.
Database consolidation is a key step in the journey to the cloud. Oracle Database 12c makes the process far faster and simpler, enabling the high density of schema-based consolidation, without changing the existing applications.
To make this possible, a single, multitenant container database can now host many ‘pluggable’ databases. Each database that is consolidated or ‘plugged into’ the multitenant container handles applications in exactly the same way as the pre-consolidated version. Besides speeding up the journey to the cloud, consolidation also simplifies management. This is a huge advantage to organizations now managing hundreds or even thousands of databases by doing Oracle DBA training.
Let’s have a look at some new and important features of Oracle Database 12c.
- Database Consolidation
Oracle Multitenant is a new option in Oracle Database 12c. The multitenant architecture enables an Oracle database to contain a portable set of schemas, objects, and related structures that appear logical to an application as a separate database.
- Back up CDB and PDB
In Oracle Database 12c, you can still perform the same types of backups. The new level for backing up data is the PDB level.
- Heat Map and Automatic Data Optimization
Heat Map and Automatic Data Optimization are two new features of the Oracle Advanced Compression option for Oracle Database 12c. Heat Map automatically tracks data modification and query time stamps, providing details about how data is being used. It collects statistical information on the usage frequency or ‘heat’ of a segment, such as a table or a partition.
Multiple storage tiers enable organizations to store hot (active), warm (less active), and cold (historical and archive) data on the appropriate high-performance, high-capacity, or low-cost/low-performance storage.
Automatic Data Optimization storage tiering policies enable automatic data movement to a lower-cost storage tier or to a higher-performance storage tier. These policies are applicable only at the segment level and cannot be specified at the row level.
- Data Redaction in Oracle Database 12c
Oracle Data Redaction is one of the new features introduced in Oracle Database 12c. This new feature is a part of the Advanced Security option and enables the protection of the data shown to the user in real time, without requiring changes to the application.
Oracle Database 12c applies for protection at query execution time. The stored data remains unchanged, while the data to be displayed is transformed on the fly before leaving the database.
- Invisible Columns in Oracle Database 12c
In Oracle Database 12c, table columns can be defined as invisible either during its creation with the CREATE TABLE command or by modifying existing table columns via the ALTER TABLE statement. By default, table columns are always visible. Once a column has been set to invisible, it can be reverted back to visible using the ALTER TABLE statement.
Like the above-mentioned features, there are many more in Oracle Database (12c) that customers can leverage when it comes to security, performance and all other aspects that affect the company’s IT environment.
Author: Karan Dodwal
(OCM, Cloud Architect) Asst Technical Manager