Re: deadlocks , performance issues

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_at_gmail.com>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
>

--
http://www.freelists.org/webpage/oracle-l