Oracle 10g 기준의 SCHEDULER 관련 뷰 정보

 

출처 :  http://docs.oracle.com/cd/B19306_01/server.102/b14237/statviews_2041.htm#I1020507

 

 

Oracle Database Reference
10g Release 2 (10.2)
Part Number B14237-04

 

 

 

ALL_SCHEDULER_CHAIN_RULES

ALL_SCHEDULER_CHAIN_RULES shows the rules of all the chains visible to the current user (that is, those chains that the user has ALTER or EXECUTE privileges for).

 

Related Views

• DBA_SCHEDULER_CHAIN_RULES shows all rules for all chains.

• USER_SCHEDULER_CHAIN_RULES shows the rules for all chains in the current user's schema. This view does not display the OWNER column.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Chain schema
CHAIN_NAME	VARCHAR2(30)	NOT NULL	Chain name
RULE_OWNER	VARCHAR2(30)	NOT NULL	Rule schema
RULE_NAME	VARCHAR2(30)		Rule name
CONDITION	VARCHAR2(4000)		Rule condition
ACTION	VARCHAR2(4000)		Rule action
COMMENTS	VARCHAR2(4000)		User comments for the rule

 

 

ALL_SCHEDULER_CHAIN_STEPS

ALL_SCHEDULER_CHAIN_STEPS shows the defined steps of all chains visible to the current user (that is, those chains that the user has ALTER or EXECUTE privileges for).

 

Related Views

• DBA_SCHEDULER_CHAIN_STEPS shows the defined steps of all chains in the database.

• USER_SCHEDULER_CHAIN_STEPS shows the defined steps of all chains in the current user's schema. This view does not display the OWNER column.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Chain schema
CHAIN_NAME	VARCHAR2(30)	NOT NULL	Chain name
STEP_NAME	VARCHAR2(30)	NOT NULL	Chain step name
PROGRAM_OWNER	VARCHAR2(98)		Owner of the program that runs during this step
PROGRAM_NAME	VARCHAR2(98)		Name of the program that runs during this step
EVENT_SCHEDULE_OWNER	VARCHAR2(98)		Owner of the event schedule that this step waits for
EVENT_SCHEDULE_NAME	VARCHAR2(98)		Name of the event schedule that this step waits for
EVENT_QUEUE_OWNER	VARCHAR2(30)		Owner of source queue into which event will be raised
EVENT_QUEUE_NAME	VARCHAR2(30)		Name of source queue into which event will be raised
EVENT_QUEUE_AGENT	VARCHAR2(30)		Name of AQ agent used by the user on the event source queue (for a secure queue)
EVENT_CONDITION	VARCHAR2(4000)		Boolean expression used as the subscription rule for an event on the source queue
SKIP	VARCHAR2(5)		Whether or not this step should be skipped
PAUSE	VARCHAR2(5)		Whether or not this step should be paused after running
RESTART_ON_RECOVERY	VARCHAR2(5)		Whether or not this step should be restarted on database recovery
STEP_TYPE	VARCHAR2(14)		Type of this step
TIMEOUT	INTERVAL DAY(3) TO SECOND(0)		Timeout for waiting on an event schedule

 

 

ALL_SCHEDULER_CHAINS

ALL_SCHEDULER_CHAINS shows all chains visible to the current user (that is, those chains that the user has ALTER or EXECTUE privileges for).

 

Related Views

• DBA_SCHEDULER_CHAINS shows all chains in the database.

• USER_SCHEDULER_CHAINS shows all chains in the current user's schema. This view does not display the OWNER column.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Owning schema
CHAIN_NAME	VARCHAR2(30)	NOT NULL	Unique user-specified name
RULE_SET_OWNER	VARCHAR2(30)		Owning schema of the rule set describing the dependencies
RULE_SET_NAME	VARCHAR2(30)		Name of the rule set describing the dependencies
NUMBER_OF_RULES	NUMBER		Number of rules in the chain
NUMBER_OF_STEPS	NUMBER		Number of steps in the chain
ENABLED	VARCHAR2(5)		Whether or not the chain is enabled
EVALUATION_INTERVAL	INTERVAL DAY(3) TO SECOND(0)		Periodic interval at which to evaluate rules for this chain
USER_RULE_SET	VARCHAR2(5)		Whether or not the chain has a user-specified rule set
COMMENTS	VARCHAR2(240)		User comments

 

 

 

