Re: Read only blocking

  • From: Alex Fatkulin <afatkulin@xxxxxxxxx>
  • To: Joel.Patterson@xxxxxxxxxxx
  • Date: Tue, 23 Nov 2010 15:53:02 -0500

Did you happen to capture lock levels and types for requester and a holder?

A regular select can get blocked in case of in-doubt distributed
transaction, for example, but you need type and lock levels to say
what was causing the lock.

-- 
Alex Fatkulin,
http://afatkulin.blogspot.com
http://www.linkedin.com/in/alexfatkulin
--
//www.freelists.org/webpage/oracle-l


Other related posts: