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

VIEW: SYS.DBA_AUTO_SEGADV_SUMMARY

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

[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
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
FROM SYS.DBA_AUTO_SEGADV_SUMMARY;

Dependencies

[top of page]

SYS.DBA_AUTO_SEGADV_SUMMARY references the following:

SchemaSYS
TableWRI$_SEGADV_CNTRLTAB
SYS.DBA_AUTO_SEGADV_SUMMARY is referenced by following:

SchemaPUBLIC
SynonymDBA_AUTO_SEGADV_SUMMARY