ALL_SCHEDULER_GLOBAL_ATTRIBUTE

ALL_SCHEDULER_GLOBAL_ATTRIBUTE displays the values of all scheduler attributes (for example, default_timezone and current_open_window).

 

Related View

DBA_SCHEDULER_GLOBAL_ATTRIBUTE displays the values of all scheduler attributes in the database (for example, default_timezone and current_open_window).

Column	Datatype	NULL	Description
ATTRIBUTE_NAME	VARCHAR2(30)	NOT NULL	Name of the scheduler attribute
VALUE	VARCHAR2(128)		Value of the scheduler attribute

 

 

 

ALL_SCHEDULER_JOB_ARGS

ALL_SCHEDULER_JOB_ARGS displays information about the arguments of the Scheduler jobs accessible to the current user.

 

Related Views

• DBA_SCHEDULER_JOB_ARGS displays information about the arguments of all Scheduler jobs in the database.

• USER_SCHEDULER_JOB_ARGS displays information about the arguments of the Scheduler jobs owned by the current user. This view does not display the OWNER column.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Owner of the job to which the argument belongs
JOB_NAME	VARCHAR2(30)	NOT NULL	Name of the job to which the argument belongs
ARGUMENT_NAME	VARCHAR2(30)		Optional name of the argument
ARGUMENT_POSITION	NUMBER		Position of the argument in the argument list
ARGUMENT_TYPE	VARCHAR2(61)		Datatype of the argument
VALUE	VARCHAR2(4000)		Value of the argument (in string format) if the argument is a string
ANYDATA_VALUE	ANYDATA		Value of the argument (in AnyData format)
OUT_ARGUMENT	VARCHAR2(5)		Reserved for future use

 

 

 

ALL_SCHEDULER_JOB_CLASSES

ALL_SCHEDULER_JOB_CLASSES displays information about the Scheduler job classes accessible to the current user.

 

Related View

DBA_SCHEDULER_JOB_CLASSES displays information about all Scheduler job classes in the database.

Column	Datatype	NULL	Description
JOB_CLASS_NAME	VARCHAR2(30)	NOT NULL	Name of the Scheduler job class
RESOURCE_CONSUMER_GROUP	VARCHAR2(30)		Resource consumer group associated with the class
SERVICE	VARCHAR2(64)		Name of the service the class is associated with
LOGGING_LEVEL	VARCHAR2(4)		Amount of logging that will be done pertaining to the class: OFF RUNS FULL
LOG_HISTORY	NUMBER		History to maintain in the job log (in days) for the class
COMMENTS	VARCHAR2(240)		Comments on the class

 

 

 

ALL_SCHEDULER_JOB_LOG

ALL_SCHEDULER_JOB_LOG displays log information for the Scheduler jobs accessible to the current user.

 

Related Views

• DBA_SCHEDULER_JOB_LOG displays log information for all Scheduler jobs in the database.

• USER_SCHEDULER_JOB_LOG displays log information for the Scheduler jobs owned by the current user.

Column	Datatype	NULL	Description
LOG_ID	NUMBER	NOT NULL	Unique identifier that identifies a row
LOG_DATE	TIMESTAMP(6) WITH TIME ZONE		Date of the log entry
OWNER	VARCHAR2(30)		Owner of the Scheduler job
JOB_NAME	VARCHAR2(65)		Name of the Scheduler job
JOB_SUBNAME	VARCHAR2(65)		Subname of the Scheduler job
JOB_CLASS	VARCHAR2(30)		Class that the job belonged to at the time of entry
OPERATION	VARCHAR2(30)		Operation corresponding to the log entry
STATUS	VARCHAR2(30)		The possible values for this column are dependent on the value in the OPERATION column. In most cases STATUS will be empty (null). Only for job run operations will it have a value. STATUS will be empty (null) when OPERATION is one of the following: CREATE - job was created UPDATE - one or more job attributes have been modified ENABLE - job has been enabled DISABLE - job has been disabled COMPLETED - for repeating jobs only, job has reached its end_date or maximum number of runs BROKEN - job has reached its maximum number of failures STATUS can be SUCCEEDED (job run completed successfully), FAILED (job run failed), or STOPPED (job run was stopped) when OPERATION is one of the following: RUN - regular job run RETRY_RUN - job is being retried because the previous run resulted in an error and RESTARTABLE is set to TRUE RECOVERY_RUN - job is being rerun because the database went down, or the job slave crashed and RESTARTABLE is set to TRUE
USER_NAME	VARCHAR2(30)		Name of the user who performed the operation, if applicable
CLIENT_ID	VARCHAR2(64)		Client identifier of the user who performed the operation, if applicable
GLOBAL_UID	VARCHAR2(32)		Global user identifier of the user who performed the operation, if applicable
ADDITIONAL_INFO	CLOB		Additional information on the entry, if applicable

 

 

 

