From: gainer@slowmo.almaden.ibm.com (P. Gainer)
Newsgroups: comp.databases.oracle,comp.benchmarks,comp.databases.informix
Subject: Re: TPC-A and -B Benchmarks
Message-ID: <2442@coyote.UUCP>
Date: 6 Jul 93 22:57:41 GMT
References: <2417@coyote.UUCP> <1993Jul5.100714.3618@informix.com>
Sender: news@ibmarc.UUCP
Organization: IBM Almaden Research Center
Lines: 15
Nntp-Posting-Host: slowmo.almaden.ibm.com


In a recent append, alexk@infmuc.informix.com writes...
>To run TPC-C benchmarks a certain isolation level is required (as far as
>I heard). This isolation level is not yet supported by Oracle...
>Any comments on this??

The TPC-C benchmark, as I was given to understand, runs 4 of its 5 
transactions using the Repeatable Read isolation level and the fifth
(the stocklevel transaction) using the Cursor Stability isolation level.

Repeatable Read implies row locks are held until a commit point is
encountered. I don't really know what Oracle supports as regards row
locking. Could someone from Oracle enlighten us?

Pat Gainer
gainer@almaden.ibm.com