oracle TM lock, how-to find who forgot index on FK ?
Lets do TM lock and find out what object should be indexed sess 1 sess 2 I use Tanel Poder sripts in this example this one ( ashtop.sql ) and this one result : or use this scipt to find nonindexed foreing keys: