Data Dictionary
>
FPSBASE Views
> FPSBASE.WIP_WAFER_HIST_LOOP
View FPSADMIN.ADM_SESSIONS_BIND_VARS
This view shows info for all sessions on the FPS schemas with the bind variables of all queries from V$SQL_BIND_CAPTURE. Please note that while this Oracle system view list all bind variables, it does not capture all values, only selected ones. If the trace level is set above basic then it will capture all values but this is not common and requires SYSDBA access.
|
Column |
Comment |
|---|---|
|
PROBLEM |
|
|
LOGON_TIME |
|
|
PREV_EXEC_START |
|
|
EXEC_TIME |
|
|
STATUS |
|
|
USERNAME |
Field that uniquely identifies a user. (* inherited from FPSINPUT.GEN_USERS) |
|
OSUSER |
|
|
MACHINE |
|
|
SID |
|
|
SQL_TEXT_PREVIEW |
|
|
BIND_VAR_NAME |
|
|
POSITION_LIST |
|
|
DATATYPE_STRING |
|
|
VALUE_STRING |
|
|
LAST_CAPTURED |
|
|
MODULE_PREVIEW |
|
|
USED_UBLK |
|
|
USED_UREC |
|
|
PROGRESS |
|
|
MODULE |
Modules are departments of people who manage certain areas of the fab. The modules are assigned ownership of a set of tools to operate and maintain as well as steps on the route that they are responsible for executing. Since many of our tables include tool and step information together, we must distinguish between the owner of the step (WIP_MODULE), the owner of the operation of the tool (EQP_MODULE), and the owner of the maintenance of the tool (MNT_MODULE). WIP_MODULE is used to credit moves and set goals. Each route-step is assigned to a process family and then its wip_module is defined by the process family. EQP_MODULE is used to group tools particularly for tool performance reporting. Similar to WIP, each tool is dynamically assigned to a process family based on its assignments and then its eqp_module is defined by the process family. MNT_MODULE is usually the same as EQP_MODULE but unlike EQP_MODULE is not dependent on assignments but only on the EQP hierarchy. Each tool is assigned to an eqp_type and each eqp_type is assigned to a mnt_family and each mnt_family is assigned to a mnt_module. (* inherited from FPSINPUT.GEN_MODULES) |
|
PROGRAM |
|
|
SQL_ID |
|
|
SQL_CHILD_NUMBER |
|
|
HASH_VALUE |
|
|
SQL_TEXT |
|
|
SQL_FULLTEXT |
|
|
SQL_XPLAN |
|
|
WARN_IN_SYSMNTR |
|
|
SHOULD_KILL |
|
|
IS_AUTO_KILL_ALLOWED |
Flag indicating whether the session is allowed to be killed automatically. (* inherited from FPSADMIN.CFG_SESSIONS_TO_KILL) |
|
KILL_QUERY |