Data Dictionary
>
FPSAPP Views
> FPSAPP.WIP_WAFER_HIST_LOOP
View FPSADMIN.ADM_LOCKED_SUMMARY
This view gives information about the space available in the TEMP and UNDO tablespaces. It is formatted all in one row so that it can be cross joined to insert into log files. This query helps diagnose the cause when we encounter the dreaded "ORA-01652: unable to extend temp segment by 128 in tablespace TEMP" error plus the comments contains some more details and information.
|
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) |
|
SQL_ID |
|
|
IS_ACTIVE_NOW |
|
|
NUM_RECORDS |
|
|
FIRST_TS |
|
|
LAST_TS |
|
|
DELTA_TS |
|
|
MAX_TEMP_USED_MB |
|
|
MIN_TEMP_FREE_MB |
|
|
MAX_UNDO_USED_MB |
|
|
MIN_UNDO_FREE_MB |
|
|
USED_UREC |
|
|
MAX_ROWS_PROCESSED |
|
|
MAX_DISK_READS |
|
|
MAX_WRITE_MB |