{パフォーマンスの管理その他}ファンクション索引の使用状況を監視

 

https://docs.oracle.com/cd/F19136_01/admin/managing-indexes.html#GUID-8E5379E6-F96D-464D-B601-A279679A49E9

create index sh.f_ind on sh.times(upper(CALENDAR_MONTH_NAME));

alter index sh.f_ind  monitoring usage;

select count(*) from sh.times where upper(CALENDAR_MONTH_NAME) = 'AAA';

select * from DBA_OBJECT_USAGE where table_name = 'TIMES';

alter index sh.f_ind  nomonitoring usage;