Re: deadlocks , performance issues

  • From: Paul Drake <bdbafh@xxxxxxxxx>
  • To: sidi.bouzid.meknessy@xxxxxxxxx
  • Date: Wed, 24 Aug 2011 08:42:38 -0400

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
>

Other related posts: