Re: TPC-A and -B Benchmarks

In article <21dk8rINNhjm@emory.mathcs.emory.edu>, mrichardso@shl.com writes: |> I believe cursor stability implies the maintenance of cursor positioning |> across commits and/or rollbacks. Note that in some cases this could violate |> ANSI standards. Oracle supports the ANSI mode and (I think) a more complete |> implementation of cursor stability. Note that I said "I believe" at the |> start of this paragraph and the relevant information is book knowledge, not |> practical experience. This is incorrect. Cursor stability causes a shared lock to be held on a row currently fetched from the active set in a transaction. When the next row is fetched, the lock is released and a new shared lock is placed on the newly fetched row. Cursor stability insures that the row currently being examined cannot be changed by another user while the first user is "looking at it". What you describe above is a WITH HOLD cursor, as implemented in Informix-OnLine. I don't know if Oracle supports that functionality or what they call it if they do. Dave Disclaimer: These opinions are not those of Informix Software, Inc. ************************************************************************** "I look back with some satisfaction on what an idiot I was when I was 25, but when I do that, I'm assuming I'm no longer an idiot." - Andy Rooney