Oracle index partition

SELECT INDEX_NAME,
       PARTITION_NAME,
       TABLESPACE_NAME,
       INITIAL_EXTENT,
       NEXT_EXTENT,
       PCT_INCREASE,
       NUM_ROWS
FROM DBA_IND_PARTITIONS
WHERE INDEX_NAME = decode(upper('my_index'), 'ALL', INDEX_NAME, upper('my_index'))
  AND INDEX_OWNER = upper('my_owner')
ORDER BY INDEX_NAME, PARTITION_NAME;

Similar codes

4 votes231 views2 answers
Could not find driver (SQL: SHOW FULL TABLES WHERE table_type = 'BASE TABLE')
SQL
0 vote216 views1 answer
Mysql undo delete
SQL
0 vote220 views1 answer
Uninstall mysql ubuntu 18.04 stackoverflow
SQL
0 vote223 views1 answer
Sort by
SQL
0 vote212 views1 answer
Drop all data from tables
SQL
0 vote239 views1 answer
Primary key multiple
SQL
0 vote231 views2 answers
Call to undefined function mysqli_fetch_all()
SQL
5 votes235 views2 answers
Mysql dump mysql db cli
SQL
0 vote201 views1 answer
Select from 3 tables one is empty
SQL
0 vote207 views1 answer
Search db for table name
SQL