Data Dictionary
>
FPSBASE Tables
> FPSBASE.ADM_LOCKED_HIST
Table FPSBASE.ADM_LOCKED_HIST"
This is a snapshot every minute of queries which have locked a table longer than one minute. It shows the temp space usage, undo space usage, progress, and other metrics to help us track our database stress over time.
-
Schema: FPSBASE
-
Tablespace: FPSDATAHIST
|
Column |
Type |
Nullable |
Comment |
|---|---|---|---|
|
DISK_READS |
NUMBER |
||
|
MAX_SESSIONS_ALLOWED |
NUMBER |
||
|
NUM_FPS_SESSIONS |
NUMBER |
||
|
NUM_SESSIONS_INCLUDING_SYS |
NUMBER |
||
|
NUM_USER_SESSIONS |
NUMBER |
||
|
OBJECT_NAME |
VARCHAR2(30) |
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). (* from FPSADMIN.CFG_DISABLED) |
|
|
PREV_EXEC_START |
DATE |
||
|
PROGRESS |
VARCHAR2(81) |
||
|
ROWS_PROCESSED |
NUMBER |
||
|
SESSION_LIST |
VARCHAR2(1000) |
||
|
SQL_ID |
VARCHAR2(13) |
||
|
TEMP_FREE_MB |
NUMBER |
||
|
TEMP_USED_MB |
NUMBER |
||
|
TS |
TIMESTAMP(6) |
||
|
UNDO_FREE_MB |
NUMBER |
||
|
UNDO_USED_MB |
NUMBER |
||
|
USED_UREC |
NUMBER |