[Home] [Help] [Dependency Information]
Object Name: | V_$SCHEDULER_INMEM_RTINFO |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
USERID | NUMBER | |||
OBJID | NUMBER | |||
ID_TYPE | NUMBER | |||
NAME | VARCHAR2 | (31) | ||
NEXT_RUN_DATE | TIMESTAMP(3) WITH TIME ZONE | (20) | ||
LAST_START_DATE | TIMESTAMP(3) WITH TIME ZONE | (20) | ||
LAST_END_DATE | TIMESTAMP(3) WITH TIME ZONE | (20) | ||
RUN_COUNT | NUMBER | |||
FAILURE_COUNT | NUMBER | |||
RUNNING_INSTANCE | NUMBER | |||
RUNNING_SLAVE | NUMBER | |||
JOB_STATUS | NUMBER | |||
CON_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT USERID
, OBJID
, ID_TYPE
, NAME
, NEXT_RUN_DATE
, LAST_START_DATE
, LAST_END_DATE
, RUN_COUNT
, FAILURE_COUNT
, RUNNING_INSTANCE
, RUNNING_SLAVE
, JOB_STATUS
, CON_ID
FROM SYS.V_$SCHEDULER_INMEM_RTINFO;
|
|
|