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

2 votes164 views1 answer
Drop sequence
SQL
0 vote189 views2 answers
Mysql show foreign keys
SQL
13 votes148 views2 answers
Mysql order by multiple columns
SQL
1 vote170 views3 answers
How to pass password to mysql command line
SQL
0 vote151 views2 answers
How do I install microsoft SQL on my Mac?
SQL
0 vote142 views1 answer
Select value from previous row in postgresql
SQL
2 votes201 views1 answer
Orcale index size
SQL
0 vote150 views1 answer
Sql gap missing values
SQL
2 votes187 views3 answers
Sql server reseed identity column
SQL
8 votes154 views3 answers
Connect python to mysql
SQL