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

0 vote167 views1 answer
Python sqlalchemy orm to select null values
SQL
0 vote189 views1 answer
Dataframe lambda elif
SQL
0 vote198 views2 answers
PostgreSQL having
SQL
7 votes260 views1 answer
Oracle alter sequence restart start with
SQL
1 vote171 views1 answer
DATE_SUB postgres
SQL
1 vote184 views4 answers
Get week day from date in sql
SQL
4 votes209 views6 answers
Select sql
SQL
0 vote183 views1 answer
Tsql pad left
SQL
0 vote180 views1 answer
Drop view in mysql
SQL
0 vote191 views1 answer
What is server_default = func.now() in sqlalchemy
SQL