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

VIEW: SYS.CDB_AUTO_SEGADV_CTL

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

in all containers

[View Source]

Columns
Name Datatype Length Mandatory Comments
AUTO_TASKID NUMBER

Creation Task id of the auto segment advisor job
TABLESPACE_NAME VARCHAR2 (30)
Tablespace Name of the tablespace processed by the auto segment advisor
SEGMENT_OWNER VARCHAR2 (128)
Owner of the segment processed by the auto segment advisor
SEGMENT_NAME VARCHAR2 (128)
Name of the segment processed by the auto segment advisor
SEGMENT_TYPE VARCHAR2 (18)
Type of the segment processed by the auto segment advisor
PARTITION_NAME VARCHAR2 (128)
Name of the partition processed by the advisor
STATUS VARCHAR2 (40)
Status of the auto advisor task for this segment or tablespace
REASON VARCHAR2 (40)
Reason why this segment or tablespace is chosen for analysis
REASON_VALUE NUMBER

Reason value for the segment or tablespace
CREATION_TIME TIMESTAMP(6) (11)
Time at which this entry was created
PROCESSED_TASKID NUMBER

The auto task id that processed this segment
END_TIME TIMESTAMP(6) (11)
Time at which the segment was completely processed
CON_ID NUMBER

container id
Query Text

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


SELECT AUTO_TASKID
,      TABLESPACE_NAME
,      SEGMENT_OWNER
,      SEGMENT_NAME
,      SEGMENT_TYPE
,      PARTITION_NAME
,      STATUS
,      REASON
,      REASON_VALUE
,      CREATION_TIME
,      PROCESSED_TASKID
,      END_TIME
,      CON_ID
FROM SYS.CDB_AUTO_SEGADV_CTL;

Dependencies

[top of page]

SYS.CDB_AUTO_SEGADV_CTL does not reference any database object

SYS.CDB_AUTO_SEGADV_CTL is referenced by following:

SchemaPUBLIC
SynonymCDB_AUTO_SEGADV_CTL