Data Dictionary
>
FPSAPP Views
> FPSAPP.WIP_WAFER_HIST_LOOP
View FPSADMIN.DBF_REF_SESSIONS
Because we must use dba_xxx views and Oracle does not allow grant select on views using dba_xxx and we need to grant permission on ADM_SESSIONS to FPSAPP for SYSMNTR, our solution is to refresh a table with this data which we can grant.
|
Column |
Comment |
|---|---|
|
PROBLEM |
|
|
LOGON_TIME |
|
|
PREV_EXEC_START |
|
|
USERNAME |
Field that uniquely identifies a user. (* inherited from FPSINPUT.GEN_USERS) |
|
SID |
|
|
STATUS |
|
|
MACHINE |
|
|
SYS_PROCESS |
|
|
SPID |
|
|
OSUSER |
|
|
SYS_MODULE |
|
|
USED_UBLK |
|
|
USED_UREC |
|
|
OWNER |
|
|
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) |
|
OBJECT_TYPE |
|
|
OPNAME |
|
|
TARGET |
|
|
PROGRESS |
|
|
ROWS_PROCESSED |
|
|
DISK_READS |
|
|
LAST_UPDATE_TIME |
|
|
ELAPSED_SECONDS |
|
|
CPU_USED |
|
|
MEMORY_USED_IN_MB |
|
|
READ_MB |
|
|
WRITE_MB |
|
|
PROGRAM |
|
|
SQL_ID |
|
|
LOCKED_MODE |
|
|
LOCKED_MODE_MSG |
|
|
WARN_IN_SYSMNTR |
|
|
SQL_TEXT |