dindex.sql

rem  dindex.sql
rem
rem  linesize = 131
rem
set linesize 132
rem
ttitle 'Index Storage Parameters'
rem
col table_owner format a12 heading 'TABLE OWNER'
col table_name format a30 heading 'TABLE NAME'
col table_type format a7 heading 'TABLE|TYPE'
col u format a1
col index_name format a30 heading 'INDEX NAME'
col tablespace_name format a10 heading 'TABLESPACE'
col initial_extent format 999999 heading 'INITIAL|EXTENT|(K)'
col next_extent format 999999 heading 'NEXT|EXTENT|(K)'
col pct_increase format 999 heading 'PCT|INC'
col min_extents format 999 heading 'MIN|EXT'
col max_extents format 999 heading 'MAX|EXT'
col pct_free format 999 heading 'PCT|FREE'
rem
break on table_owner skip 1 on table_name on table_type
rem
select table_owner, table_name, table_type,
       decode( uniqueness, 'UNIQUE', 'U', null ) u, index_name,
       tablespace_name,
       initial_extent/1024 initial_extent,
       next_extent/1024 next_extent, pct_increase,
       min_extents, max_extents, pct_free
  from sys.dba_indexes
 where table_owner like nvl(upper('&owner'),'%')
 order by table_owner, table_name, index_name;
rem
set linesize 80