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 vote212 views1 answer
How to run parallel queries in sql server with entity framework
SQL
0 vote178 views1 answer
SQL division of an integer by another integer get float CAST
SQL
0 vote249 views1 answer
Check the size of the tables here ordered from the biggest size
SQL
0 vote235 views1 answer
Time data type in mysql
SQL
3 votes195 views3 answers
Django.db.utils.OperationalError: no such table:
SQL
0 vote205 views1 answer
Sql missing values
SQL
1 vote179 views1 answer
PLS-00225 type
SQL
0 vote187 views1 answer
How to search query in python3 sqlite3
SQL
5 votes274 views2 answers
Add days in oracle sql
SQL
0 vote205 views1 answer
Prodection ready postgres database step by step
SQL