实验环境

搭建平台：VMware Workstation

OS：RHEL 6.10

Grid&DB：Oracle 11.2.0.4

SQL参考

select owner, index_name, clustering_factor

  from dba_indexes

 where owner = 'aaa'  --用户名

   and index_name = 'ccc';  --索引名