Database Administration (MOSC)

MOSC Banner

identify statements that use specific index

edited May 4, 2010 2:07AM in Database Administration (MOSC) 1 commentAnswered ✓
  Hello,

BD: 9.2.0.8

I already activated the monitoring and the index in question is being used.

Is there a way to identify the statements that use that index?
For example, if I create a job that runs every 30 minutes and does the following:
insert to table_x select * from v$sql_plan where object_name='INDEX_A';
Can I take the hash_value from this and find the statement? Is this valid?
Is there any other way to find the statements using the index?

Thanks in advance

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