ALL_SCHEDULER_JOB_RUN_DETAILS

ALL_SCHEDULER_JOB_RUN_DETAILS displays log run details for the Scheduler jobs accessible to the current user.

 

Related Views

• DBA_SCHEDULER_JOB_RUN_DETAILS displays log run details for all Scheduler jobs in the database.

• USER_SCHEDULER_JOB_RUN_DETAILS displays log run details for the Scheduler jobs owned by the current user.

Column	Datatype	NULL	Description
LOG_ID	NUMBER		Unique identifier of the log entry
LOG_DATE	TIMESTAMP(6) WITH TIME ZONE		Date of the log entry
OWNER	VARCHAR2(30)		Owner of the Scheduler job
JOB_NAME	VARCHAR2(65)		Name of the Scheduler job
STATUS	VARCHAR2(30)		Status of the job run
ERROR#	NUMBER		Error number in the case of an error
REQ_START_DATE	TIMESTAMP(6) WITH TIME ZONE		Requested start date of the job run
ACTUAL_START_DATE	TIMESTAMP(6) WITH TIME ZONE		Actual date on which the job was run
RUN_DURATION	INTERVAL DAY(3) TO SECOND(0)		Duration of the job run
INSTANCE_ID	NUMBER		Identifier of the instance on which the job was run
SESSION_ID	VARCHAR2(30)		Session identifier of the job run
SLAVE_PID	VARCHAR2(30)		Process identifier of the slave on which the job was run
CPU_USED	NUMBER		Amount of CPU used for the job run
ADDITIONAL_INFO	VARCHAR2(4000)		Additional information on the job run, if applicable

 

 

 

ALL_SCHEDULER_JOBS

ALL_SCHEDULER_JOBS displays information about the Scheduler jobs accessible to the current user.

 

Related Views

• DBA_SCHEDULER_JOBS displays information about all Scheduler jobs in the database.

