How to Use Temporal History in Oracle 12c to Track Changes Over the Lifetime of a Table

In this posting, we are continuing with the theme of Information Lifecycle Management (ILM). As mentioned in an earlier posting, there usually comes a point during the lifecycle of the data when it is no longer being regularly accessed: May be obsolete and is eligible for purging Might be needed in the future but could […]
Read More ›

How to Use In-Database Archiving

In this posting, we are continuing with the theme of Information Lifecycle Management (ILM).  Another option in Oracle 12c, is In-Database Archiving, also called Row Archival. Why In-Database Archiving The simple goal of in-database archiving is to assign values to the data based on business rules of whether the data is current or marked as […]
Read More ›

How to Manage Automatic Data Optimization (ADO)

In this last posting on Automatic Data Optimization, we will look at issues related to monitoring and managing Automatic Data Optimization (ADO).  Displaying Automatic Data Optimization (ADO) Policies Several dictionary views are available to verify configured policies. DBA_ILMPOLICIES provides the list of all policies and their respective ENABLED status:The DBA_ILMDATAMOVEMENTPOLICIES view contains information specific to data […]
Read More ›

Guide to Creating Automatic Data Optimization (ADO) Policies

Defining Automatic Data Optimization (ADO) Policies In the previous posting, we discussed enabling Heat Map. The next step is to create the ADO policies. The policies: Define WHICH condition fires an action; for example: Low data access No access No data modification (updates/deletes/inserts on row or DDL ALTER statement on a segment) Object/row creation Define […]
Read More ›

How to Use Heat Map in Automatic Data Optimization (ADO)

Heat Map and Automatic Data Optimization (ADO) Oracle Database 12c allows for activity tracking with Heat Map. This tool provides the ability to track and mark data as it goes through life cycle changes (see my previous blog on Information Lifecycle Management). Data accesses are tracked at the segment-level (table, index, etc.). Data modifications tracked at […]
Read More ›

Type to search blog.learningtree.com

Do you mean "" ?

Sorry, no results were found for your query.

Please check your spelling and try your search again.