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 votes159 views2 answers
What is sql clause
SQL
0 vote172 views1 answer
Get last updated row sql server
SQL
1 vote146 views3 answers
How to filter repeated same result using sql query
SQL
0 vote149 views1 answer
Restart sql server command line linux
SQL
0 vote157 views1 answer
Get employees if not contains in sql
SQL
2 votes167 views1 answer
Apex execute batch job
SQL
3 votes172 views2 answers
Sqlite show table structure
SQL
1 vote154 views2 answers
Mysql filter by date mount
SQL
0 vote140 views1 answer
Cara menampilkan user di mysql terminal
SQL
0 vote162 views3 answers
How to run sql query
SQL