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

17 votes134 views3 answers
Postgresql version command
SQL
1 vote146 views1 answer
Postgresql filter on
SQL
0 vote162 views1 answer
Sql get latest of 2 datetimes
SQL
17 votes134 views4 answers
Postgres list users
SQL
4 votes142 views3 answers
Drop Table Oracle
SQL
0 vote140 views1 answer
Buscar nombre de columna en todas las tablas sql server
SQL
4 votes135 views2 answers
Delete all table oracle
SQL
2 votes137 views1 answer
Oracle convert run_duration to number
SQL
0 vote130 views1 answer
Mysql select smaller of two values
SQL
0 vote126 views1 answer
Postgres : ERROR: division by zero
SQL