patb@tcom.stc.co.uk (Patrick Brosnan) (01/26/91)
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. Pat -- Patrick Brosnan. <patb@tcom.stc.co.uk> || ...!mcsun!ukc!stc!patb STC Telecommunications, Oakleigh Rd South, London N11 1HB. Phone : +44 81 945 2135 or +44 81 945 4000 x2135 "Very witty and original statement" - Me
jklein@.com (Jonathan Klein) (01/28/91)
Oracle version 6 has no such limitation. A transaction may lock as many rows as needed when running with the transaction processing option. Jonathan Klein RDBMS R&D
tim@ohday.sybase.com (Tim Wood) (02/11/91)
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. Sybase's smallest unit of locking is the database page (usually 2K in size, some platforms have 4K or more.) We estimate how many pages a transaction needs to lock. If that is a "large" estimate, or the estimate is too low and is exceeded at runtime, we then escalate the lock to table-level, and release the page locks. It is in principle possible to run out of locks in Sybase, but I don't think it happens very often because of this algorithm and because the number of locks available in the server is DBA-configurable. HTH, -TW Sybase, Inc. / 6475 Christie Ave. / Emeryville, CA / 94608 415-596-3500 WORK:tim@sybase.com {pacbell,pyramid,sun,{uunet,ucbvax}!mtxinu}!sybase!tim PLAY:axolotl!tim@toad.com {sun,uunet}!hoptoad!axolotl!tim Dis claim er dat claim, what's da difference? I'm da one doin da talkin' hea.