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]

VIEW: SYS.ALL_SCHEDULER_WINDOW_LOG

Object Details

Object Name:	ALL_SCHEDULER_WINDOW_LOG
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

Logged information for all scheduler windows

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
LOG_ID	NUMBER		Yes	The unique id of the log entry
LOG_DATE	TIMESTAMP(6) WITH TIME ZONE	(13)		The date of this log entry
OWNER	VARCHAR2	(128)		The owner of the scheduler window
WINDOW_NAME	VARCHAR2	(261)		The name of the scheduler window
OPERATION	VARCHAR2	(30)		The operation corresponding to this log entry
STATUS	VARCHAR2	(30)		The status of the operation, if applicable
USER_NAME	VARCHAR2	(128)		The name of the user who performed the operation, if applicable
CLIENT_ID	VARCHAR2	(64)		The client id of the user who performed the operation, if applicable
GLOBAL_UID	VARCHAR2	(32)		The global_uid of the user who performed the operation, if applicable
ADDITIONAL_INFO	CLOB	(4000)		Additional information on this entry, if applicable

Query Text

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


SELECT LOG_ID
,      LOG_DATE
,      OWNER
,      WINDOW_NAME
,      OPERATION
,      STATUS
,      USER_NAME
,      CLIENT_ID
,      GLOBAL_UID
,      ADDITIONAL_INFO
FROM SYS.ALL_SCHEDULER_WINDOW_LOG;

Dependencies

[top of page]

SYS.ALL_SCHEDULER_WINDOW_LOG references the following:

SYS: DBA_SCHEDULER_WINDOW_LOG

SYS.ALL_SCHEDULER_WINDOW_LOG is referenced by following:

PUBLIC: ALL_SCHEDULER_WINDOW_LOG