Data Dictionary
>
FPSAPP Views
> FPSAPP.WIP_WAFER_HIST_LOOP
View FPSADMIN.ADM_LOCKED_HIST_NOW
This view is the most used query to these tables including the current information unioned with the recent history. Another useful query (not quite useful enough to merit its own view) shows the highest temp tablespace usage in the last two days: select ts, temp_used_mb, listagg(object_name, ',') within group (order by object_name) as obj from (select distinct ts, temp_used_mb, object_name from adm_locked_hist_now) group by ts, temp_used_mb order by temp_used_mb desc;
|
Column |
Comment |
|---|---|
|
IS_ACTIVE_NOW |
|
|
TS |
|
|
PREV_EXEC_START |
|
|
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) |
|
USED_UREC |
|
|
PROGRESS |
|
|
ROWS_PROCESSED |
|
|
DISK_READS |
|
|
WRITE_MB |
|
|
SQL_ID |
|
|
TEMP_USED_MB |
|
|
TEMP_FREE_MB |
|
|
UNDO_USED_MB |
|
|
UNDO_FREE_MB |
|
|
NUM_SESSIONS_INCLUDING_SYS |
|
|
MAX_SESSIONS_ALLOWED |
|
|
NUM_USER_SESSIONS |
|
|
NUM_FPS_SESSIONS |
|
|
SESSION_LIST |