Re: deadlock graph -- obj identification

Your deadlock is a transaction-level deadlock, not the more common data-level deadlock.

Note the TX in the resource name ... this explains why using the transaction id like an object id does not find you an object.

Since the deadlock is a mode 4 (Share) deadlock, the commonest reasons are:

    updates on 'close' rows in a bitmap index     ITL starvation within a pair of blocks     conflicting primary key inserts
    parent/child locking issues

Check the SQL dumped with graph, and see if that gives you some clue about which of the above is most likely to be relevant in your case.

Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

  The educated person is not the person
  who can answer the questions, but the
  person who can question the answers -- T. Schick Jr

One-day tutorials:
http://www.jlcomp.demon.co.uk/tutorial.html

____UK_______April 22nd
____USA_(FL)_May 2nd
____Denmark__May 21-23rd
____Sweden___June
____Finland__September
____Norway___September

Three-day seminar:
see http://www.jlcomp.demon.co.uk/seminar.html

____UK_(Manchester)_May x 2
____Estonia___June (provisional)
____Australia_June (provisional)
____USA_(CA, TX)_August

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: 19 April 2003 01:21

> Hello all,
> We are having a deadlock situation and i am trying to locate the
object
> id
> the query that i run is
> select to_number('00020032','xxxxxx') from dual
> and the value that i get, i look into dba_objects where object_id is
the
> one returned from the first query.
>
> When i do that i get no rows returned from dba_objects.
> Am i doing something wrong...???
>
> Deadlock graph:
> ---------Blocker(s)--------
> ---------Waiter(s)---------
> Resource Name process session holds waits process session
holds
> waits
> TX-00020032-0000024d 8 12 X 29 22
> S
> TX-00130039-00001996 29 22 X 8 12
> S
> session 12: DID 0001-0008-00000002 session 22: DID
> 0001-001D-00000002
> session 22: DID 0001-001D-00000002 session 12: DID
> 0001-0008-00000002
>
>
> Thanks,
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jonathan Lewis
  INET: jonathan_at_jlcomp.demon.co.uk

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).