hello friends,
I am looking for a better way to get list of tables and indexes (along with the exact owner of the table & index) being used by a specific sql , for a specific execution plan in the DB.
I want to understand if i can make some visualization tool of how objects are being accessed.
I can get some idea in v$sql_plan , the object_name column but it is becoming a bit complicated when the actual object is under a different user. For e.g. when synonyms are used to point to object residing in a different schema and there are multiple schemas having objects with same name.
Regs,
Sachin.