Data Dictionary
>
FPSBASE Views
> FPSBASE.WIP_WAFER_HIST_LOOP
View FPSADMIN.ADM_SQL_TOP_SNAPSHOT
The view DBA_HIST_SQLTEXT is a powerful diagnostic tool for investigating top queries if we have access. We adapted this query from the internet page named Ultimate Top 50 SQL / AWR Query. This is identical to ADM_SQL_TOP_LAST_DAY but for the time filter in the snap with clause.
|
Column |
Comment |
|---|---|
|
SHORT_SQL_TEXT |
|
|
SEC_PER_EXEC |
|
|
EXECUTIONS |
|
|
100 |
|
|
EXEC_PCT |
|
|
100 |
|
|
ELAPS_PCT |
|
|
100 |
|
|
CPU_PCT |
|
|
100 |
|
|
READ_PCT |
|
|
100 |
|
|
BUF_PCT |
|
|
RANK |
Rank is a single character like P for primary or A for alternate or S for setup. The ranks defined in perm, temp, extl_rank columns in RTG_TOOL_ASSIGNMENTS tables are in RTG_PERM_RANKS. The ranks defined automatically in WIP_STEP_FUT_ASGN views are in RTG_CURR_RANKS. All ranks are defined by FPS and the specific values are used in the Scheduler therefore we must translate in the ETL to assign to the most appropriate perm_rank. (* inherited from FPSADMIN.RTG_PERM_RANKS) |
|
SQL_FULLTEXT |