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

Information about propagation to different destinations

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
DBLINK	VARCHAR2	(128)	Yes	Destination
JOB	NUMBER			Number of job that pushes queue
INTERVAL	VARCHAR2	(200)		Function used to calculate the next time to push the queue to destination
NEXT_DATE	DATE			Next date that job is scheduled to be executed
LAST_DATE	DATE			Last time queue was (attempted to be) pushed to destination
DISABLED	CHAR	(1)		Is propagation to destination disabled
LAST_TXN_COUNT	NUMBER			Number of transactions pushed during last attempt
LAST_ERROR_NUMBER	NUMBER			Oracle error number from last push
LAST_ERROR_MESSAGE	VARCHAR2	(2000)		Error message from last push
CATCHUP	RAW	(16)	Yes	Used to break transaction into pieces
TOTAL_TXN_COUNT	NUMBER			Total number of transactions propagated (including error transactions)
AVG_THROUGHPUT	NUMBER			Average number of transactions (including errors) propagated per second
AVG_LATENCY	NUMBER			Average time in seconds since start of transaction to remote commit
TOTAL_BYTES_SENT	NUMBER			Total number of bytes sent over SQL*Net during propagation
TOTAL_BYTES_RECEIVED	NUMBER			Total number of bytes received over SQL*Net during propagation
TOTAL_ROUND_TRIPS	NUMBER			Total number of SQL*Net round trips during propagation
TOTAL_ADMIN_COUNT	NUMBER			Total number of administrative requests
TOTAL_ERROR_COUNT	NUMBER			Total number of error transactions propagated
TOTAL_SLEEP_TIME	NUMBER			Total time in seconds spent sleeping during propagation
DISABLED_INTERNALLY_SET	VARCHAR2	(1)		disabled was set internally for propagation synchronization

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
FROM SYS.DEFSCHEDULE;

Dependencies

[top of page]

SYS.DEFSCHEDULE references the following:

SYS: UTL_RAW - show dependent code; _DEFSCHEDULE

SYS.DEFSCHEDULE is referenced by following:

PUBLIC: DEFSCHEDULE
SYS: DBMS_REPCAT_VALIDATE - show dependent code