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

2 votes165 views1 answer
Sql missing records from another table
SQL
11 votes191 views2 answers
You are using safe update mode
SQL
0 vote156 views1 answer
Play framework connection via windows sql server
SQL
3 votes181 views1 answer
Dbms_scheduler drop_job
SQL
0 vote225 views1 answer
Which MySQL data type to use for storing boolean values
SQL
4 votes148 views1 answer
Refresh postgres config
SQL
2 votes147 views1 answer
How to find table table in stored procedure sql server
SQL
0 vote137 views2 answers
Search stored procedures
SQL
1 vote144 views3 answers
Psql fatal database does not exist
SQL
0 vote143 views1 answer
Mysql create index lost connection
SQL