Re: help understand my lock

From: NetComrade <netcomradeNSPAM_at_bookexchange.net>
Date: Mon, 20 Mar 2006 11:59:28 -0500
Message-ID: <a7nt129mpigr2mjkk44egvloev16khh22u@4ax.com>

On 19 Mar 2006 09:32:05 -0800, krichine_at_juno.com wrote:

>Not knowing what tfslock does, my guess is that you ARE trying to lock
>the same row.
>The value of 0 is a valid row number in the block, it is simply the
>first row in this block.

Thank you for reminding me how computers operate (0's are valid) and stopping me from wasting any more time on it :)

The application locks the row(s) in this manner

select * from div where group_id in (:var1:,var2)

One of the vars must have a default value of 1.

select rowid, group_id,

dbms_rowid.rowid_relative_fno(rowid) fileno,
dbms_rowid.rowid_block_number(rowid) blockno,
dbms_rowid.rowid_row_number(rowid) rowno, rownum

from div

ROWID GROUP_ID FILENO BLOCKNO ROWNO ROWNUM --------------- ---------- ---------- ---------- ---------- ---------- AAABgDAAFAAACASAAA 1 5 8210 0 1

By the way, found a great paper while looking how to read oracle block dumps..

http://www.nyoug.org/20050929tuningoracle.pdf .......
We run Oracle 9.2.0.6 on RH4 AMD
remove NSPAM to email Received on Mon Mar 20 2006 - 10:59:28 CST