Wednesday, 25 September 2013

12c enhancements continued

12c is the most significant database release in the last 7 years from oracle.  Then enhancement list is SIGNIFICANT, analogous to when RAC was released.

You already know of in-memory (TimesTen) databases and also multitenant, here is a few more items included in the latest release.

Disk heat map

The latest oracle database release,12c has got a heat map for data, you can use the data from the heat map and decide what you are going to do with the data.  You can set policies on when data is compressed and destination of the data.  12 compression options are Advanced row, columnar query & columnar archive compression.

Remember that you can expose the heat map through 12c cloud control or through EM for the standalone database.

Hot - 3x - advanced row compression
Warm - 10x - Columnar Query compression
Archive - 15x - Columnar archive compression

You do not need the advanced compression option to run row compression.  You do however need this database option to enable the columnar compression.

Active Data Guard for Far Sync

far sync is a combo of sync and async.  Just an instance that has the redo logs, a "handoff point".  sync to the far sync instance.  Then you have async to the standby.

Need active data guard licence.

Far sync is basically included with your ADG and EE licensing.

Global Data Services

Load balancing and service failover for replicated databases.  Can coordinate read requests between data centres.  Routing and failover of reads.  Note that this might force a read from the primary.

Transaction Guard

API knows commit outcome for every transaction, could replay the transaction if there was a failure.  There is a token with every transaction.  This can run in the JDBC driver.  IT can watch for the transaction state.  This can preserve and retrieve commit status'.

Data Redaction

Data masking.  Replace sensitive application data when replicating databases.  12c you can subset and mask "in-flight".  Data Redaction works on the display of sensitive data.  Transparent to applications users and operational activities.  This is enforced at the database.  This would be great for JD Edwards. This is a feature of the "Advanced Security" database option.

Database Activity Monitoring and Firewall

enhancement to audit vault to add the firewall capability.  Can be used on different databases.






No comments:

Extending JDE to generative AI