Managing Oracle Database 12c with Enterprise Manager – Part XX

We are discussing the management of Oracle Database 12c in Oracle Enterprise Manager 12c. In our previous blog post on this topic, we used Enterprise Manager and added Automatic Data Optimization (ADO) policies that enforceInformation Lifecycle Management (ILM) in Database 12c.

To view all the ADO policies and the Heat Map, select Administration.. Storage.. Information Lifecycle Managementfrom the 12c Database (non-CDB) Home Page in Enterprise Manager:

This displays the Information Lifecycle Management page.  The information you want is in two tabs, the Heat Map tab and the Policy tab. The Heat Map is seen below.

On this page, you can see the Database level heat map or go down to the Tablespace level, and then to the Object level.  Here we have displayed the heat map for the EXAMPLE tablespace by clicking on the "Show Additional" button and selecting this tablespace.

We have then selected a date range, and view by “Last Full Table Scan Date”. This displays the tables that have experienced a full table scan in the date range we have selected. The green color specifies that the date range did not see a very heavy access of these tables; otherwise a different color would have been used for the object that was more heavily accessed.

In the table in the bottom half of the screen, we have searched for the HR schema. A list of objects belonging to the schema is displayed, along with the associated IML policies if any, and other information about the objects.

Let us move to the Policy tab.

This blog post was originally published at this link.