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

-1 vote134 views1 answer
Convert google analytics dathourminute to time stamp? sql
SQL
0 vote136 views1 answer
Match end of string regex sql
SQL
0 vote155 views3 answers
Join
SQL
0 vote137 views1 answer
How to check the port of mysql installation in mac
SQL
0 vote129 views1 answer
What is the essence of SQL?
SQL
3 votes168 views3 answers
Restart mysql mac
SQL
0 vote135 views1 answer
Mysql set variable to today's date
SQL
0 vote137 views1 answer
How to check default value of column in sql server
SQL
0 vote152 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception: syntax error in sql statement
SQL
1 vote147 views1 answer
Sql server today minus n
SQL