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 dmeStudyHealthSchChg.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 dmeStudyHealthSchChg.sql script that came with Oracle DMW.
Parent topic: Set profiles to determine system behavior