Cheeky Cockatoo

Life Advice and Stories, Travel, Oracle Tech, Good Food and More

sel_indx.sql

Download Script

set linesize 150
col index_name format a25
col tablespace_name format a25
col init format 999,999,999
col next format 999,999,999
col min format 999
col max format 9,999
col pct format 999
select index_name, tablespace_name, INITIAL_EXTENT init, NEXT_EXTENT next, MIN_EXTENTS min, MAX_EXTENTS max, PCT_INCREASE pct, last_analyzed
from dba_indexes
where table_name like upper ('%&Table_name%')
order by index_name
/