SELECT 'ALTER INDEX ARADMIN.'||INDEX_nAME||' NOMONITORING USAGE;' fROM DBA_iNDEXES WHERE TABLE_NAME='AP'
ALTER INDEX INDEX_B1 MONITORING USAGE;
ALTER INDEX INDEX3 MONITORING USAGE;
ALTER INDEX INDEX4 MONITORING USAGE;
ALTER INDEX INDEX5 MONITORING USAGE;
SELECT * fROM V$OBJECT_USAGE
ALTER INDEX INDEX_B1 noMONITORING USAGE;
ALTER INDEX INDEX3 noMONITORING USAGE;
ALTER INDEX INDEX4 noMONITORING USAGE;
ALTER INDEX INDEX5 noMONITORING USAGE;