2 Health Check Dashboard

After logging into DMT, you are taken to the Health Check Dashboard. This screen gives you a high-level overview of your Oracle DMW environment and is divided into four sections: DP Server, Queues, Database, and Database Performance.

DP Servers

The tiles displayed in this section lets you know whether or not the Distributed Processing (DP) servers are running, as well as the location of each server.

Queues

Tiles in the Queues section of the dashboard show the status of the Job Queue and Message Queue. Clicking on a tile opens the log for the respective queue, where you can download the log from the Actions drop down menu.

Database

You can view the availability of the database(s) in this section of the page. Clicking on a tile opens the DB Reboot screen, where you can view and download the log history of database reboots.

The Errors subsection gives you a quick visual indication of any alerts that may need your attention:
  • Critical: These are typically internal errors, such as ORA-00600.
  • Severe: Examples of severe errors include operating system exceptions (ORA-07445) or issues like "out of memory in the shared pool" (ORA-04031).
  • Incident: An "incident" is classified as a single occurrence of a system problem.
  • Other: Errors that cannot be put into any of the above categories.

If any of the error tiles are displayed with a red icon, you need to check the alert log for more details.

Database Performance

Tiles in this section are displayed with a red icon when any of the following issues are present:
  • CPU Utilization: The OS run queue is greater than the number of available CPUs.
  • CPU Utilization (Last 1Hr): The average load in the past hour is more than number of available CPUs.
  • Locks: A session has been blocked for more than one minute.
  • Wait Event Impact: A session is waiting on a non-idle event for more than one minute.