1SELECT INDEX_NAME,
2 PARTITION_NAME,
3 TABLESPACE_NAME,
4 INITIAL_EXTENT,
5 NEXT_EXTENT,
6 PCT_INCREASE,
7 NUM_ROWS
8FROM DBA_IND_PARTITIONS
9WHERE INDEX_NAME = decode(upper('my_index'), 'ALL', INDEX_NAME, upper('my_index'))
10 AND INDEX_OWNER = upper('my_owner')
11ORDER BY INDEX_NAME, PARTITION_NAME;