Index alteredSQL> ALTER INDEX DEPT_LOCATION_IX NOMONITORING USAGE; Index alteredSQL> ALTER INDEX EMP_DEPARTMENT_IX NOMONITORING USAGE; Index alteredSQL> ALTER INDEX EMP_EMAIL_UK NOMONITORING USAGE; Index alteredSQL> ALTER INDEX EMP_EMP_ID_PK NOMONITORING USAGE; Index alteredSQL> ALTER INDEX EMP_JOB_IX NOMONITORING USAGE; Index alteredSQL> ALTER INDEX EMP_MANAGER_IX NOMONITORING USAGE; Index alteredSQL> ALTER INDEX EMP_NAME_IX NOMONITORING USAGE; Index alteredSQL> ALTER INDEX JHIST_DEPARTMENT_IX NOMONITORING USAGE; Index alteredSQL> ALTER INDEX JHIST_EMP_ID_ST_DATE_PK NOMONITORING USAGE; Index alteredSQL> ALTER INDEX JHIST_EMPLOYEE_IX NOMONITORING USAGE; Index alteredSQL> ALTER INDEX JHIST_JOB_IX NOMONITORING USAGE; Index alteredSQL> ALTER INDEX JOB_ID_PK NOMONITORING USAGE; Index alteredSQL> ALTER INDEX LOC_CITY_IX NOMONITORING USAGE; Index alteredSQL> ALTER INDEX LOC_COUNTRY_IX NOMONITORING USAGE; Index alteredSQL> ALTER INDEX LOC_ID_PK NOMONITORING USAGE; Index alteredSQL> ALTER INDEX LOC_STATE_PROVINCE_IX NOMONITORING USAGE; Index alteredSQL> ALTER INDEX REG_ID_PK NOMONITORING USAGE; Index alteredConsultando e analisando o monitoramento:SQL> SELECT INDEX_NAME, TABLE_NAME, MONITORING, USED, START_MONITORING, END_MONITORING 2 FROM V$OBJECT_USAGE 3 ORDER BY TABLE_NAME, INDEX_NAME; INDEX_NAME TABLE_NAME MONITORING USED START_MONITORING END_MONITORING------------------------------ ------------------------------ ---------- ---- ------------------- -------------------DEPT_ID_PK DEPARTMENTS NO NO 09/15/2011 22:17:45 09/15/2011 23:12:15DEPT_LOCATION_IX DEPARTMENTS NO NO 09/15/2011 22:17:45 09/15/2011 23:12:15EMP_DEPARTMENT_IX EMPLOYEES NO YES 09/15/2011 22:17:45 09/15/2011 23:12:15EMP_EMAIL_UK EMPLOYEES NO YES 09/15/2011 22:17:45 09/15/2011 23:12:15EMP_EMP_ID_PK EMPLOYEES NO NO 09/15/2011 22:17:45 09/15/2011 23:12:15EMP_JOB_IX EMPLOYEES NO NO 09/15/2011 22:17:45 09/15/2011 23:12:15EMP_MANAGER_IX EMPLOYEES NO NO 09/15/2011 22:17:45 09/15/2011 23:12:15EMP_NAME_IX EMPLOYEES NO NO 09/15/2011 22:17:45 09/15/2011 23:12:15JHIST_DEPARTMENT_IX JOB_HISTORY NO NO 09/15/2011 22:17:45 09/15/2011 23:12:15JHIST_EMP_ID_ST_DATE_PK JOB_HISTORY NO NO 09/15/2011 22:17:45 09/15/2011 23:12:15JHIST_EMPLOYEE_IX JOB_HISTORY NO NO 09/15/2011 22:17:45 09/15/2011 23:12:15JHIST_JOB_IX JOB_HISTORY NO NO 09/15/2011 22:17:45 09/15/2011 23:12:15JOB_ID_PK JOBS NO NO 09/15/2011 22:17:45 09/15/2011 23:12:15LOC_CITY_IX LOCATIONS NO NO 09/15/2011 22:17:45 09/15/2011 23:12:16LOC_COUNTRY_IX LOCATIONS NO NO 09/15/2011 22:17:45 09/15/2011 23:12:16LOC_ID_PK LOCATIONS NO NO 09/15/2011 22:17:45 09/15/2011 23:12:16LOC_STATE_PROVINCE_IX LOCATIONS NO NO 09/15/2011 22:17:45 09/15/2011 23:12:16REG_ID_PK REGIONS NO NO 09/15/2011 22:17:45 09/15/2011 23:12:16 18 rows selectedNeste estudo de caso foram monitorados 18 indices, o monitoramento iniciou dia 15/09/2011 as 22:17 e terminou no dia 15/09/2011 as 23:12, e detectou que apenas os indices EMP_DEPARTMENT_IX e EMP_EMAIL_UK foram acessados durante o monitoramento.ConclusaoComo foi demostrado neste artigo, o processo de monitoramento do uso de indice e uma tarefa simples e facil que pode trazer boas informacoes para o DBA tomar decisao. Desde alteracao dos indices ate a propria remocao. Foi apresentado os passos de forma teorica seguida de um estudo de caso com o esquema HR.Gostou do artigo? Ajude a divulga-lo clicando no botao +1