Re: Measuring index usage

Others say:
>>Ooooo, I am so afraid to change anything in a badly architected, poorly
>>designed product that is implemented by a bunch of morons.

Bah, I say if you are not worthless and weak and have a test system go for it.

To your real question: at intervals sample v$sqlare, v$sql, v$access, v$db_object_cache, and any other v$ performance views and look for indexes. This will not be perfect but who cares. The stuff is documented in the Oracle 8 Reference (or whatever version.)

Just make sure to keep a copy of the DDL to recreate any index you whack. Good luck.

-- 
---------------------------------------------------------
Steven Hauser 
email: hause011@tc.umn.edu   URL: http://www.tc.umn.edu/~hause011
---------------------------------------------------------