RE: Oracle and Record Locking

> Jared, is this pedantic? If so, will I be punished?

Yes, and if you ever show up at the same conference as some of us, we'll make you drink an extra beer. :)

Jared

On Thu, 27 Jul 2000, Shockey, David wrote:

> Database theorist call this concurrency control and Oracle's means is shared
> locking, meaning that only one transaction can have the data items selected
> for update (edit/delete) but other transactions can read the data items.
> Further, Oracle does not allow uncommitted changes to be read so the readers
> will see the data items in the same state that the updater begins with.
>
> In theory interleaving transactions would be most efficient but there are
> many possible data integrity problems with interleaving.
>
> Jared, is this pedantic? If so, will I be punished?
>
>
> -----Original Message-----
> Sent: Thursday, July 27, 2000 1:06 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Seth Dunehew
>
> To my knowledge, FoxPro family of products also do that i.e., records
> fetched from the tables into a cursor have no relationship with the table.
> If same record is accessed by two different users, both have rights to
> update, the effective changes will be of the one who saves later.
>
> In oracle, the moment a user initiates editing a record fetched into a form
> (developer 2000), it is marked as locked (automatically -for third party
> front-end / back-end this needs manual locking). The locks are automatically
> released, when the records are committed. I am talking about forms 4.5 and
> Oracle 8. Don't have any idea about earlier versions.
>
> HTH!
>
> Aleem
>
> -----Original Message-----
> Sent: 27 July 2000 20:18
> 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_at_medicalmatrix.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
>
> --
> Author: Abdul Aleem
> INET: abchaudhary-ho_at_beaconhouse.edu.pk
>
> 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_at_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).
>

Jared Still
Certified Oracle DBA and Part Time Perl Evangelist ;-) Regence BlueCross BlueShield of Oregon Received on Thu Jul 27 2000 - 19:40:02 CDT