• USER_SCHEDULER_JOBS displays information about the Scheduler jobs owned by the current user. This view does not display the OWNER column.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Owner of the Scheduler job
JOB_NAME	VARCHAR2(30)	NOT NULL	Name of the Scheduler job
JOB_SUBNAME	VARCHAR2(30)		Subname of the scheduler job (for a job running a chain step)
JOB_CREATOR	VARCHAR2(30)		Original creator of the job
CLIENT_ID	VARCHAR2(64)		Client identifier of the user creating the job
GLOBAL_UID	VARCHAR2(32)		Global user identifier of the user creating the job
PROGRAM_OWNER	VARCHAR2(4000)		Owner of the program associated with the job
PROGRAM_NAME	VARCHAR2(4000)		Name of the program associated with the job
JOB_TYPE	VARCHAR2(16)		Inline job action type: PLSQL_BLOCK STORED_PROCEDURE EXECUTABLE CHAIN
JOB_ACTION	VARCHAR2(4000)		Inline job action
NUMBER_OF_ARGUMENTS	NUMBER		Inline number of job arguments
SCHEDULE_OWNER	VARCHAR2(4000)		Owner of the job's schedule (can be a window or a window group)
SCHEDULE_NAME	VARCHAR2(4000)		Name of the job's schedule (can be a window or a window group)
SCHEDULE_TYPE	VARCHAR2(12)		The type of schedule. Possible values are as follows: IMMEDIATE - start date and repeat interval are null ONCE - repeat interval is null PLSQL - PL/SQL expression used as schedule CALENDAR - Oracle calendaring expression used as schedule EVENT - event schedule NAMED - a named schedule WINDOW - window used as schedule WINDOW_GROUP - window group used as schedule
START_DATE	TIMESTAMP(6) WITH TIME ZONE		Original scheduled start date of the job (for an inline schedule)
REPEAT_INTERVAL	VARCHAR2(4000)		Inline schedule PL/SQL expression or calendar string
EVENT_QUEUE_OWNER	VARCHAR2(30)		Owner of the source queue into which the event will be raised
EVENT_QUEUE_NAME	VARCHAR2(30)		Name of the source queue into which the event will be raised
EVENT_QUEUE_AGENT	VARCHAR2(30)		Name of the AQ agent used by the user on the event source queue (if it is a secure queue)
EVENT_CONDITION	VARCHAR2(4000)		Boolean expression used as the subscription rule for the event on the source queue
EVENT_RULE	VARCHAR2(65)		Name of the rule used by the coordinator to trigger the event-based job
END_DATE	TIMESTAMP(6) WITH TIME ZONE		Date after which the job will no longer run (for an inline schedule)
JOB_CLASS	VARCHAR2(30)		Name of the job class associated with the job
ENABLED	VARCHAR2(5)		Indicates whether the job is enabled (TRUE) or not (FALSE)
AUTO_DROP	VARCHAR2(5)		Indicates whether the job will be dropped when it has completed (TRUE) or not (FALSE)
RESTARTABLE	VARCHAR2(5)		Indicates whether the job can be restarted (TRUE) or not (FALSE)
STATE	VARCHAR2(15)		Current state of the job: DISABLED RETRY SCHEDULED SCHEDULED RUNNING COMPLETED BROKEN FAILED REMOTE SUCCEEDED CHAIN_STALLED
JOB_PRIORITY	NUMBER		Priority of the job relative to other jobs in the same class
RUN_COUNT	NUMBER		Number of times the job has run
MAX_RUNS	NUMBER		Maximum number of times the job is scheduled to run
FAILURE_COUNT	NUMBER		Number of times the job has failed to run
MAX_FAILURES	NUMBER		Number of times the job will be allowed to fail before being marked broken
RETRY_COUNT	NUMBER		Number of times the job has retried, if it is retrying
LAST_START_DATE	TIMESTAMP(6) WITH TIME ZONE		Last date on which the job started running
LAST_RUN_DURATION	INTERVAL DAY(9) TO SECOND(6)		Amount of time the job took to complete during the last run
NEXT_RUN_DATE	TIMESTAMP(6) WITH TIME ZONE		Next date on which the job is scheduled to run
SCHEDULE_LIMIT	INTERVAL DAY(3) TO SECOND(0)		Time after which a job which has not run yet will be rescheduled
MAX_RUN_DURATION	INTERVAL DAY(3) TO SECOND(0)		Maximum amount of time for which the job will be allowed to run
LOGGING_LEVEL	VARCHAR2(4)		Amount of logging that will be done pertaining to the job: OFF RUNS FULL
STOP_ON_WINDOW_CLOSE	VARCHAR2(5)		Indicates whether the job will stop if a window associated with the job closes (TRUE) or not (FALSE)
INSTANCE_STICKINESS	VARCHAR2(5)		Indicates whether the job is sticky (TRUE) or not (FALSE)
RAISE_EVENTS	VARCHAR2(4000)		List of job events to raise for this job. Possible values are: JOB_STARTED JOB_SUCCEEDED JOB_FAILED JOB_BROKEN JOB_COMPLETED JOB_STOPPED JOB_SCH_LIM_REACHED JOB_DISABLED JOB_CHAIN_STALLED JOB_OVER_MAX_DUR
SYSTEM	VARCHAR2(5)		Indicates whether the job is a system job (TRUE) or not (FALSE)
JOB_WEIGHT	NUMBER		Weight of the job
NLS_ENV	VARCHAR2(4000)		NLS environment of the job
SOURCE	VARCHAR2(128)		Source global database identifier
DESTINATION	VARCHAR2(128)		Destination global database identifier
COMMENTS	VARCHAR2(240)		Comments on the job
FLAGS	NUMBER		This column is for internal use.

 

 

 

 

ALL_SCHEDULER_PROGRAM_ARGS

ALL_SCHEDULER_PROGRAM_ARGS displays information about the arguments of the Scheduler programs accessible to the current user.

 

Related Views

• DBA_SCHEDULER_PROGRAM_ARGS displays information about the arguments of all Scheduler programs in the database.

