Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: row level (transactional) locking problem

Re: row level (transactional) locking problem

From: Boris Dali <boris_dali_at_yahoo.ca>
Date: Mon, 9 Feb 2004 13:23:04 -0500 (EST)
Message-ID: <20040209182304.21525.qmail@web41411.mail.yahoo.com>


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.


Post your free ad now! http://personals.yahoo.ca

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:23:04 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US