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 vote201 views2 answers
SQLSTATE[HY000]: General error: 3780 Referencing column 'role_id' and referenced column 'id' in foreign key constraint 'user_role_id foreign' are incompatible.
SQL
1 vote175 views1 answer
Sometimes i cant edit sql developer
SQL
0 vote219 views1 answer
Redshift running queries
SQL
0 vote137 views1 answer
Mysql sleep connections
SQL
1 vote187 views1 answer
Replace all numbers in mysql
SQL
0 vote255 views2 answers
Sqlalchemy default value for column
SQL
9 votes168 views4 answers
Mysql show table fields
SQL
0 vote164 views1 answer
Oracle list of long running queries
SQL
2 votes175 views1 answer
Ssh mysql port forwarding
SQL
0 vote178 views1 answer
How to select all fieldsin a soql query
SQL