Data Dictionary
>
FPSINPUT Views
> FPSINPUT.WIP_WAFER_HIST_LOOP
View FPSADMIN.RECENT_VARIATION_BY_OBJECT
Useful query to rank the objects where the time to load the object is highly variable. For now this is just a saved query to run when interested. Because this uses the same base query as SYSMNTR_OOC_AND_REPEATED perhaps some we might add some automatic alerts within that view if we could have confidence in these results.
|
Column |
Comment |
|---|---|
|
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) |
|
LOAD_JOB |
Name of load job (* inherited from FPSADMIN.CFG_JOBS) |
|
N |
|
|
COEFF_OF_VAR |
|
|
AVG_SEC |
|
|
STDDEV_SEC |
|
|
MIN_SEC |
|
|
PERC10 |
|
|
PERC20 |
|
|
PERC30 |
|
|
PERC40 |
|
|
MED_SEC |
|
|
PERC60 |
|
|
PERC70 |
|
|
PERC80 |
|
|
PERC90 |
|
|
MAX_SEC |