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 vote146 views4 answers
Alter schema sql
SQL
-1 vote147 views3 answers
SQL MM/dd/yyyy format
SQL
1 vote117 views1 answer
Oracle stop job
SQL
9 votes111 views3 answers
Where in sql
SQL
0 vote108 views1 answer
Search In the Database using Text
SQL
3 votes110 views1 answer
Oracle user quota unlimited
SQL
8 votes130 views2 answers
Change name of colum in sql table
SQL
0 vote119 views1 answer
Mysql date format unix timestamp
SQL
0 vote175 views2 answers
Wordpress change url in database
SQL
0 vote147 views1 answer
Select top values sql
SQL