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

VIEW: SYS.CDB_AUTO_SEGADV_SUMMARY

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

in all containers

[View Source]

Columns
Name Datatype Length Mandatory Comments
AUTO_TASKID NUMBER
Yes Creation Task id of the auto segment advisor job
SNAPID NUMBER

Minimum AWR Snapid that was used to process
SEGMENTS_SELECTED NUMBER

Number of segments selected for analysis
SEGMENTS_PROCESSED NUMBER

Number of segments successfully processed
TABLESPACE_SELECTED NUMBER

Number of tablespaces selected for analysis
TABLESPACE_PROCESSED NUMBER

Number of tablespaces successfully processed
RECOMMENDATIONS_COUNT NUMBER

Number of recommendations generated
START_TIME TIMESTAMP(6) (11)
Time at which this task was started
END_TIME TIMESTAMP(6) (11)
Time at which this task ended
CON_ID NUMBER

container id
Query Text

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


SELECT AUTO_TASKID
,      SNAPID
,      SEGMENTS_SELECTED
,      SEGMENTS_PROCESSED
,      TABLESPACE_SELECTED
,      TABLESPACE_PROCESSED
,      RECOMMENDATIONS_COUNT
,      START_TIME
,      END_TIME
,      CON_ID
FROM SYS.CDB_AUTO_SEGADV_SUMMARY;

Dependencies

[top of page]

SYS.CDB_AUTO_SEGADV_SUMMARY does not reference any database object

SYS.CDB_AUTO_SEGADV_SUMMARY is referenced by following:

SchemaPUBLIC
SynonymCDB_AUTO_SEGADV_SUMMARY