Re: Changing isolation level?

"Hemant Shah" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
| While stranded on information super highway mcstock wrote:
| :)refer to the SET TRANSACTION statement in the SQL Reference manual
| :)
| :)relevant options are: ISOLATION LEVEL SERIALIZABLE and ISOLATION LEVEL
READ
| :)COMMITTED (default)
| :)
| :)doesn't look like ISOLATION LEVEL SERIALIZABLE does what you want
| :)
| :)
| :)you'll also want to carefully review the sections on Data Concurrency
and
| :)Consistency in the Concepts manual
| :)
|
|
|  As others have mentioned, none of the isolation level will block readers.
|  I will have to find some other way.
|

why do you need to block readers?
what is the business benefit?
is it just to make oracle look like DB2?

if you can describe a business benefit and the required behavior from a
application functionality standpoint, i'm sure a number of folks can come up
with suggested approaches.

-- mcs