VIEW: CTXSYS.CTX_USER_AUTO_OPTIMIZE_INDEXES

Source

View Text - Preformatted

select
  o.aoi_idxname aoi_index_name,
  o.aoi_partname aoi_partition_name
  from dr$autoopt o where o.aoi_ownid = userenv('SCHEMAID')

View Text - HTML Formatted

SELECT O.AOI_IDXNAME AOI_INDEX_NAME
, O.AOI_PARTNAME AOI_PARTITION_NAME
FROM DR$AUTOOPT O
WHERE O.AOI_OWNID = USERENV('SCHEMAID')