Posted on February 4, 2016 by Erik Benner
Tags: Oracle, 12c, Oracle Database
With Database 12.2 around the corner, 11G desupport looming and security being a bigger part of the picture, it’s time to revisit the questions around upgrading to Database 12c. Database 12c offers new features, many that are included in the base product and do not require any additional licenses. With recent security breach's making, and staying on the front page of the news, security is becoming more and more import to both Commercial clients as well as Public Sector users of the database technology. There are several new features in Database 12c that can and will help you secure your data from not only casual theft, but also the more serious theft of entire data structures.
- Integrated Data Redaction, allowing you to mask data at the source, protecting sensitive or regulated data without application changes. Easily mask Personal Identifying Information from older applications, and users with direct database access.
- Auditing enabled by default, allowing audit policies to be edited with no downtime.
- NIST FIPS 140-2, supporting the National Institute of Standards and Technology’s Federal Information Processing Standards 140-2, Security Requirements for Cryptographic Modules. This enables the Database Administrator to encrypt the data at the source. Combine this with for hardware acceleration in SPARC architecture for hardware accelerated Encryption.
- Separation of Duty - For Administrative access including Data Guard, Audit, Admin, SYSBACKUP and more. Allowing admin and audit functions without full SYSMAN access. Combine this with Enterprise Manager 13c Flexible Access Control for granular administrative access to the database.
A Secure Database is only part of the story, with Database 12c new features become available to both the Database Administrator and the Application Developer to improve the resilience of the application.
- Application Continuity – Application independent recovery of incomplete requests, essentially a replay of the transaction. There is no more confusion about a transactional request executing against the database if an outage occurred while the request was being processed. The Application Continuity masks database outages that can be safely masked form the users.
- Transaction Guard – Go a step beyond Application Continuity, and make the application aware of the commit outcome of in-flight transactions. This leverages a logical transaction IDs to recover transactions after an outage, when Application Continuity cannot mask the outage.
- Move data files while online, enabling the database administrator to reallocate disk space without taking the database offline.
- Flex Clusters – Database and Application control from a single cluster, enabling Clusterware to control the application tier in the event of a database cluster event. This will become more important in Database 12.2.
- Flex ASM – Removing the 1 to 1 ration of ASM instances to database instances. This enables an ASM instance to be patched, with ANY database having to be taken offline.
- Data Guard Far Sync- Enable Zero Data Loss regardless of WAN latency. You can now safely Data Guard across the globe, giving you more options as to where your disaster recovery site can be located.
Now that your more secure, and have achieved higher levels of availability you can start to leverage new features in Database 12c to improve application performance and reduce the time it takes to run down performance issues!
- Advanced Network Compression – Compress data between the client and server, effectively speeding up the network with no hardware upgrades. This provides great performance improvements for Data warehouse and Business Intelligence Applications.
- Asynchronous I/O for Direct NFS, which improves database performance. Often Direct NFS is faster than older SAN technologies or iSCSI.
- Track I/O Outliers using V$IO_OUTLIER, reducing the time to resolve disk performance issues on Solaris Servers. This enables the Database Administrator to quickly identify LUNs that are causing performance issues. Quickly identify a RAID5 LUN in an ASM disk group just based on the write performance.
- Rapid Home Provisioning – Create and manage Golden Images for your $ORACLE_HOME, reducing provisioning and patch times.
Without applications we would not have the need for database. In Database 12c, there are several new features that are targeted for the application developers.
- RESTFUL calls to the database, which let the developer quickly write custom interfaces to the database.
- APEX 5 – Supporting Mobile Applications, A new Page Designer and more! Rapidly develop Web apps faster than ever!
- Unicode 6.1 support – Universal character set that covers most of the languages of the world.
Of course, with 12c you have access to new Packs and features that require additional licensing, but many of these can save your agency more than they cost!
- In-Memory Database – All the advantages of RAM performance, with no application changes. Run OLTP and DW on the SAME Database
- Automatic Data Optimization – Tier Storage technology that lets you easily define rules to both compress and tier the blocks of data. No more need to develop complex partitioning rules that try to outsmart the users.
- Database Multitenant – Virtualization at the Database level, reducing operation expenses and achieving higher consolidation ratios. Did you know, that everyone gets one FREE PDB! You can take advantage of the portability of Pluggable Databases without Multitenant!
These are just a small sample of all the new features built into Database 12c. For more information on how you can upgrade to the power of Database 12c, contact Mythics today and we can help answer any questions you may have about your database needs.
Erik Benner, Enterprise Architect, Mythics Inc.