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

5 votes236 views2 answers
Postgresql insert select
SQL
8 votes200 views3 answers
Connect python to mysql
SQL
7 votes248 views1 answer
Xampp reset mysql
SQL
0 vote211 views1 answer
Check for directory in bash
SQL
1 vote198 views1 answer
Neo4j display all nodes and relationships
SQL
0 vote211 views1 answer
Describe in sqlite3
SQL
0 vote215 views1 answer
Access mysql database docker container shell
SQL
8 votes297 views1 answer
Insert a select statement into a table
SQL
0 vote268 views1 answer
Inner join distinct
SQL
0 vote196 views5 answers
Linq cheat sheet
SQL