• USER_SCHEDULER_PROGRAM_ARGS displays information about the arguments of the Scheduler programs owned by the current user. This view does not display the OWNER column.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Owner of the program to which the argument belongs
PROGRAM_NAME	VARCHAR2(30)	NOT NULL	Name of the program to which the argument belongs
ARGUMENT_NAME	VARCHAR2(30)		Optional name of the argument
ARGUMENT_POSITION	NUMBER	NOT NULL	Position of the argument in the argument list
ARGUMENT_TYPE	VARCHAR2(61)		Datatype of the argument
METADATA_ATTRIBUTE	VARCHAR2(12)		Metadata attribute: JOB_NAME JOB_OWNER JOB_START WINDOW_START WINDOW_END
DEFAULT_VALUE	VARCHAR2(4000)		Default value taken by the argument (in string format) if the argument is a string
DEFAULT_ANYDATA_VALUE	ANYDATA		Default value taken by the argument (in AnyData format)
OUT_ARGUMENT	VARCHAR2(5)		Reserved for future use

 

 

 

 

ALL_SCHEDULER_PROGRAMS

ALL_SCHEDULER_PROGRAMS displays information about the Scheduler programs accessible to the current user.

 

Related Views

• DBA_SCHEDULER_PROGRAMS displays information about all Scheduler programs in the database.

• USER_SCHEDULER_PROGRAMS displays information about the Scheduler programs owned by the current user. This view does not display the OWNER column.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Owner of the Scheduler program
PROGRAM_NAME	VARCHAR2(30)	NOT NULL	Name of the Scheduler program
PROGRAM_TYPE	VARCHAR2(16)		Program action type: PLSQL_BLOCK STORED_PROCEDURE EXECUTABLE
PROGRAM_ACTION	VARCHAR2(4000)		Program action
NUMBER_OF_ARGUMENTS	NUMBER		Number of arguments accepted by the program
ENABLED	VARCHAR2(5)		Indicates whether the program is enabled (TRUE) or not (FALSE)
DETACHED	VARCHAR2(5)		This column is for internal use
COMMENTS	VARCHAR2(240)		Comments on the program

 

 

 

 

ALL_SCHEDULER_RUNNING_CHAINS

ALL_SCHEDULER_RUNNING_CHAINS shows the state of all chain steps of running chains visible to the current user (that is, those chains that the user has ALTER privileges for). In case of nested chains this view also enables you to traverse the hierarchy of the chain with a SQL statement that contains a CONNECT BY clause linking up the JOB_SUBNAME and STEP_JOB_SUBNAME columns.

 

Related Views

• DBA_SCHEDULER_RUNNING_CHAINS shows the state of all chain steps of running chains in the database.

• USER_SCHEDULER_RUNNING_CHAINS shows the state of all chain steps of running chains in the current user's schema. This view does not display the OWNER column.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)		Job schema
JOB_NAME	VARCHAR2(30)		Job name
JOB_SUBNAME	VARCHAR2(30)		In the case of nested chains, subname of the parent job running this step (else NULL)
CHAIN_OWNER	VARCHAR2(30)		Chain schema
CHAIN_NAME	VARCHAR2(30)		Chain name
STEP_NAME	VARCHAR2(30)		Chain step name
STATE	VARCHAR2(11)		State of this running chain step. The state can be any of the following: NOT_STARTED, RUNNING, SUCCEEDED, STOPPED, FAILED, SCHEDULED, PAUSED, STALLED
ERROR_CODE	NUMBER		Error code with which this step completed (if it has completed)
COMPLETED	VARCHAR2(5)		Whether or not the running chain step has completed
START_DATE	TIMESTAMP(6) WITH TIME ZONE		When the running chain step started (if it has started)
END_DATE	TIMESTAMP(6) WITH TIME ZONE		When the running chain step stopped (if it has stopped)
DURATION	INTERVAL DAY(9) TO SECOND(6)		How long it took this chain step to complete (if it has completed)
SKIP	VARCHAR2(5)		Whether or not this chain step should be skipped
PAUSE	VARCHAR2(5)		Whether or not this chain step should be paused after running
RESTART_ON_RECOVERY	VARCHAR2(5)		Whether or not this step will be restarted on database recovery
STEP_JOB_SUBNAME	VARCHAR2(30)		The subname of the job running this step
STEP_JOB_LOG_ID	NUMBER		The log ID of the job running this step

 

 

 

 

ALL_SCHEDULER_RUNNING_JOBS

ALL_SCHEDULER_RUNNING_JOBS displays information about the running Scheduler jobs accessible to the current user.

 

Related Views

• DBA_SCHEDULER_RUNNING_JOBS displays information about all running Scheduler jobs in the database.

