[Home] [Help]
VIEW: CTXSYS.CTX_AUTO_OPTIMIZE_INDEXES
Source
View Text - Preformatted
select
o.aoi_ownname aoi_index_owner,
o.aoi_idxname aoi_index_name,
o.aoi_partname aoi_partition_name
from dr$autoopt o
View Text - HTML Formatted
SELECT
O.AOI_OWNNAME AOI_INDEX_OWNER
,
O.AOI_IDXNAME AOI_INDEX_NAME
,
O.AOI_PARTNAME AOI_PARTITION_NAME
FROM DR$AUTOOPT O