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 vote372 views1 answer
Python dictionary to sql update
SQL
1 vote334 views1 answer
How to get previous year from sysdate in oracle
SQL
0 vote331 views1 answer
Sqlcmd xml output insert line break after every 2033 characters
SQL
0 vote374 views1 answer
Look at running processes redshift
SQL
2 votes329 views1 answer
Oracle percentage
SQL
0 vote320 views1 answer
Groupby error in mysql
SQL
0 vote406 views1 answer
Compress sql file database ubuntu
SQL
3 votes365 views2 answers
Update part of a string in mysql
SQL
0 vote324 views1 answer
Mysql pad zeros
SQL
4 votes292 views2 answers
Access to dialectresolutioninfo cannot be null when 'hibernate.dialect' not set
SQL