Re: Row locking and serializability

From: Ruud de Koter <ruud_dekoter_at_hp.com>
Date: Wed, 14 Jul 1999 08:50:04 +0200
Message-ID: <378C331C.F11B9DAF@hp.com>

Hi Vadim,

You must be joking. This kills both performance and scalability with a single action. Please insert some indication of sarcasm or irony when you write something like this....

Regards,

Ruud de Koter

Vadim Tropashko wrote:
>
> iggy_fernandez_at_my-deja.com wrote:
>
> > The question that remains unanswered is how
> > serializability may be manually achieved when
> > using Oracle.
>
> This one seems easy -- just lock "the whole" table:
>
> alter session set isolation_level=serializable;
> select * from passengers for update;
> insert into passengers values 'Z';
> commit;
>
> Thransaction above is serializable indeed.

--

---

Ruud de Koter                    HP OpenView Software Business Unit
Senior Software Engineer         IT Service Management Operation
Telephone: +31 (20) 514 15 89    Van Diemenstraat 200  
Telefax  : +31 (2) 514 15 90     PO Box 831
Telnet   : 547 - 1589            1000 AV  Amsterdam, the Netherlands

Email : ruud_dekoter_at_hp.com

internet: http://www.openview.hp.com/itsm

          http://www.openview.hp.com/assetview

intranet: http://ovweb.bbn.hp.com/itservicemanager

--------------------------------------------------------------------------------------

Received on Wed Jul 14 1999 - 01:50:04 CDT