8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | 21c | 23c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux
Script: index_usage.sql
( Download Script )
-- ----------------------------------------------------------------------------------- -- File Name : https://oracle-base.com/dba/monitoring/index_usage.sql -- Author : Tim Hall -- Description : Shows the usage for the specified table indexes. -- Call Syntax : @index_usage (table-name) (index-name or all) -- Last Modified: 04/02/2005 -- ----------------------------------------------------------------------------------- SET VERIFY OFF SET LINESIZE 200 SELECT table_name, index_name, used, start_monitoring, end_monitoring FROM v$object_usage WHERE table_name = UPPER('&1') AND index_name = DECODE(UPPER('&2'), 'ALL', index_name, UPPER('&2'));