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 vote347 views1 answer
Sql quary stuf
SQL
0 vote316 views3 answers
Get count of null in column sql
SQL
1 vote320 views1 answer
Sql eliminare un record
SQL
0 vote385 views1 answer
Select * from mysql.proc
SQL
0 vote335 views1 answer
How to make full text search dynamic in mysql
SQL
1 vote348 views1 answer
Increase existing date in sql
SQL
3 votes324 views1 answer
Pl sql escape &
SQL
11 votes327 views1 answer
Mysql order by two columns priority
SQL
1 vote319 views1 answer
How to get mysql db size
SQL
5 votes334 views1 answer
Oracle asynchronous update
SQL