The Hunger Site

Thursday, October 15, 2015

Managing Oracle Database 12c with Enterprise Manager – Part XVIII


We are discussing the management of Oracle Database 12c in Oracle Enterprise Manager 12c. In our previous blog post on this topic, we looked at Information Lifecycle Management (ILM) in Database 12c, and we will now see how Enterprise Manager helps with that.
Enterprise Manager Cloud Control 12c allows the management of ILM in Database 12c. This was enabled via the DB Plug-in release 12.1.0.5 released 4 months after Enterprise Manager PS2  i.e. Release 3 (released in July 2013).  The DB plug-in release 12.1.0.5 was in October 2013.
The following was included in the Oct. 2013 release:
  • ILM Heat Map for DB & Tablespace
  • ILM Administration feature to setup ILM policy on Tablespace & Objects
Note that Automatic Data Optimization (ADO) is not supported currently on CDBs and PDBs. It only works on a non-CDB 12c database.
The first step is to change the database initialization parameter heat_map to ON as seen in the following screenshot:

This blog post was originally published at this link.

No comments:

Disclaimer

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