Re: TM Contention (locks type 2, 3, 6)

From: Ls Cheng <>
Date: Tue, 6 Mar 2012 17:34:04 +0100
Message-ID: <>

No, it wasnt possible to find the blocking SQL because the application upgrade introduced some queries which didnt use bind variables and caused constant movement in the shared pool that is why this is has been quite difficult. However somehow a couple of days after the issue disappeared we suspect it was probably some end of month batch processing but still investigating
Received on Tue Mar 06 2012 - 10:34:04 CST

Original text of this message