Re: how to identify unused indexes

In comp.databases.oracle.server Scott Dudley <scott_at_telesoft.com> wrote:

: is there a way to identify indexes that aren't accessed for
: select/update? trying to identify superfluous indexes in a database of
: some 300+ tables without having to go through hundreds of thousands of
: lines of code.

Try to explain all sql in v$sqlarea periodically ( time consumin )

Try to see in buffer cache for presence of index blocks. These indexes are probably used in SQL staements. Be aware of inserts and updates that loading index blocks into cache too.

: Microsoft gives you Windows but Unix gives you the whole house!
:-)

        Starous Received on Fri Aug 11 2000 - 00:00:00 CDT