如何知道oracle表的索引使用率？
您好： 由于历史原因，一些大表的索引创建后就一直没用过，或者很少用，想删除这些不常用的索引，怎么能查询出这些索引了？ 收起
查看其它 6 个回答drdb2 的回答
need to install the statspack
To install Statspack, perform the following:
Start SQL*Plus.
Connect as a user with SYSDBA privilege. For example:
SQL> CONNECT / AS SYSDBA
Run the SPCREATE.SQL script.
On UNIX platforms, enter the following:
SQL> @?/rdbms/admin/spcreate
http://docs.oracle.com/cd/B10500 ... a96533/statspac.htm
To install Statspack, perform the following:
Start SQL*Plus.
Connect as a user with SYSDBA privilege. For example:
SQL> CONNECT / AS SYSDBA
Run the SPCREATE.SQL script.
On UNIX platforms, enter the following:
SQL> @?/rdbms/admin/spcreate
http://docs.oracle.com/cd/B10500 ... a96533/statspac.htm