Re: 9i Referential Integrity Locking

From: Paul Brewer <paul_at_paul.brewers.org.uk>
Date: Sat, 6 Apr 2002 18:35:14 +0100
Message-ID: <3cb050cb_1@mk-nntp-1.news.uk.worldonline.com>

Good point. I'd overlooked the 'update without changing the value' question, and of course it does make sense that the same lock would take place.

Thanks, Jonathan.
aul

"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message news:1018092890.175.0.nnrp-10.9e984b29_at_news.demon.co.uk...
>
> It depends on the front-end tools.
>
> Some application generators (including Oracle*FORMS,
> up to 4.5, and then you have to set the switch) will perform
> an update by updating every single column on the table.
>
> So you may not think you are updating the primary key,
> but the application code is doing it for you, and even a
> 'update with changing the value' causes the PK/FK
> lock to take place.
>
>
> --
> Jonathan Lewis
> http://www.jlcomp.demon.co.uk
>
> Next Seminar - UK, April 3rd - 5th
> http://www.jlcomp.demon.co.uk/seminar.html
>
> Host to The Co-Operative Oracle Users' FAQ
> http://www.jlcomp.demon.co.uk/faq/ind_faq.html
>
> Author of:
> Practical Oracle 8i: Building Efficient Databases
>
>
Received on Sat Apr 06 2002 - 11:35:14 CST