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: SYS.SCHEDULER$_WINDOW

Object Details

Object Name:	SCHEDULER$_WINDOW
Object Type:	TABLE
Owner:	SYS
Subobject Name:
Status:	VALID

Storage Details

Tablespace:	SYSTEM
PCT Free:	10
PCT Used:	40

Primary Key: SCHEDULER$_WINDOW_PK

OBJ#

Indexes

Index	Type	Uniqueness	Tablespace	Column
SCHEDULER$_WINDOW_PK	NORMAL	UNIQUE	SYSTEM	OBJ#
I_SCHEDULER_WINDOW1	FUNCTION-BASED NORMAL	NONUNIQUE	SYSTEM	SYS_EXTRACT_UTC("NEXT_START_DATE")

Columns

Name	Datatype	Length	Mandatory
OBJ#	NUMBER		Yes
RES_PLAN	VARCHAR2	(128)
NEXT_START_DATE	TIMESTAMP(6) WITH TIME ZONE	(13)
MANUAL_OPEN_TIME	TIMESTAMP(6) WITH TIME ZONE	(13)
DURATION	INTERVAL DAY(3) TO SECOND(0)	(11)
MANUAL_DURATION	INTERVAL DAY(3) TO SECOND(0)	(11)
SCHEDULE_EXPR	VARCHAR2	(4000)
START_DATE	TIMESTAMP(6) WITH TIME ZONE	(13)
END_DATE	TIMESTAMP(6) WITH TIME ZONE	(13)
LAST_START_DATE	TIMESTAMP(6) WITH TIME ZONE	(13)
ACTUAL_START_DATE	TIMESTAMP(6) WITH TIME ZONE	(13)
SCALING_FACTOR	NUMBER
CREATOR	VARCHAR2	(128)
UNUSED_SLAVE_POLICY	NUMBER
MIN_SLAVE_PERCENT	NUMBER
MAX_SLAVE_PERCENT	NUMBER
SCHEDULE_ID	NUMBER
FLAGS	NUMBER
MAX_CONC_JOBS	NUMBER
PRIORITY	NUMBER
COMMENTS	VARCHAR2	(240)

Query Text

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


SELECT OBJ#
,      RES_PLAN
,      NEXT_START_DATE
,      MANUAL_OPEN_TIME
,      DURATION
,      MANUAL_DURATION
,      SCHEDULE_EXPR
,      START_DATE
,      END_DATE
,      LAST_START_DATE
,      ACTUAL_START_DATE
,      SCALING_FACTOR
,      CREATOR
,      UNUSED_SLAVE_POLICY
,      MIN_SLAVE_PERCENT
,      MAX_SLAVE_PERCENT
,      SCHEDULE_ID
,      FLAGS
,      MAX_CONC_JOBS
,      PRIORITY
,      COMMENTS
FROM SYS.SCHEDULER$_WINDOW;

Dependencies

[top of page]

SYS.SCHEDULER$_WINDOW does not reference any database object

SYS.SCHEDULER$_WINDOW is referenced by following:

SYS: DBA_SCHEDULER_WINDOWS; DBA_SCHEDULER_WINDOW_GROUPS; DBMS_SCHED_MAIN_EXPORT - show dependent code