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 […]
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 […]
Introduction to Oracle Information Lifecycle Management (ILM)
What is Information Lifecycle Management (ILM)? Information Lifecycle Management (ILM) is the process of understanding, archiving and purging data. In short, it is a strategy for managing business data over its lifetime in order to reduce storage costs and improve data access within the database. Further, It is the practice of applying policies for the […]
Oracle Vs SQL Server: Are They So Different?
Before Christmas I was asked to compare SQL Server against Oracle. So I thought that would make a good SQL Server versus Oracle post. Although I have thought about this over years as I have worked with clients that have had both SQL Server and Oracle, when you sit down to write down and convey […]