Recommendations For Select for Update Statments

From: walid kaakati <"walid>
Date: Tue, 12 Apr 2016 11:31:50 +0000
Message-ID: <825221632.2401080.1460460709991.JavaMail.yahoo_at_mail.yahoo.com>



 Hallo List,

I working on an application that generates SQL Statements with SELECT FOR UPDATE clause, these Statements cause a lock on the select rows and hence blocking other sessions,sometimes the lock stay for half an hour according to the selected data. From analzying the Locks ,i found the locking due to Logical Errors in the development of the applciation . My question from PL-SQL viewpoint is their an alternative for this mechanisem that requires a lock on the Selected rows for Update ? any recommedation to minimize this Locking ?my (Database is   10g ).

Best Wishes, 

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Apr 12 2016 - 13:31:50 CEST

Original text of this message