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 vote260 views2 answers
How to select the lowest values from table per client sql
SQL
0 vote296 views2 answers
Generate sql trigger through ef migration
SQL
0 vote228 views1 answer
Delete all rows from table sqlite
SQL
3 votes238 views1 answer
Get all elements sql
SQL
1 vote259 views1 answer
Postgres delete from where date is greater than specific date
SQL
3 votes284 views1 answer
APEX elapsed time
SQL
11 votes264 views1 answer
Sql insert multiple rows from select
SQL
0 vote272 views1 answer
Sql examples from framework
SQL
0 vote266 views1 answer
MQL4 mql4 run ea on all symbols by adding to just one chart
SQL
1 vote263 views1 answer
Oracle sql average
SQL