DECLARE
  su NUMBER; 
  sa NUMBER;
  cp NUMBER;
BEGIN
  dbms_space.object_space_usage( CurIdx.owner, CurIdx.index_name, 'INDEX', NULL, su, sa, cp);
  dbms_output.put_line('Space Used: ' || TO_CHAR(su)/1024||' K');
  dbms_output.put_line('Space Allocated: ' || TO_CHAR(sa)/1024 ||' K');
  dbms_output.put_line('Chained Percentage: ' || TO_CHAR(cp));
END;
/

alter index ' || CurIdx.owner || '.' || CurIdx.index_name || ' rebuild

dbms_stats.gather_table_stats( ownname => aOwner, tabname => aTblName, cascade => TRUE );

DECLARE
  ...
BEGIN
  dbms_space.object_space_usage(  'some_owner',  'some_index', ....
END;

alter table ' || Cur.owner || '.' || Cur.table_name || ' move