How to check for Database Option and Management Pack usage

How do you check for Database Option and Management Pack usage? There are two scripts available from Oracle for this purpose. They are :
1. option_usage.sql
This script outputs database option usage and management pack usage by a database target
2.  used_options_details.sql
This script will output the features used by each database option and management pack.
You can get these two scripts from Document ID 1317265.1 in My Oracle Support. The (more...)

Managing Oracle Database 12c with Enterprise Manager – Part XXI


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 the tablespace level Heat Map in Database 12c, showing which objects were accessed with a full table scan. We now move to the Policy tab.
Information about the Compression and Storage policies is displayed. There are 2 storage policies present. Only one object has a policy enabled.  Drill down (more...)

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. (more...)

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, (more...)

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  (more...)