Study Health Monitor profile values

The Study Health Monitor provides administrators with details on data loads, transformations, validation checks, and discrepancies. It comes with certain data values set. For example, for file loads, transformation, and validation check jobs, Oracle DMW defaults to showing the details for the last day (24 hours), but you can change it.

You can also change the values to calculate long-running jobs for InForm data loads, file loads, transformations, or validation checks. And, you can change the amount of time that the Study Health Monitor retains the data. See the following table for details on the profile values. To change the default values, see Change the Study Health Monitor profile values.

Note:

You can open the Study Health Monitor through the Navigation menu. The Study Health Monitor refreshes its data every 15 minutes. If you want to change the data refresh frequency, you must run the dmeDashboardSchChg.sql script that came with Oracle DMW. See Change the Study Health Monitor data refresh frequency for details.

Profile Name	Description	Default Value
DMW_DASH_STATISTICS_DAYS	Number of days to display the details for Other File Loads, Transformation Jobs, and Validation Check jobs.	1 (24 hours)
DMW_DASH_PCT_FOR_LONGJOB_INF	Percentage of time used to calculate against the time it took to run the last successful job and determine long-running jobs for InForm Loads.	30%
DMW_DASH_THR_FOR_LONGJOB_INF	Number of minutes used to calculate against the time it took to run the last successful job and determine long-running jobs for InForm Loads.	60 minutes
DMW_DASH_PCT_FOR_LONGJOB_FILE	Percentage of time used to calculate against the time it took to run the last successful job and determine long-running jobs for Other Data Loads.	75%
DMW_DASH_THR_FOR_LONGJOB_FILE	Number of minutes used to calculate against the time it took to run the last successful job and determine long-running jobs for Other Data Loads.	5 minutes
DMW_DASH_PCT_FOR_LONGJOB_XFM	Percentage of time used to calculate against the time it took to run the last successful job and determine long-running jobs for Transformation Jobs.	30%
DMW_DASH_THR_FOR_LONGJOB_XFM	Number of minutes used to calculate against the time it took to run the last successful job and determine long-running jobs for Transformation Jobs.	60 minutes
DMW_DASH_PCT_FOR_LONGJOB_VC	Percentage of time used to calculate against the time it took to run the last successful job and determine long-running jobs for Validation Checks.	30%
DMW_DASH_THR_FOR_LONGJOB_VC	Number of minutes used to calculate against the time it took to run the last successful job and determine long-running jobs for Validation Checks.	60 minutes
DMW_DASH_DATA_RETENTION_DAYS	Number of days the Study Health Monitor retains the data in Oracle DMW.	7 days

• Change the Study Health Monitor profile values
  If you access the Study Health Monitor (under the Navigation menu), you can view details on data loads, transformations, validation checks, and discrepancies.
• Change the Study Health Monitor data refresh frequency
  The Study Health Monitor refreshes the data for all the studies in the Production life cycle every 15 minutes by default. If you want to change the data refresh value, you need to run the dmeDashboardSchChg.sql script that came with Oracle DMW.