Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Index usage ?
Hi !
Due to a migration from 7.3.4 to 8.0.5.1 we're trying to analyze the database, specialy the index usage.
On a big table (1.G GB) we have several indexes on different rows. The Application makes several statements to the DB - I could not figure out which statements or which index is used.
So i want to finde out which of those 9 indexes is realy used and which not. I know the 'explain stuff' and some of the x$bh stuff.
Does anyone know where to look which index is actually used or which not. To spool the hole sga to a dumpfile - select the staments and the try every statment with 'explain plan' would costs to much time. Even to trace a hole session. The optimizer is on choose.
Any Idea ?
Thx in adv.
Alexander
--
Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.
Received on Tue Jul 13 1999 - 18:03:51 CDT