Ravi Pavan wrote:
What changes and where to do the changes to be made to have my database support Optimistic Locking .
We can only suggest oracle to lock a record, we can't enforce it.
What steps are needed?
In one transaction,
You have to reserve the record by using select .... from <yourtable> where <condition on a field with a unique index - preferably on the primary key>
FOR UPDATE ;
The FOR UPDATE clause will reserve the record for you. However, Oracle may decide to apply a page or table lock.
But when you use the primary key as where clause, it will tipically apply a row lock.
You have now pessimistically locked, and the mlock will disappear when you end your transaction by committing or rollbacking.
More can be found by googling for Oracle locking strategy.
Is my question so foolish ??
Come on, you have had several replies on the same day as you posted the question. That is better than the response time of some Platinum service level agreements.