identify statements that use specific index
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
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
0