Re: row level (transactional) locking problem

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Mon, 9 Feb 2004 18:50:42 -0000
Message-ID: <01c601c3ef3d$abf8d200$6702a8c0@Primary>

Either join works:

v$session.addr = v$transaction.ses_addr v$session.taddr = v$transaction.taddr

Session 165:

update t1 ... where pk_col = 99;
select to_char(sysdate,'hh24:mi') from dual;

        time for 4-hour lunch break
            session waits for message from client

Session 266

update t1 ... where pk_col = 99;

session waits for TX enqueue mode 6

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

Next public appearances:
March 2004 Hotsos Symposium - The Burden of Proof March 2004 Charlotte NC OUG - CBO Tutorial April 2004 Iceland

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

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

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

Original Message ----- From: "Boris Dali" <boris_dali_at_yahoo.ca> To: <oracle-l_at_freelists.org> Sent: Monday, February 09, 2004 6:23 PM Subject: Re: row level (transactional) locking problem

Jonathan,

Thanks for your reply (I didn't know how to map XID from a block dump to v$lock.id1/id2 info)

As to distributed transactions, IOTs, bitmap indexes - NO to all.

I will definitely check (when I get there again - secure site w/ no remote access) v$session.taddr for 165 (may be the way I join v$session.taddr = v$transaction.addr is incorrect? Mark suggested v$session.addr = v$transaction.sess_addr - is this how it should work?)

As far as waits is concerned (v$session_wait) - yes 165 waits on 'SQL*Net message from client'.

So how 165 can possibly be blocking 226?

Thanks,
Boris Dali.

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Mon Feb 09 2004 - 12:50:42 CST