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

TABLE: SYS.WRI$_OPTSTAT_OPR_TASKS

Object Details
Object Name: WRI$_OPTSTAT_OPR_TASKS
Object Type: TABLE
Owner: SYS
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceSYSAUX
PCT Free: 1
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
I_WRI$_OPTSTAT_OPR_TASKS_OPID NORMAL NONUNIQUE TablespaceSYSAUX ColumnOP_ID
I_WRI$_OPTSTAT_OPR_TASKS_OPOBJ NORMAL NONUNIQUE TablespaceSYSAUX ColumnOP_ID
ColumnTARGET_OBJN
I_WRI$_OPTSTAT_OPR_TASKS_STIME FUNCTION-BASED NORMAL NONUNIQUE TablespaceSYSAUX ColumnSYS_EXTRACT_UTC("START_TIME")
I_WRI$_OPTSTAT_OPR_TASKS_TGST NORMAL NONUNIQUE TablespaceSYSAUX ColumnTARGET
ColumnSTATUS
Columns
Name Datatype Length Mandatory Comments
OP_ID NUMBER

JOB_NAME VARCHAR2 (50)
STATUS NUMBER

START_TIME TIMESTAMP(6) WITH TIME ZONE (13)
END_TIME TIMESTAMP(6) WITH TIME ZONE (13)
TARGET VARCHAR2 (100)
TARGET_OBJN NUMBER

TARGET_TYPE NUMBER

TARGET_SIZE NUMBER

ESTIMATED_COST NUMBER

BATCHING_COEFF NUMBER

ACTIONS NUMBER

PRIORITY NUMBER

FLAGS NUMBER

NOTES VARCHAR2 (4000)
SPARE1 NUMBER

SPARE2 NUMBER

SPARE3 NUMBER

SPARE4 VARCHAR2 (1000)
SPARE5 VARCHAR2 (1000)
SPARE6 TIMESTAMP(6) WITH TIME ZONE (13)
Query Text

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


SELECT OP_ID
,      JOB_NAME
,      STATUS
,      START_TIME
,      END_TIME
,      TARGET
,      TARGET_OBJN
,      TARGET_TYPE
,      TARGET_SIZE
,      ESTIMATED_COST
,      BATCHING_COEFF
,      ACTIONS
,      PRIORITY
,      FLAGS
,      NOTES
,      SPARE1
,      SPARE2
,      SPARE3
,      SPARE4
,      SPARE5
,      SPARE6
FROM SYS.WRI$_OPTSTAT_OPR_TASKS;

Dependencies

[top of page]

SYS.WRI$_OPTSTAT_OPR_TASKS does not reference any database object

SYS.WRI$_OPTSTAT_OPR_TASKS is referenced by following:

SchemaSYS
ViewDBA_OPTSTAT_OPERATION_TASKS
Package BodyDBMS_STATS - show dependent code
Package BodyDBMS_STATS_INTERNAL - show dependent code
PL/SQL PackageDBMS_STATS_INTERNAL - show dependent code