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

3 votes316 views1 answer
Index using in query plsql
SQL
31 votes327 views3 answers
Sql count(*)
SQL
17 votes340 views3 answers
Postgresql version command
SQL
0 vote326 views1 answer
SQL Server modify_timestamp trigger
SQL
3 votes332 views4 answers
Mysql delete duplicate rows
SQL
5 votes318 views4 answers
Describe table postgres
SQL
0 vote372 views1 answer
How to install sql in anaconda
SQL
2 votes366 views3 answers
Install mysql workbench ubuntu 20.04 terminal
SQL
5 votes348 views3 answers
Bash: mysql: command not found
SQL
15 votes348 views5 answers
Show tables in oracle
SQL