[Home] [Help] [Dependency Information]
Object Name: | DIR$INSTANCE_ACTIONS |
---|---|
Object Type: | TABLE |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Tablespace: | SYSAUX |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
I_DIR$INSTANCE_ACTTYP | NORMAL | NONUNIQUE | SYSAUX | ACTION_TYPE |
I_DIR$INSTANCE_END_TIME | NORMAL | NONUNIQUE | SYSAUX | END_TIME |
I_DIR$INSTANCE_JOB_NAME | NORMAL | NONUNIQUE | SYSAUX | JOB_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
JOB_NAME | VARCHAR2 | (100) | ||
ACTION_TYPE | NUMBER | |||
INSTANCE_NAME | VARCHAR2 | (4000) | ||
SUBMIT_TIME | DATE | |||
START_TIME | DATE | |||
END_TIME | DATE | |||
ERROR_MESSAGE | VARCHAR2 | (4000) | ||
SPAREN1 | NUMBER | |||
SPAREN2 | NUMBER | |||
SPAREN3 | NUMBER | |||
SPAREN4 | NUMBER | |||
SPAREN5 | NUMBER | |||
SPAREVC1 | VARCHAR2 | (4000) | ||
SPAREVC2 | VARCHAR2 | (4000) | ||
SPAREVC3 | VARCHAR2 | (4000) | ||
SPAREVC4 | VARCHAR2 | (4000) | ||
SPAREVC5 | VARCHAR2 | (4000) |
Cut, paste (and edit) the following text to query this object:
SELECT JOB_NAME
, ACTION_TYPE
, INSTANCE_NAME
, SUBMIT_TIME
, START_TIME
, END_TIME
, ERROR_MESSAGE
, SPAREN1
, SPAREN2
, SPAREN3
, SPAREN4
, SPAREN5
, SPAREVC1
, SPAREVC2
, SPAREVC3
, SPAREVC4
, SPAREVC5
FROM SYS.DIR$INSTANCE_ACTIONS;
SYS.DIR$INSTANCE_ACTIONS does not reference any database object
SYS.DIR$INSTANCE_ACTIONS is not referenced by any database object
|
|
|