[Home] [Help] [Dependency Information]
Object Name: | AQ$_SCHEDULES |
---|---|
Object Type: | TABLE |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Tablespace: | SYSTEM |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
AQ$_SCHEDULES_PRIMARY | NORMAL | UNIQUE | SYSTEM |
OID
DESTINATION |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OID | RAW | (16) | Yes | |
DESTINATION | VARCHAR2 | (128) | Yes | |
START_TIME | DATE | |||
DURATION | VARCHAR2 | (8) | ||
NEXT_TIME | VARCHAR2 | (200) | ||
LATENCY | VARCHAR2 | (8) | ||
LAST_RUN | DATE | |||
JOBNO | NUMBER | |||
FAILURES | NUMBER | |||
DISABLED | VARCHAR2 | (1) | ||
ERROR_TIME | DATE | |||
LAST_ERROR_MSG | VARCHAR2 | (4000) | ||
CUR_START_TIME | DATE | |||
NEXT_RUN | DATE | |||
PROCESS_NAME | VARCHAR2 | (8) | ||
SID | NUMBER | |||
SERIAL | NUMBER | |||
TOTAL_TIME | NUMBER | |||
TOTAL_MSGS | NUMBER | |||
TOTAL_BYTES | NUMBER | |||
TOTAL_WINDOWS | NUMBER | |||
WIN_MSGS | NUMBER | |||
WIN_BYTES | NUMBER | |||
MAX_NUM_PER_WIN | NUMBER | |||
MAX_SIZE | NUMBER | |||
INSTANCE | NUMBER | |||
SPARE1 | NUMBER | |||
SPARE2 | VARCHAR2 | (1024) | ||
JOB_NAME | VARCHAR2 | (128) | ||
DESTQ | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT OID
, DESTINATION
, START_TIME
, DURATION
, NEXT_TIME
, LATENCY
, LAST_RUN
, JOBNO
, FAILURES
, DISABLED
, ERROR_TIME
, LAST_ERROR_MSG
, CUR_START_TIME
, NEXT_RUN
, PROCESS_NAME
, SID
, SERIAL
, TOTAL_TIME
, TOTAL_MSGS
, TOTAL_BYTES
, TOTAL_WINDOWS
, WIN_MSGS
, WIN_BYTES
, MAX_NUM_PER_WIN
, MAX_SIZE
, INSTANCE
, SPARE1
, SPARE2
, JOB_NAME
, DESTQ
FROM SYS.AQ$_SCHEDULES;
SYS.AQ$_SCHEDULES does not reference any database object
SYS.AQ$_SCHEDULES is referenced by following:
|
|
|