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

7 votes190 views1 answer
Oracle set sequence value to max(id)
SQL
4 votes208 views1 answer
Phone number sql
SQL
0 vote210 views1 answer
Oracle running queries
SQL
0 vote198 views1 answer
C# check if mysql query modified rows
SQL
0 vote205 views1 answer
Get statis values sql
SQL
0 vote191 views1 answer
Sql get guid
SQL
2 votes198 views1 answer
Apex execute batch job
SQL
0 vote222 views1 answer
Postgres duplicate database in same server while other session is using source database
SQL
9 votes215 views6 answers
Check constraint in sql
SQL
1 vote192 views1 answer
Find a column in all tables postgres
SQL