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

24 votes186 views5 answers
Sql server insert into select
SQL
0 vote977 views1 answer
Mysql max connections exceeded max_connections_per_hour
SQL
0 vote200 views1 answer
Creating h2 database in relative directory eclopse
SQL
17 votes180 views6 answers
Mysql import sql file
SQL
1 vote178 views1 answer
Create sample data postgresql
SQL
6 votes201 views1 answer
T-sql test if table exists
SQL
2 votes188 views2 answers
Select sqlite3.OperationalError: no such column:
SQL
3 votes179 views2 answers
Sql paging query
SQL
24 votes223 views4 answers
Delete db postgres
SQL
1 vote183 views1 answer
Postgresql convert text to float
SQL