Data Dictionary
>
FPSBASE Views
> FPSBASE.WIP_WAFER_HIST_LOOP
View FPSADMIN.ADM_RUNNING
Frequently used query which just filters ADM_LOAD_STATUS_ACTIVE view for objects and jobs that are currently running. When this view return no rows that indicates that ETL has successfully been turned off. Because this uses V$SESSION permissions cannot be granted so this cannot be used in SYSMNTR.
|
Column |
Comment |
|---|---|
|
SECONDS |
|
|
LAST_START_TIME |
|
|
SID |
|
|
LOAD_JOB |
Name of load job (* inherited from FPSADMIN.CFG_JOBS) |
|
COMPONENT |
|
|
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) |
|
LAST_MSG_CODE |
|
|
LAST_SHORT_MSG |
|
|
METHOD |
Method used to load data in table or execute procedure (* inherited from FPSADMIN.GEN_LOAD_METHODS) |
|
OBJ_TYPE |
|
|
OBJ_OWNER |
|
|
OWNER |
|
|
APPLICATION |
Application that the user is allowed or able to log events. (* inherited from FPSINPUT.GEN_USERS) |
|
LOAD_JOB_FOR_JOB |
|
|
WARN_DURATION_SEC |
|
|
WARN_DURATION_SEC_MSG |
|
|
LAST_LONG_MSG |
|
|
KILL_QUERY |