The Hunger Site

Thursday, October 15, 2015

Managing Oracle Database 12c with Enterprise Manager – Part XIX

We are discussing the management of Oracle Database 12c in Oracle Enterprise Manager 12c. In our previous blog post on this topic, we started to look at how Enterprise Manager helps with Information Lifecycle Management (ILM)in Database 12c. We changed the database initialization parameter heat_map to ON.
As the next step, we can add an Automatic Data Optimization (ADO) Policy by editing an Existing Tablespace as shown in the following screenshot.
In this case, we have selected the USERS tablespace, and are specifying a segment level Storage Tiering policywhereby we move newly created (from here on) objects in the tablespace  to a second tier storage tablespace, if the object has not been modified upto a period of 3 months.
The second tier is built on a more economical storage system, as opposed to the first tier high performance storage system. After creating the ADO policy in this manner, if we create a new table in the same tablespace, it will inherit the tablespace ADO policy .
Or, we can add an ADO Policy by editing an Existing Database Object:
This allows you to add a new ADO Policy to an existing database object.

This blog post was originally published at this

No comments:


Opinions expressed in this blog are entirely the opinions of the writers of this blog, and do not reflect the position of Oracle corporation. No responsiblity will be taken for any resulting effects if any of the instructions or notes in the blog are followed. It is at the reader's own risk and liability.

Blog Archive