Re: Read Only Transactions

From: Ana C. Dent <anacedent_at_hotmail.com>
Date: Wed, 13 Aug 2003 16:07:29 -0700
Message-ID: <Rwz_a.56832$Ne.50284_at_fed1read03>


R_M wrote:

> Hi:
>
> I am new to Oracle and have a probably trivial concurrency question.
>
> How is an ROT implemented ?
>
> Suppose I create an ROT
> and then issue the following commands:
> select * from table A where colx=3
> select * from table A where colx != 3
> select * from table B
> select * from table A where colx=2
> select * from table B
>
> Is the contents of tables A and B saved aside so any concurrent update
> transactions succeed ?

Kind of.
Changes to the tables are "saved" so you continue to be presented with data as it existed at the start of your ROT.

> Or are tables A and B blocking updates until I close the ROT.

NO blocking occurs.
In Oracle Readers NEVER block writers! Received on Thu Aug 14 2003 - 01:07:29 CEST

Original text of this message