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

0 vote184 views1 answer
Sql cmd no truncate
SQL
0 vote164 views1 answer
Update and keep original value sql
SQL
0 vote210 views1 answer
I wanted to select among the rows the highest value in mysql
SQL
0 vote166 views1 answer
Psql initialization
SQL
-1 vote179 views1 answer
Add bool column in sql
SQL
5 votes185 views1 answer
AND OR NOT operators sql
SQL
0 vote185 views1 answer
Grant owner postgresql
SQL
0 vote158 views1 answer
Sql string length postgresql
SQL
5 votes159 views1 answer
Oracle scan source ddl
SQL
0 vote179 views1 answer
Oracle INTERVAL DAY to second to number
SQL