Data Dictionary
>
FPSBASE Views
> FPSBASE.WIP_WAFER_HIST_LOOP
View FPSADMIN.ADM_SESSION_ACTIVE_HIST
This view stores a useful query to V$ACTIVE_SESSION_HISTORY that lists all sessions which are ACTIVE each second. This means that queries which take longer than one second will be listed multiple times so you might want to use distinct and/or group by appropriately when querying this view. The V$ view goes back several days but this query just defaults to the last hour for speed. The related view ADM_SESSION_LOGON_LOGOFF_HIST might be useful too in situations where we want to research connection. Please note that I tried to bring in v$sql to the get the sql_text but this took a very long time so it would be best to query v$sql separately for the sql_id which is causing problems.
|
Column |
Comment |
|---|---|
|
SAMPLE_TIME |
|
|
SQL_EXEC_START |
|
|
USERNAME |
Field that uniquely identifies a user. (* inherited from FPSINPUT.GEN_USERS) |
|
SID |
|
|
MACHINE |
|
|
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 |
|
|
SESSION_STATE |
|
|
IN_SQL_EXECUTION |
|
|
IN_PLSQL_EXECUTION |
|
|
SQL_ID |
|
|
SQL_OPNAME |