Path: utzoo!utgpu!news-server.csri.toronto.edu!bonnie.concordia.ca!uunet!wuarchive!sdd.hp.com!hplabs!well!anderson
From: anderson@well.sf.ca.us (David E. Anderson)
Newsgroups: comp.databases
Subject: Re: Limitation on Transaction Size
Summary: Oracle V6 with Transaction Processing Option locks rows
Keywords: dbms locking
Message-ID: <23189@well.sf.ca.us>
Date: 16 Feb 91 08:47:17 GMT
References: <1991Jan25.171213.26493@tcom.stc.co.uk> <12287@sybase.sybase.com>
Followup-To: comp.databases
Organization: Whole Earth 'Lectronic Link, Sausalito, CA
Lines: 17

>In article <1991Jan25.171213.26493@tcom.stc.co.uk> patb@tcom.stc.co.uk (Patrick Brosnan) writes:
>>There is a limitation with standard Informix (version 4) on Sun-4 workstations;
>>the maximum number of rows that may be locked in a table within a transaction
>>is 64. (Informix-Online does not have this problem.) Does anybody out there in
>>the Void know if Ingress, Sybase and Oracle have similar limitations on Sun-4s.


... and does not have such a limit.

David E. Anderson, Redwood City, CA (415) 592-1101 anderson@well.sf.ca.us 
"First learn your horn and all the theory.  Next develop a style. Then forget
all that and just play". Charlie Parker [?]
-- 
David E. Anderson, Redwood City, CA (415) 592-1101 anderson@well.sf.ca.us 
Independent Database Consultant (formerly with Oracle kernel Support Group)
"First learn your horn and all the theory.  Next develop a style. Then forget
all that and just play". Charlie Parker [?]