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

1 vote168 views1 answer
Sql in array query
SQL
0 vote137 views1 answer
Run sql script file and changes db name in this file using c#
SQL
0 vote150 views1 answer
Insert using condition postgres
SQL
0 vote141 views1 answer
Watch mysql command line
SQL
6 votes148 views2 answers
Drop foreign key
SQL
8 votes139 views2 answers
Mysql grant all privileges to user from any host
SQL
1 vote140 views1 answer
Temp table vs variable table in sql server
SQL
7 votes142 views3 answers
Postgre describe table
SQL
1 vote129 views1 answer
Set id count mysql
SQL
0 vote152 views2 answers
Port 5432 is already in use mac
SQL