Data Dictionary
>
FPSBASE Tables
> FPSBASE.DBF_SESSIONS
Table FPSBASE.DBF_SESSIONS"
See comments in DBF_REF_SESSIONS view.
-
Schema: FPSBASE
-
Tablespace: FPSDATA
|
Column |
Type |
Nullable |
Comment |
|---|---|---|---|
|
SID |
NUMBER(8) |
||
|
OWNER |
VARCHAR2(30) |
||
|
OBJECT_NAME |
VARCHAR2(128) |
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(23) |
||
|
OPNAME |
VARCHAR2(64) |
||
|
CPU_USED |
NUMBER(12) |
||
|
DISK_READS |
NUMBER(12) |
||
|
ELAPSED_SECONDS |
NUMBER(12) |
||
|
LAST_UPDATE_TIME |
DATE |
||
|
LOCKED_MODE |
NUMBER(2) |
||
|
LOCKED_MODE_MSG |
VARCHAR2(64) |
||
|
LOGON_TIME |
DATE |
||
|
MACHINE |
VARCHAR2(64) |
||
|
MEMORY_USED_IN_MB |
NUMBER(12) |
||
|
OSUSER |
VARCHAR2(30) |
||
|
PREV_EXEC_START |
DATE |
||
|
PROBLEM |
VARCHAR2(512) |
||
|
PROGRAM |
VARCHAR2(64) |
||
|
PROGRESS |
VARCHAR2(128) |
||
|
READ_MB |
NUMBER(12) |
||
|
ROWS_PROCESSED |
NUMBER(12) |
||
|
SERIAL# |
NUMBER(8) |
||
|
SPID |
VARCHAR2(24) |
||
|
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(12) |
||
|
USED_UREC |
NUMBER(12) |
||
|
USERNAME |
VARCHAR2(64) |
Field that uniquely identifies a user. (* from FPSINPUT.GEN_USERS) |
|
|
WARN_IN_SYSMNTR |
CHAR(1) |