enq: TM - contention

Hi,

For know what FK is not indexed, run the query bellow:

SELECT * FROM (

SELECT c.owner, c.table_name, cc.column_name, cc.position column_position

FROM   dba_constraints c, dba_cons_columns cc

WHERE  c.constraint_name = cc.constraint_name

AND    c.constraint_type = 'R'

AND c.owner like 'owner'

MINUS

SELECT i.owner, i.table_name, ic.column_name, ic.column_position

FROM   dba_indexes i, dba_ind_columns ic

WHERE  i.index_name = ic.index_name

AND i.owner like 'owner'

)

ORDER BY owner,table_name, column_position;

Hope this help you.

Regards

when the table is empty this happens too

so don't just skip the empty tables ... also add an index on those tables showing the enq lock

you should be getting an TM03 in P1 for this