ILM features in 12c -- an overview

Exploring the ILM features in Oracle Database 12c.

Organizations need to retain and store ever larger volumes transaction data for longer intervals, and account for evolution of the data.

These needs present information lifecycle management challenges, such as.

• Storing large volumes data efficiently for very long times.
• Tracking and auditing of changes done to data, and preventing theft/tampering.

Oracle Database 12c has introduced some approaches and solutions.

A couple of the new ILM features are discussed in the links below.

Feature	Description/Link to example	Availability
		NONCDB	CDB
In-database archiving	Allows setting of specific rows (old, inactive data) in a table as archived (inactive) and invisible to applications.	Yes	Yes
Flashback Data Archive	Enhanced in 12c, this feature enables tracking of all versions of a record and its evolution over time. Capturing the session context to track a flashback archive enabled table Database hardening. The ability to import change tracking history from a user-provided table	Yes	Yes
Temporal Validity	Defines a time-based validity attribute to a record, hides from applications, those records which do not satisfy validity.	Yes	No
ILM ADO policies	Manage data as it ages, specify how data is stored, where it is stored, and what actions are needed when data meets specific criteria.	Yes	No