• USER_SCHEDULER_RUNNING_JOBS displays information about the running Scheduler jobs owned by the current user. This view does not display the OWNER column.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Owner of the running Scheduler job
JOB_NAME	VARCHAR2(30)	NOT NULL	Name of the running Scheduler job
JOB_SUBNAME	VARCHAR2(30)		Subname of the running Scheduler job
SESSION_ID	NUMBER		Identifier of the session running the Scheduler job
SLAVE_PROCESS_ID	NUMBER		Process number of the slave process running the Scheduler job
SLAVE_OS_PROCESS_ID	VARCHAR2(12)		Process number of the operating system slave process running the scheduler job
RUNNING_INSTANCE	NUMBER		Database instance number of the slave process running the Scheduler job
RESOURCE_CONSUMER_GROUP	VARCHAR2(32)		Resource consumer group of the session in which the Scheduler job is running
ELAPSED_TIME	INTERVAL DAY(3) TO SECOND(2)		Elapsed time since the Scheduler job was started
CPU_USED	NUMBER		Scheduler job CPU time consumed, if available

 

 

 

 

ALL_SCHEDULER_SCHEDULES

ALL_SCHEDULER_SCHEDULES displays information about the Scheduler schedules accessible to the current user.

 

Related Views

• DBA_SCHEDULER_SCHEDULES displays information about all Scheduler schedules in the database.

• USER_SCHEDULER_SCHEDULES displays information about the Scheduler schedules owned by the current user. This view does not display the OWNER column.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Owner of the schedule
SCHEDULE_NAME	VARCHAR2(30)	NOT NULL	Name of the schedule
SCHEDULE_TYPE	VARCHAR2(8)		The type of schedule. Possible values are as follows: ONCE - repeat interval is null CALENDAR - Oracle calendaring expression used as schedule EVENT - event schedule
START_DATE	TIMESTAMP(6) WITH TIME ZONE		Start date for the repeat interval
REPEAT_INTERVAL	VARCHAR2(4000)		Calendar syntax expression for the schedule
EVENT_QUEUE_OWNER	VARCHAR2(30)		Owner of the source queue into which the event will be raised
EVENT_QUEUE_NAME	VARCHAR2(30)		Name of the source queue into which the event will be raised
EVENT_QUEUE_AGENT	VARCHAR2(30)		Name of the AQ agent used by the user on the event source queue (if it is a secure queue)
EVENT_CONDITION	VARCHAR2(4000)		Boolean expression used as the subscription rule for the event on the source queue
END_DATE	TIMESTAMP(6) WITH TIME ZONE		Cutoff date after which the schedule will not specify any dates
COMMENTS	VARCHAR2(240)		Comments on the schedule

 

 

 

ALL_SCHEDULER_WINDOW_DETAILS

ALL_SCHEDULER_WINDOW_DETAILS displays log details for the Scheduler windows accessible to the current user.

 

Related View

DBA_SCHEDULER_WINDOW_DETAILS displays log details for all Scheduler windows in the database.

Column	Datatype	NULL	Description
LOG_ID	NUMBER		Unique identifier of the log entry
LOG_DATE	TIMESTAMP(6) WITH TIME ZONE		Date of the log entry
WINDOW_NAME	VARCHAR2(65)		Name of the Scheduler window
REQ_START_DATE	TIMESTAMP(6) WITH TIME ZONE		Requested start date for the Scheduler window
ACTUAL_START_DATE	TIMESTAMP(6) WITH TIME ZONE		Actual start date of the Scheduler window
WINDOW_DURATION	INTERVAL DAY(3) TO SECOND(0)		Requested duration of the Scheduler window
ACTUAL_DURATION	INTERVAL DAY(3) TO SECOND(0)		Actual duration for which the Scheduler window lasted
INSTANCE_ID	NUMBER		Identifier of the instance on which the window was run
ADDITIONAL_INFO	VARCHAR2(4000)		Additional information on the entry, if applicable

 

 

 

ALL_SCHEDULER_WINDOW_GROUPS

ALL_SCHEDULER_WINDOW_GROUPS displays information about the Scheduler window groups accessible to the current user.

 

Related View

DBA_SCHEDULER_WINDOW_GROUPS displays information about all Scheduler window groups in the database.

