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

6 votes295 views2 answers
Mysql convert timestamp to date
SQL
0 vote251 views1 answer
List all functions and procedures in postgres query
SQL
1 vote244 views2 answers
Mysql does sentance contain word
SQL
0 vote251 views1 answer
Get the First and Last Word from a String or Sentence
SQL
6 votes298 views3 answers
Psql show columns of table
SQL
0 vote260 views1 answer
How to login to mysql in homestead
SQL
0 vote210 views1 answer
Jooq finding lastest value in table
SQL
35 votes292 views5 answers
Sql alter column
SQL
0 vote253 views1 answer
Oracle sql generate list of days
SQL
2 votes248 views1 answer
Check isolation level in mysql
SQL