Data Dictionary
>
FPSAPP Views
> FPSAPP.WIP_WAFER_HIST_LOOP
View FPSADMIN.ADM_SESSION_LOGON_LOGOFF_HIST
This view stores a useful query to dba_audit_session that gives the logon and logoff time for every session. This table is only populate if "audit connect;" is executed by the DBA on the database. The related view ADM_SESSION_ACTIVE_HIST always has data and might be sufficient if audit connect has not been anabled.
|
Column |
Comment |
|---|---|
|
OSUSER |
|
|
USERNAME |
Field that uniquely identifies a user. (* inherited from FPSINPUT.GEN_USERS) |
|
MACHINE |
|
|
TERMINAL |
|
|
LOG_TIME |
|
|
LOGON_OR_LOGOFF |
|
|
AUDSID |
|
|
OS_PROCESS |