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 vote292 views1 answer
How to find median of a column sql
SQL
58 votes599 views6 answers
Create new user in postgres
SQL
1 vote280 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception
SQL
6 votes297 views5 answers
Mysql get last insert id
SQL
1 vote282 views1 answer
How to select random rows from table
SQL
11 votes288 views4 answers
Query DISTINCT
SQL
0 vote323 views1 answer
Move table to a different schema
SQL
1 vote285 views1 answer
Funzioni plsql
SQL
1 vote333 views1 answer
Oracle create program if not exists
SQL
1 vote333 views1 answer
Show databases mysql docker
SQL