CREATE OR REPLACE PROCEDURE PRC_MONITOR_INDEX 
AS
  TYPE IND_ARRAY_TYPE IS TABLE OF USER_INDEXES.INDEX_NAME%TYPE
  INDEX BY BINARY_INTEGER;
  IND_ARRAY_VAR IND_ARRAY_TYPE; 
BEGIN
SELECT DISTINCT INDEX_NAME bulk collect into IND_ARRAY_VAR 
  FROM USER_INDEXES 
 WHERE INDEX_TYPE NOT IN ('LOB');

FOR  I IN 1..IND_ARRAY_VAR.COUNT  
LOOP
   EXECUTE IMMEDIATE 'ALTER INDEX '||IND_ARRAY_VAR(I)||' MONITORING USAGE ';
END LOOP;
END;