Shows Index Usage for a Given Table
--
-- Shows Index Usage for a given table.  (All Indexes if 'ALL' is entered for Index_Name).
--
 
SET PAUSE ON
SET PAUSE 'Press Return to Continue'
SET PAGESIZE 60
SET LINESIZE 300
SET VERIFY OFF
 
SELECT table_name,
       index_name,
       used,
       start_monitoring,
       end_monitoring
FROM   v$object_usage
WHERE  table_name = UPPER('&Table_Name')
AND    index_name = DECODE(UPPER('&&Index_Name'), 'ALL', index_name, UPPER('&&Index_Name'))
/

Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License