We began to experience this event yesterday afternoon.\u00a0 Normally, oracle takes the TM enqueue (table lock) out when activity is occurring such as an insert and we want to ensure the structure is not changed during the insert.<\/p>\n
\r\nvariable min_snap number\r\nvariable max_snap number\r\n\r\nbegin\r\n select min(snap_id) into :min_snap from dba_hist_snapshot where begin_interval_time > sysdate - &start_of_problem;\r\n select min(snap_id) into :max_snap from dba_hist_snapshot where begin_interval_time > sysdate - &end_of_problem;\r\nend;\r\n\/\r\n\r\nselect count(*),sql_id,p2 object_id \r\n from dba_hist_active_sess_history \r\n where snap_id between :min_snap and :max_snap \r\n and event = 'enq: TM - contention' group by sql_id,p2;\r\n\r\nselect owner,object_type,object_name,last_ddl_time \r\n from dba_objects \r\n where object_id = &object_id_above;\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"We began to experience this event yesterday afternoon.\u00a0 Normally, oracle takes the TM enqueue (table lock) out when activity is occurring such as an insert and we want to ensure the structure is not changed during the insert. variable min_snap…<\/p>\n