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

51 votes445 views6 answers
Installing mysql on ubuntu
SQL
2 votes215 views2 answers
Sql percentage
SQL
2 votes215 views3 answers
Install mysql workbench ubuntu 20.04 terminal
SQL
0 vote215 views3 answers
Sql server import json
SQL
0 vote181 views1 answer
Sqlite3 not commit
SQL
0 vote188 views1 answer
Oracle index hint multiple tables example
SQL
0 vote211 views1 answer
Run mysql xampp shell
SQL
38 votes206 views6 answers
Alter table mysql
SQL
16 votes209 views2 answers
Oracle ddl
SQL
0 vote196 views1 answer
What does the -p flag do in mysql cli
SQL