Instructor Insight: Automatic Data Optimization in Oracle Database 12c
By Breanne Cooley on Sep 10, 2013
With today's constant challenges of evolving data over time, administrators need to track how and whether this data has been accessed.
With Oracle 12c Automatic Data Optimization (ADO), administrators can track metrics at the segment or block level and react with a preferred automatic optimization. The administrator can choose to optionally compress if there hasn't been any access for some time and also potentially move the data to an archive area of storage.
Information Lifecycle Management Policy (ILM)
With your organization's Information Lifecycle Management (ILM) policy, the data can be separated in various ILM categories and reside in different tablespaces and datafiles. Some are highly active and provide the greatest performance access, while the older/archived data - residing in storage where it isn’t accessed as frequently - can be stored at lower cost.
Achieve SLAs and Performance Goals
With the different ADO policies, you as the administrator can achieve your SLAs and performance goals. Explore ADO policies and more by enrolling in Oracle Database 12c: New Features for Administrators. This course is available in our Training On Demand, Live Virtual Class or Classroom Training format.
-Christopher Andrews, Senior Principal Instructor,
-Christopher Andrews, Senior Principal Instructor, Oracle University