data-dictionary

FPSADMIN.SYSMNTR_C_CHECKS

Data Dictionary

>

FPSADMIN Tables

> FPSADMIN.SYSMNTR_C_CHECKS

Table FPSADMIN.SYSMNTR_C_CHECKS"

In this table, we set specific configurations for various checks based on view_name. Records in this table are optional and all SYSMNTR_P_CHK views will appear in SYSMNTR_P_CHECKS. The view has default configuration to use in the case that no record exists in this table.

  • Schema: FPSADMIN

  • Tablespace: FPSDATA


Column

Type

Nullable

Comment

VIEW_NAME

VARCHAR2(30)

The name of the view uses for this check which starts with SYSMNTR_P_CHK.

ALERT_INTERVAL_MINS

NUMBER(4)

N

This is the interval in minutes between email alerts. It is normal for this to be larger than the check interval which means the web page is updated but we do not bombard everyone with alerts.

CHECK_INTERVAL_MINS

NUMBER(4)

N

This is the interval in minutes between calls to the view to check the status. The web page is always updated immediately after each call.

DESCRIPTION

VARCHAR2(256)

A description of the check which is displayed on the System Monitor web page and in email notifications.

EMAIL_LIST

VARCHAR2(1000)

N

This field can contain on or more email addresses separated by spaces. To send text messages you enter the mobile phone number in email format which is dependent on the phone service provider.

WHY_ALERT_DISABLED

VARCHAR2(256)

Any value is this field will disable sending email alerts for this check but please write the reason why it is disabled even if this is temporary.