QUESTION 193- deferred index maintenance

DBA_IND_PARTITIONS.ORPHANDED_ENTRIES contains YES for several index partition. This is due to the use of deferred index maintenance.
Which three method will remove the orphanded keys?

A. using DBMS_PART.CLEANUP_GIDX once to clean up orphanded keys in all local indexes.
B. using ALTER INDEX REBUILD PARTITION once for each affected global index partition.
C. using ALTER INDEX REBUILD PARTITION once for each affected local index partition
D. using DBMS_PART.CLEANUP_GIDX once to cleanup any orphaned keys in all global indexes on partitioned tables.
E. using ALTER INDEX COALESCE PARTITION CLEANUP once for each affected global index partition.
F. using ALTER INDEX COALESCE PARTITION CLEANUP once for each affected local index partition.

Correct Answer: BDE

 

索引延时异步维护，仅支持全局索引，不支持本地local索引，直接排除 ACF。
索引的延时异步维护，有database的一个scheduler job SYS.PMO_DEFERRED_GIDX_MAINT_JOB 自动定
时完成。
手动完成维护，可以执行 DBMS_PART.CLEANUP_GIDX procedure 来完成
或者：
ALTER INDEX REBUILD [PARTITION]; -- 重建整个索引
ALTER INDEX [PARTITION COALESCE CLEANUP; -- 清理索引块中的 orphand entries.