setting transaction isolation level to read only [message #374515] |
Fri, 15 June 2001 14:34 |
scott
Messages: 73 Registered: September 1999
|
Member |
|
|
Found this in Oracle documentation:
SET TRANSACTION ISOLATION LEVEL READ ONLY;
when I try to set the isolation level to read only, I get the following:
SQL*Plus: Release 8.1.7.0.0 - Production on Mon Jun 11 08:56:29 2001
(c) Copyright 2000 Oracle Corporation. All rights reserved.
Connected to:
Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production
SQL> SET TRANSACTION ISOLATION LEVEL READ ONLY;
SET TRANSACTION ISOLATION LEVEL READ ONLY
*
ERROR at line 1:
ORA-02179: valid options: ISOLATION LEVEL { SERIALIZABLE | READ COMMITTED }
We have a user that runs a large transaction that experiences numerous rollbacks and who may profit from this more stringent degree of isolation. Any idea why this isn't working and/or how I can enforce the same level of isolation via a different route? thanks for the help.
|
|
|
|