Re: Read Only Transactions
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