DBA Data[Home] [Help] [Dependency Information]

TABLE: APPLSYS.AD_SESSIONS_HISTORY

Object Details
Object Name: AD_SESSIONS_HISTORY
Object Type: TABLE
Owner: APPLSYS
FND Design Data: TableAD.AD_SESSIONS_HISTORY
Subobject Name:
Status: VALID


Stores information on all AD sessions for an Applications System. After an AD_UTILTY session which is running concurrently has completed successfully the rows belonging to that session are copied from AD_SESSIONS table to this table.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
SESSION_ID NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSESSION_ID
Columns
Name Datatype Length Mandatory Comments
SESSION_ID NUMBER
Yes Primary Key
UTILITY_NAME VARCHAR2 (8) Yes Name of AD Utility
APPL_TOP_PATH VARCHAR2 (256) Yes APPL_TOP Path
INVOKDIR VARCHAR2 (256) Yes Directory AD Utility was invoked from
STATUS VARCHAR2 (30) Yes Active or Inactive
PRIORITY NUMBER
Yes Priority of Session
START_DATE DATE
Yes Time AD Utility was Started
CREATION_DATE DATE
Yes Standard who column - date when this row was created.
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
END_DATE DATE
Yes Time session completed
COMPLETION_STATUS VARCHAR2 (30) Yes Completion status. Valid values are ABANDONED and COMPLETED
RUN_ON_NODE VARCHAR2 (30) Yes Node (machine) on which this session ran
CONTEXT_INFO VARCHAR2 (256)
Information related to the AD Utility being executed
ANY_CHANGE_WHILE_INACTIVE_FLAG VARCHAR2 (1)
Resources Needed by this session have changed while session was inactive
JS_TOTAL_JOBS NUMBER

Total number of jobs in Job System
JS_COMPLETED_JOBS NUMBER

Number of Completed Jobs
JS_REMAINING_JOBS NUMBER

Number of Jobs Remaining in Job System
LOCKS_OVERRIDDEN_BY NUMBER

Stores the session Id of the first session that updated the column ANY_CHANGE_WHILE_INACTIVE_FLAG to Y.
TOPDIR VARCHAR2 (256) Yes Stores the directory location of the logs.
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT SESSION_ID
,      UTILITY_NAME
,      APPL_TOP_PATH
,      INVOKDIR
,      STATUS
,      PRIORITY
,      START_DATE
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      END_DATE
,      COMPLETION_STATUS
,      RUN_ON_NODE
,      CONTEXT_INFO
,      ANY_CHANGE_WHILE_INACTIVE_FLAG
,      JS_TOTAL_JOBS
,      JS_COMPLETED_JOBS
,      JS_REMAINING_JOBS
,      LOCKS_OVERRIDDEN_BY
,      TOPDIR
FROM APPLSYS.AD_SESSIONS_HISTORY;

Dependencies

[top of page]

APPLSYS.AD_SESSIONS_HISTORY does not reference any database object

APPLSYS.AD_SESSIONS_HISTORY is referenced by following:

SchemaAPPLSYS
ViewAD_SESSIONS_HISTORY#