Data Dictionary
>
FPSADMIN Views
> FPSADMIN.WIP_WAFER_HIST_LOOP
View FPSADMIN.ADM_LOCKED_STATUS
This view is a snapshot of queries which have locked a table longer than one minute. It shows the temp space usage, undo space usage, progress, and other metrics. We record this in ADM_LOCKED_HIST every minute to help us track our database stress over time.
|
Column |
Comment |
|---|---|
|
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 |
|
|
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 |
|
|
ROWS_PROCESSED |
|
|
DISK_READS |