There are several methods to monitor database performance, but EM is probably the most frequent used today.  Oracle Enterprise Manager Cloud Control is designed to manage the entire Oracle environment: database, server, middleware, and more.  OEM Cloud control requires additional licensing, however EM Express is provide free with Enterprise editions.

EM Express can be used to manage a single Oracle 12c database and it is actually built into the database.  EM Express is a light weight management console and provides basic administrative tasks with minimal impact to database operations.  EM Express has no background processes and it gathers information from already existing database stores.  The Performance Hub of Express provides the following abilities:

1. ASH Analytics.
2. SQL Monitor
3. ADDM
4. Workload metrics.
5. Resource usage
6. See real-time and historic data.
7. In historic mode AWR (Automatic Workload Repository) data is used.
8. Performance Hub tabs are
   1. Summary – real-time mode
   2. Activity – ASH analytics both real-time and historic.
   3. Workload – info about Top SQL
   4. RAC – RAC specific metrics.
   5. Monitor SQL – current and historic SQL executions.
   6. ADDM – ADDM reports both real-time and historic
   7. Current ADDM findings – performance analysis of last 5 minutes.

Larry Catt

OCP

Oracle 12c Automatic Diagnostic Repository (ADR) provides files to store diagnostic information about the health of the database.   This release has added two new log files to add in administration of the RDBMS suite:  DDL Log File and Debug Log File.

NEW DDL Log file – The new DDL log file has the same format and behavior as the alert log.  When the ENABLE_DDL_LOGGING parameter is set to TRUE, DDL statements are written out to the DDL log file.  Two log files are maintained:  XML and plain text.  Log files are stored in the /log/ddl directory of the ADR home and are included in IPS incident packages.

Debug Log – the debug log records unusual incidents that do not impact normal operations.  They are occurrences which do not warrant an entry in alert log or incident report.  The debug log has the same format as alert log.

Larry Catt

OCP