Re: Ordered For Update

From: Charles Hooper <hooperc2001_at_gmail.com>
Date: Mon, 21 Nov 2011 09:03:16 -0800 (PST)
Message-ID: <c2ae6bda-7913-46f0-8784-4d5af51c618e_at_w7g2000yqc.googlegroups.com>

On Nov 21, 11:34 am, Mark D Powell <Mark.Powe..._at_hp.com> wrote:
> Charles, Nice example.
>
> HTH -- Mark D Powell

Thanks Mark.

I should have clarified that V$SESSION_WAIT reports the OBJECT_ID, while DBMS_ROWID.ROWID_CREATE function expects the DATA_OBJECT_ID. The two values will be the same in this test case.

I extended the test case a bit with two indexed access path examples here:
http://hoopercharles.wordpress.com/2011/11/21/select-for-update-in-what-order-are-the-rows-locked/

Charles Hooper
http://hoopercharles.wordpress.com/
IT Manager/Oracle DBA
K&M Machine-Fabricating, Inc. Received on Mon Nov 21 2011 - 11:03:16 CST