Message-Id: <10571.113148@fatcity.com> From: "Thomas L. Harleman" Date: Thu, 27 Jul 2000 12:49:21 -0500 Subject: RE: Oracle and Record Locking I learned this from Pete Cassidy. Rollback segments give Oracle its strength in the 3 R's. Not readin', ritin', and rithmetic. Row level locking Read consistency and Rollback ability. Row level locking means that no one can update the row your updating until you're finished with it.Read consistency means that no one can see your updates until their committed to the database. Rollback ability means that you can change your mind without bothering anyone else's information. Perhaps your consultant is referring to his ability to wreak havoc on a database by using VB to update rows without ensuring that he has the most current information before executing a UPDATE TABLE SET INCONSISTENT_DATA = NEW_DATA; Tom Harleman 11080 Willowmere Dr. Indianapolis, IN 46280 317-844-2884 Home 317-843-9122 Home Office -----Original Message----- From: root@fatcity.com [mailto:root@fatcity.com]On Behalf Of Seth Dunehew Sent: Thursday, July 27, 2000 10:18 AM To: Multiple recipients of list ORACLE-L Subject: Oracle and Record Locking We have a consultant at our shop who is convinced that Oracle is inadequate for a serious multi-user environment because of the lack of record locking and dynamic result sets. We have been using it to develop and deploy a OLTP system and haven't found any serious problems that could not be addressed. The dynamic result set that he has mentioned has me a little puzzled. He is stating that relational databases that he has worked with in the past returned a result set to him for use in his apps that would change dynamically if another user changed one of the records that he was displaying. I'm a relative newcomer to the database arena, 2 years, but this is something new. I've been told by another developer that Access will do this, but he hadn't heard of any serious systems that do. Has anyone else heard of databases that perform that function? Any suggestions on resources related to record locking in Oracle? We have two other developers that have worked with it extensively in the past, but the consultant is convinced that he knows differently, so we do need some solid research to refute him. Thanks Seth Dunehew -- Author: Seth Dunehew INET: sdunehew@medicalmatrix.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).