Data Dictionary
>
FPSAPP Tables
> FPSAPP.ADM_KILL_HUNG_SESSIONS_LOG
Table FPSAPP.ADM_KILL_HUNG_SESSIONS_LOG"
Log table that stores the results of ADM_SESSIONS_PROBLEM where SHOULD_KILL = Y. If a session is allowed to be killed based on IS_AUTO_KILL_ALLOWED, then the session was marked for kill when this record was logged.
-
Schema: FPSAPP
-
Tablespace: FPSDATAHIST
-
Primary key: INSERTED_TIME, SID, SERIAL#
|
Column |
Type |
Nullable |
Comment |
|---|---|---|---|
|
INSERTED_TIME |
TIMESTAMP(6) |
N |
Timestamp field set by trigger storing SYSTIMESTAMP when record was inserted in the table. (* from FPSINPUT.WIP_EVENT_HIST) |
|
SID |
NUMBER |
N |
|
|
SERIAL# |
NUMBER |
N |
|
|
CPU_USED |
NUMBER |
||
|
DISK_READS |
NUMBER |
||
|
ELAPSED_SECONDS |
NUMBER |
||
|
IS_AUTO_KILL_ALLOWED |
CHAR(1) |
Flag indicating whether the session is allowed to be killed automatically. (* from FPSADMIN.CFG_SESSIONS_TO_KILL) |
|
|
KILL_QUERY |
VARCHAR2(119) |
||
|
LAST_UPDATE_TIME |
DATE |
||
|
LOCKED_MODE |
NUMBER |
||
|
LOCKED_MODE_MSG |
VARCHAR2(43) |
||
|
LOGON_TIME |
DATE |
||
|
MACHINE |
VARCHAR2(64) |
||
|
MEMORY_USED_IN_MB |
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) |
|
|
OBJECT_TYPE |
VARCHAR2(19) |
||
|
OPNAME |
VARCHAR2(64) |
||
|
OSUSER |
VARCHAR2(30) |
||
|
OWNER |
VARCHAR2(30) |
||
|
PREV_EXEC_START |
DATE |
||
|
PROBLEM |
VARCHAR2(4000) |
||
|
PROGRAM |
VARCHAR2(48) |
||
|
PROGRESS |
VARCHAR2(81) |
||
|
READ_MB |
NUMBER |
||
|
ROWS_PROCESSED |
NUMBER |
||
|
SHOULD_KILL |
CHAR(1) |
||
|
SPID |
VARCHAR2(24) |
||
|
SQL_FULLTEXT |
VARCHAR2(62) |
||
|
SQL_ID |
VARCHAR2(13) |
||
|
SQL_TEXT |
VARCHAR2(1000) |
||
|
STATUS |
VARCHAR2(13) |
||
|
SYS_MODULE |
VARCHAR2(64) |
||
|
SYS_PROCESS |
VARCHAR2(24) |
||
|
TARGET |
VARCHAR2(64) |
||
|
USED_UBLK |
NUMBER |
||
|
USED_UREC |
NUMBER |
||
|
USERNAME |
VARCHAR2(64) |
Field that uniquely identifies a user. (* from FPSINPUT.GEN_USERS) |