Column	Datatype	NULL	Description
WINDOW_GROUP_NAME	VARCHAR2(30)	NOT NULL	Name of the window group
ENABLED	VARCHAR2(5)		Indicates whether the window group is enabled (TRUE) or not (FALSE)
NUMBER_OF_WINDOWS	NUMBER		Number of members in the window group
NEXT_START_DATE	VARCHAR2(64)		If a window group is disabled, this column will be NULL. Otherwise, it will be set to the earliest NEXT_START_DATE from the enabled windows in the group.
COMMENTS	VARCHAR2(240)		Optional comment about the window group

 

 

 

 

ALL_SCHEDULER_WINDOW_LOG

ALL_SCHEDULER_WINDOW_LOG displays log information for the Scheduler windows accessible to the current user.

 

Related View

DBA_SCHEDULER_WINDOW_LOG displays log information for all Scheduler windows in the database.

Column	Datatype	NULL	Description
LOG_ID	NUMBER	NOT NULL	Unique identifier of the log entry
LOG_DATE	TIMESTAMP(6) WITH TIME ZONE		Date of the log entry
WINDOW_NAME	VARCHAR2(65)		Name of the Scheduler window
OPERATION	VARCHAR2(30)		Operation corresponding to the log entry
STATUS	VARCHAR2(30)		Status of the operation, if applicable
USER_NAME	VARCHAR2(30)		Name of the user who performed the operation, if applicable
CLIENT_ID	VARCHAR2(64)		Client identifier of the user who performed the operation, if applicable
GLOBAL_UID	VARCHAR2(32)		Global user identifier of the user who performed the operation, if applicable
ADDITIONAL_INFO	CLOB		Additional information on the entry, if applicable

 

 

 

 

ALL_SCHEDULER_WINDOWS

ALL_SCHEDULER_WINDOWS displays information about the Scheduler windows accessible to the current user.

 

Related View

DBA_SCHEDULER_WINDOWS displays information about all Scheduler windows in the database.

Column	Datatype	NULL	Description
WINDOW_NAME	VARCHAR2(30)	NOT NULL	Name of the Scheduler window
RESOURCE_PLAN	VARCHAR2(30)		Resource plan associated with the window
SCHEDULE_OWNER	VARCHAR2(4000)		Owner of the window's schedule
SCHEDULE_NAME	VARCHAR2(4000)		Name of the window's schedule
SCHEDULE_TYPE	VARCHAR2(8)		The type of schedule. Possible values are as follows: ONCE - repeat interval is null NAMED - a named schedule CALENDAR - Oracle calendaring expression used as schedule
START_DATE	TIMESTAMP(6) WITH TIME ZONE		Start date of the window (for an inline schedule)
REPEAT_INTERVAL	VARCHAR2(4000)		Calendar string for the window (for an inline schedule)
END_DATE	TIMESTAMP(6) WITH TIME ZONE		Date after which the window will no longer open (for an inline schedule)
DURATION	INTERVAL DAY(3) TO SECOND(0)		Duration of the window
WINDOW_PRIORITY	VARCHAR2(4)		Priority of the job relative to other windows: HIGH LOW
NEXT_START_DATE	TIMESTAMP(6) WITH TIME ZONE		Next date on which the window is scheduled to start
LAST_START_DATE	TIMESTAMP(6) WITH TIME ZONE		Last date on which the window opened
ENABLED	VARCHAR2(5)		Indicates whether the window is enabled (TRUE) or disabled (FALSE)
ACTIVE	VARCHAR2(5)		Indicates whether the window is open (TRUE) or not (FALSE)
MANUAL_OPEN_TIME	TIMESTAMP(6) WITH TIME ZONE		Open time of the window if it was manually opened; else NULL
MANUAL_DURATION	INTERVAL DAY(3) TO SECOND(0)		Duration of window if it was manually opened; else NULL
COMMENTS	VARCHAR2(240)		Comments on the window

 

 

 

ALL_SCHEDULER_WINGROUP_MEMBERS

ALL_SCHEDULER_WINGROUP_MEMBERS displays the members of the Scheduler window groups accessible to the current user.

 

Related View

DBA_SCHEDULER_WINGROUP_MEMBERS displays the members of all Scheduler window groups in the database.

Column	Datatype	NULL	Description
WINDOW_GROUP_NAME	VARCHAR2(30)	NOT NULL	Name of the window group
WINDOW_NAME	VARCHAR2(30)	NOT NULL	Name of the window member of the window group