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

18 votes146 views6 answers
Drop table if exists
SQL
4 votes277 views1 answer
Oracle table statistics
SQL
0 vote139 views1 answer
Order by ip address sql
SQL
0 vote208 views1 answer
Replace null value within column mysql
SQL
1 vote146 views1 answer
Postgresql must appear in the group by clause or be used in an aggregate function
SQL
0 vote152 views2 answers
Python mysql create table if not exists
SQL
2 votes135 views2 answers
Postgresql date at timezone
SQL
0 vote143 views4 answers
Sql year
SQL
0 vote152 views2 answers
Error while setting value 'ONLY_FULL_GROUP_BY,ALLOW_INVALID_DATES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' to 'sql_mode'
SQL
0 vote147 views1 answer
Stored procedure function relation
SQL