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

58 votes473 views4 answers
Mysql drop column
SQL
5 votes260 views3 answers
Mysql check if null or empty string
SQL
0 vote256 views1 answer
Postgres: Create Column add constraint to the column with Query Output
SQL
7 votes268 views4 answers
Mysql delete older duplicates
SQL
3 votes279 views3 answers
Stop mysql ubuntu
SQL
1 vote289 views2 answers
Grab part of a string sql
SQL
0 vote317 views1 answer
Finding leap year in sql
SQL
0 vote321 views1 answer
How to get number of months between 2 dates sql server
SQL
7 votes285 views4 answers
What is my mysql version
SQL
0 vote260 views1 answer
Oracle last character of string
SQL