This might be a good starting point. http://blogs.oracle.com/db/entry/oracle_support_master_note_for_diagnosis_of_issues_related_to_general_database_performance I can't find a link to the "help my database is hung!" paper any longer via google. A quick hang analyze at level 4 will get you started with the smallest size trace file to have to review. alter session set tracefile_identifier='here_i_am'; alter session set events 'immediate trace name hanganalyze level 4'; alter session set tracefile_identifier=''; hth. Paul On Wed, Aug 24, 2011 at 8:21 AM, mek s <sidi.bouzid.meknessy@xxxxxxxxx>wrote: > Hello, > > in 11gR2 and Solaris. > > We are facing deadlock ORA-00060 errors; here the deadlock graph, any idea? > > Deadlock graph: > ---------Blocker(s)-------- > ---------Waiter(s)--------- > Resource Name process session holds waits process session holds > waits > TX-001a0002-0002a0fe 196 197 X 166 1835 > S > TM-0000c800-00000000 166 1835 SX 196 197 SX > SSX > > > > thank you, > S >