Data Dictionary
>
FPSADMIN Views
> FPSADMIN.WIP_WAFER_HIST_LOOP
View FPSADMIN.SYSMNTR_SLOW
This view highlights objects which are taking too long to load. We consider an object to be slow if both the average and the last run took longer than the warning limit. If the current run is in progress then we use only the average. If we do not have an average (no successful complete in last three days) then use only the last/current run.
|
Column |
Comment |
|---|---|
|
OWNER |
|
|
OBJECT_NAME |
This could be an object name (we will disable loading of that object in the scheduled jobs), a load job (we will disable loading of all objects in that scheduled job), an FPSAPP prefix (we will disable loading of all objects with that prefix), a constraint (we can explain why it is permanently disabled), or a trigger (technically an object so we can get away with omitting this from the column name and also to explain why it is permanently disabled). (* inherited from FPSADMIN.CFG_DISABLED) |
|
COMPONENT |
|
|
METHOD |
Method used to load data in table or execute procedure (* inherited from FPSADMIN.GEN_LOAD_METHODS) |
|
IS_DISABLED |
|
|
PROBLEM |
|
|
SQL_QUERY |
|
|
LAST_START_TIME |
|
|
LAST_SUCCESS_TIME |
|
|
LAST_FAIL_TIME |
|
|
LAST_SHORT_MSG |