Database Tuning (MOSC)

MOSC Banner

How to find the SQL that uses an specific index

edited Aug 21, 2013 8:53AM in Database Tuning (MOSC) 13 commentsAnswered ✓
Hello,
I have started to get deadlock alerts on a database when concurrent sessions are trying to insert data in a table that has a bitmap index.
I monitored the index and It has been marked as used (alter index ... monitoring usage;)
I am not certain about what operations actually will mark the index as used, Is it only Select statements?
The other question is, Is is possible to find the exact SQL statements that use an index?

Thanks in advance,

Daniel

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center