DBA Data[Home] [Help]

VIEW: SYS.DBA_AUTO_SEGADV_CTL

Source

View Text - Preformatted

select stats.auto_taskid, stats.tablespace_name, stats.segment_owner,
       stats.segment_name, stats.segment_type, stats.partition_name,
       stats.status, stats.reason, stats.reason_value,
       stats.creation_time, stats.proc_taskid, stats.end_time
from   wri$_segadv_objlist stats
View Text - HTML Formatted

SELECT STATS.AUTO_TASKID
, STATS.TABLESPACE_NAME
, STATS.SEGMENT_OWNER
, STATS.SEGMENT_NAME
, STATS.SEGMENT_TYPE
, STATS.PARTITION_NAME
, STATS.STATUS
, STATS.REASON
, STATS.REASON_VALUE
, STATS.CREATION_TIME
, STATS.PROC_TASKID
, STATS.END_TIME FROM WRI$_SEGADV_OBJLIST STATS