Data Dictionary
>
FPSBASE Views
> FPSBASE.WIP_WAFER_HIST_LOOP
View FPSADMIN.ADM_LARGE_OBJECTS
This query shows all non-system segments in the database sorted by the largest first. It includes dev only objects and objects in the recycle bin.
|
Column |
Comment |
|---|---|
|
ROWNUM_BY_SIZE |
|
|
OWNER |
|
|
SEGMENT_NAME |
|
|
PARTITION_NAME |
|
|
SEGMENT_TYPE |
|
|
TABLE_NAME |
|
|
TABLESPACE_NAME |
Tablespace to configure the SysMonitor alert limits. (* inherited from FPSAPP.SYSMNTR_C_TABLESPACE_ALERT) |
|
IS_DEV_ONLY |
|
|
NUM_ROWS |
|
|
AVG_ROW_LEN |
|
|
SIZE_MB |
|
|
BLOCKS |
|
|
EXTENTS |
|
|
LAST_ANALYZED |
|
|
LAST_DDL_TIME |
|
|
ORIGINAL_NAME |
|
|
DROPTIME |