Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> What's lock/unlock mechnism

What's lock/unlock mechnism

From: Helen rwulfjeq <lannyue_at_yahoo.com>
Date: Wed, 27 Jun 2001 14:08:35 -0700
Message-ID: <F001.0033AEE8.20010627140948@fatcity.com>


Hi ,
 
Oracle database system uses very complicated lock/unlock design for readlock,writelock and row/recordlock etc..... Does anyone know lock/unlock is implemented both client like sqlplus and server side or just on server side or just client side. For instance, one user using sqlplus access database to update one record of table XX. So should be sqlplus's responsibility to lock this record based on row level of XX table? or server is also involved in? Thanks. H.Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35 a year!http://personal.mail.yahoo.com/ Received on Wed Jun 27 2001 - 16:08:35 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US