DBA Data[Home] [Help] [Dependency Information]

VIEW: SYS.DBA_OPTSTAT_OPERATION_TASKS

Object Details
Object Name: DBA_OPTSTAT_OPERATION_TASKS
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

Tasks that are performed as part of statistics operations

[View Source]

Columns
Name Datatype Length Mandatory Comments
OPID NUMBER

Internal identifier for the operation that the task belongs to
TARGET VARCHAR2 (100)
Target name in the form of OWNER.TABLE.PART
TARGET_OBJN NUMBER

Target object number
TARGET_TYPE VARCHAR2 (40)
Target type (e.g., TABLE, INDEX, etc.)
TARGET_SIZE NUMBER

Target size in terms of the number of blocks
START_TIME TIMESTAMP(6) WITH TIME ZONE (13)
Task start time
END_TIME TIMESTAMP(6) WITH TIME ZONE (13)
Task end time
STATUS VARCHAR2 (49)
Task completion status
JOB_NAME VARCHAR2 (50)
Name of the scheduler job in which the task runs
ESTIMATED_COST NUMBER

Estimated cost of the task
BATCHING_COEFF NUMBER

Ratio of the task cost and the internal batching threshold
ACTIONS NUMBER

Number of extra subtasks (e.g., histograms) done in this task
PRIORITY NUMBER

Rank/priority of the target in its group
FLAGS NUMBER

Internal flags for the task
NOTES VARCHAR2 (4000)
Additional notes about the task
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT OPID
,      TARGET
,      TARGET_OBJN
,      TARGET_TYPE
,      TARGET_SIZE
,      START_TIME
,      END_TIME
,      STATUS
,      JOB_NAME
,      ESTIMATED_COST
,      BATCHING_COEFF
,      ACTIONS
,      PRIORITY
,      FLAGS
,      NOTES
FROM SYS.DBA_OPTSTAT_OPERATION_TASKS;

Dependencies

[top of page]

SYS.DBA_OPTSTAT_OPERATION_TASKS references the following:

SchemaSYS
TableWRI$_OPTSTAT_OPR_TASKS
SYS.DBA_OPTSTAT_OPERATION_TASKS is referenced by following:

SchemaPUBLIC
SynonymDBA_OPTSTAT_OPERATION_TASKS
SchemaSYS
Package BodyDBMS_STATS_INTERNAL - show dependent code