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 vote128 views1 answer
Microsoft sql server management studio clear cache
SQL
1 vote178 views1 answer
Error code 1292 mysql workbench
SQL
0 vote181 views1 answer
Sqlite insert or update
SQL
0 vote175 views2 answers
Script all indexes in a database
SQL
0 vote160 views1 answer
Sql view index
SQL
0 vote165 views1 answer
Check psql validity function
SQL
0 vote194 views1 answer
Sql query wordpress export post
SQL
1 vote171 views1 answer
Sql eliminare un record
SQL
0 vote165 views1 answer
Check if record exists mysql
SQL
0 vote218 views1 answer
Sql server datetime
SQL