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._DEFSCHEDULE

Object Details

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

[View Source]

Columns

Name	Datatype	Length	Mandatory
DBLINK	VARCHAR2	(128)	Yes
JOB	NUMBER
INTERVAL	VARCHAR2	(200)
NEXT_DATE	DATE
LAST_DATE	DATE
DISABLED	CHAR	(1)
LAST_TXN_COUNT	NUMBER
LAST_ERROR_NUMBER	NUMBER
LAST_ERROR_MESSAGE	VARCHAR2	(2000)
CATCHUP	RAW	(16)	Yes
TOTAL_TXN_COUNT	NUMBER
AVG_THROUGHPUT	NUMBER
AVG_LATENCY	NUMBER
TOTAL_BYTES_SENT	NUMBER
TOTAL_BYTES_RECEIVED	NUMBER
TOTAL_ROUND_TRIPS	NUMBER
TOTAL_ADMIN_COUNT	NUMBER
TOTAL_ERROR_COUNT	NUMBER
TOTAL_SLEEP_TIME	NUMBER
DISABLED_INTERNALLY_SET	VARCHAR2	(1)
PROPAGATION_WAS_ENABLED	VARCHAR2	(1)

Query Text

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


SELECT DBLINK
,      JOB
,      INTERVAL
,      NEXT_DATE
,      LAST_DATE
,      DISABLED
,      LAST_TXN_COUNT
,      LAST_ERROR_NUMBER
,      LAST_ERROR_MESSAGE
,      CATCHUP
,      TOTAL_TXN_COUNT
,      AVG_THROUGHPUT
,      AVG_LATENCY
,      TOTAL_BYTES_SENT
,      TOTAL_BYTES_RECEIVED
,      TOTAL_ROUND_TRIPS
,      TOTAL_ADMIN_COUNT
,      TOTAL_ERROR_COUNT
,      TOTAL_SLEEP_TIME
,      DISABLED_INTERNALLY_SET
,      PROPAGATION_WAS_ENABLED
FROM SYS._DEFSCHEDULE;

Dependencies

[top of page]

SYS._DEFSCHEDULE references the following:

SYS: JOB$; UTL_RAW - show dependent code
SYSTEM: DEF$_DESTINATION

SYS._DEFSCHEDULE is referenced by following:

SYS: DEFSCHEDULE