Data Dictionary
>
FPSADMIN Views
> FPSADMIN.WIP_WAFER_HIST_LOOP
View FPSADMIN.ADM_SQL_W_RECENT_TREND
Useful query to compare history from ADM_LOAD_HIST with the SQL statistics from DBA_HIST_SQLSTAT for a particular object. The elapsed from SQLSTAT should closely match the avg_sec from ADM_LOAD_HIST for each hour. Executions_delta should match num_loads as well. SQLSTAT goes by hour so unlike other ADM_RECENT_TRENDS view you cannot edit to group by day however you can (and must) edit the name of the object to be evaluated. You can also extend the range longer than two days. There is a configuration in Oracle of how many days history to save in SQLSTAT which is often set to 7 and we could modify to extend this if we wish.
|
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) |
|
ROUND_TIME |
|
|
VERSION |
|
|
EXECUTIONS_DELTA |
|
|
CPU |
|
|
IOWAIT |
|
|
ELAPSED |
|
|
DISK_READS |
|
|
PHYS_READS |
|
|
PHYS_WRITES |
|
|
READ_WRITE |
|
|
NUM_LOADS |
|
|
AVG_SEC |
|
|
STDDEV_SEC |
|
|
MIN_SEC |
|
|
PERC10 |
|
|
PERC20 |
|
|
PERC30 |
|
|
PERC40 |
|
|
MED_SEC |
|
|
PERC75_SEC |
|
|
MAX_SEC |