Re: Better demonstration of the serious transaction bug in Oracle

Oracle8 Enterprise Edition Release 8.0.5.2.1 - Production PL/SQL Release 8.0.5.2.0 - Production
CORE Version 4.0.5.0.0 - Production
TNS for IBM/AIX RISC System/6000: Version 8.0.5.0.0 - Production NLSRTL Version 3.3.2.0.0 - Production

ERROR at line 1:

ORA-08177: can't serialize access for this transaction
ORA-06512: at "SYS.DBMS_SYS_SQL", line 787
ORA-06512: at "SYS.DBMS_SQL", line 328
ORA-06512: at "OPS$ORACLE7.EXECUTE_IMMEDIATE", line 5
ORA-06512: at line 6

Total Transactions

               103

SQL> select count(*) "Correct Transactions" from isolationtest where val = 200;

Correct Transactions

                  94

SQL> select count(*) "Failed Transactions" from isolationtest where val != 200;

Failed Transactions

                  9

mkb

• Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!