[Home] [Help] [Dependency Information]
Object Name: | DBA_ADDM_TASKS |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OWNER | VARCHAR2 | (128) | ||
TASK_ID | NUMBER | Yes | ||
TASK_NAME | VARCHAR2 | (128) | ||
DESCRIPTION | VARCHAR2 | (256) | ||
ADVISOR_NAME | VARCHAR2 | (128) | ||
CREATED | DATE | Yes | ||
LAST_MODIFIED | DATE | Yes | ||
PARENT_TASK_ID | NUMBER | |||
PARENT_RXEC_ID | NUMBER | |||
LAST_EXECUTION | VARCHAR2 | (128) | ||
EXECUTION_TYPE | VARCHAR2 | (30) | ||
EXECUTION_TYPE# | NUMBER | |||
EXECUTION_DESCRIPTION | VARCHAR2 | (256) | ||
EXECUTION_START | DATE | |||
EXECUTION_END | DATE | |||
STATUS | VARCHAR2 | (11) | ||
STATUS_MESSAGE | VARCHAR2 | (4000) | ||
PCT_COMPLETION_TIME | NUMBER | |||
PROGRESS_METRIC | NUMBER | |||
METRIC_UNITS | VARCHAR2 | (64) | ||
ACTIVITY_COUNTER | NUMBER | |||
RECOMMENDATION_COUNT | NUMBER | |||
ERROR_MESSAGE | VARCHAR2 | (4000) | ||
SOURCE | VARCHAR2 | (128) | ||
HOW_CREATED | VARCHAR2 | (30) | ||
READ_ONLY | VARCHAR2 | (5) | ||
SYSTEM_TASK | VARCHAR2 | (5) | ||
ADVISOR_ID | NUMBER | Yes | ||
STATUS# | NUMBER | |||
DBID | NUMBER | |||
DBNAME | VARCHAR2 | (9) | ||
DBVERSION | VARCHAR2 | (17) | ||
ANALYSIS_VERSION | VARCHAR2 | (17) | ||
BEGIN_SNAP_ID | NUMBER | |||
BEGIN_TIME | TIMESTAMP(3) | (11) | ||
END_SNAP_ID | NUMBER | |||
END_TIME | TIMESTAMP(3) | (11) | ||
REQUESTED_ANALYSIS | VARCHAR2 | (8) | ||
ACTUAL_ANALYSIS | VARCHAR2 | (8) | ||
DATABASE_TIME | NUMBER | |||
ACTIVE_SESSIONS | NUMBER | |||
METER_LEVEL | VARCHAR2 | (6) | ||
FDG_COUNT | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT OWNER
, TASK_ID
, TASK_NAME
, DESCRIPTION
, ADVISOR_NAME
, CREATED
, LAST_MODIFIED
, PARENT_TASK_ID
, PARENT_RXEC_ID
, LAST_EXECUTION
, EXECUTION_TYPE
, EXECUTION_TYPE#
, EXECUTION_DESCRIPTION
, EXECUTION_START
, EXECUTION_END
, STATUS
, STATUS_MESSAGE
, PCT_COMPLETION_TIME
, PROGRESS_METRIC
, METRIC_UNITS
, ACTIVITY_COUNTER
, RECOMMENDATION_COUNT
, ERROR_MESSAGE
, SOURCE
, HOW_CREATED
, READ_ONLY
, SYSTEM_TASK
, ADVISOR_ID
, STATUS#
, DBID
, DBNAME
, DBVERSION
, ANALYSIS_VERSION
, BEGIN_SNAP_ID
, BEGIN_TIME
, END_SNAP_ID
, END_TIME
, REQUESTED_ANALYSIS
, ACTUAL_ANALYSIS
, DATABASE_TIME
, ACTIVE_SESSIONS
, METER_LEVEL
, FDG_COUNT
FROM SYS.DBA_ADDM_TASKS;
|
|
|