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 vote183 views1 answer
Power bi dax add related shows column but not working
SQL
1 vote189 views3 answers
Getdate function in postgresql
SQL
8 votes188 views2 answers
Between operator
SQL
0 vote191 views1 answer
How to delete duplicate rows in oracle
SQL
0 vote170 views1 answer
Mysql database is not starting in xampp
SQL
3 votes170 views1 answer
Select without null values sql
SQL
0 vote192 views1 answer
Mariadb set vertical output format
SQL
0 vote170 views1 answer
Como verificar registros duplicados no sql postgresql
SQL
0 vote155 views1 answer
Mysql workbench search all tables
SQL
0 vote167 views1 answer
What alter does in db
SQL