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

VIEW: SYS.CDB_OPTSTAT_OPERATION_TASKS

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

Tasks that are performed as part of statistics operations in all containers

[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
CON_ID NUMBER

container id
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
,      CON_ID
FROM SYS.CDB_OPTSTAT_OPERATION_TASKS;

Dependencies

[top of page]

SYS.CDB_OPTSTAT_OPERATION_TASKS does not reference any database object

SYS.CDB_OPTSTAT_OPERATION_TASKS is referenced by following:

SchemaPUBLIC
SynonymCDB_OPTSTAT_OPERATION_TASKS
SchemaSYS
Package BodyDBMS_STATS_INTERNAL - show dependent code
PL/SQL PackageDBMS_STATS_INTERNAL - show dependent code