eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: APPLSYS.AD_SESSIONS

Object Details

Object Name:	AD_SESSIONS
Object Type:	TABLE
Owner:	APPLSYS
FND Design Data:	AD.AD_SESSIONS
Subobject Name:
Status:	VALID

Stores information on all concurrently running AD sessions for an Applications System.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AD_SESSIONS_U1	NORMAL	UNIQUE	APPS_TS_INTERFACE	SESSION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
SESSION_ID	NUMBER		Yes	Primary Key
UTILITY_NAME	VARCHAR2	(8)	Yes	Name of AD Utility
APPL_TOP_ID	NUMBER		Yes	Foreign Key to AD_APPL_TOPS
INVOKDIR	VARCHAR2	(256)	Yes	Directory AD Utility was invoked from
STATUS	VARCHAR2	(30)	Yes	Active or Inactive
PRIORITY	NUMBER		Yes	Priority of Session
OS_PROCESS_ID	NUMBER		Yes	OS Process Id of the AD Utility
OS_USER_NAME	VARCHAR2	(30)	Yes	OS User Name Executing the AD Utility
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.
APPL_TOP_PATH	VARCHAR2	(256)	Yes	APPL_TOP path
CONTEXT_INFO	VARCHAR2	(256)		Information related to the AD Utility being executed
WAIT_LOOP_TIME	NUMBER			Time the session is waiting to acquire a lock
CONTROL_CODE	VARCHAR2	(1)		ADCTRL Control Code
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
JS_CURR_PHASE	VARCHAR2	(30)		Current Phase of Job System
JS_JOBS_REM_IN_CURR_PHASE	NUMBER			Number of Jobs Remaining in Current Phase
JS_JOBS_ASS_IN_CURR_PHASE	NUMBER			Number of Jobs Assigned in Current Phase
JS_JOBS_READY_IN_CURR_PHASE	NUMBER			Number of Jobs Ready to be run in Current Phase
JS_JOBS_WAITING_IN_CURR_PHASE	NUMBER			Number of Jobs Waiting in the Current Phase
RUN_ON_NODE	VARCHAR2	(30)	Yes	Node (machine) on which this session is running
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_ID
,      INVOKDIR
,      STATUS
,      PRIORITY
,      OS_PROCESS_ID
,      OS_USER_NAME
,      START_DATE
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      APPL_TOP_PATH
,      CONTEXT_INFO
,      WAIT_LOOP_TIME
,      CONTROL_CODE
,      ANY_CHANGE_WHILE_INACTIVE_FLAG
,      JS_TOTAL_JOBS
,      JS_COMPLETED_JOBS
,      JS_REMAINING_JOBS
,      JS_CURR_PHASE
,      JS_JOBS_REM_IN_CURR_PHASE
,      JS_JOBS_ASS_IN_CURR_PHASE
,      JS_JOBS_READY_IN_CURR_PHASE
,      JS_JOBS_WAITING_IN_CURR_PHASE
,      RUN_ON_NODE
,      LOCKS_OVERRIDDEN_BY
,      TOPDIR
FROM APPLSYS.AD_SESSIONS;

Dependencies

[top of page]

APPLSYS.AD_SESSIONS does not reference any database object

APPLSYS.AD_SESSIONS is referenced by following:

APPLSYS: AD_SESSIONS#