May any one confirm that the below issue is not only to RAC but also on normal database enterprize edition 18.104.22.168 ?
Bug 12865902 - NOWAIT lock requests could hang (like Parallel Queries may hang "enq: TS - contention") in RAC (Doc ID 12865902.8)
currently i am using for update nowait concurrently for 50 processes on similar table with similar query and getting performance issue.
FROM cp_txn_detail WHERE txn_ID = pi_txn_ID FOR UPDATE NOWAIT;
If nowait has realy performance issue , please provide some other suitable option.
[Edit MC: disable smilies, add code tags and remove useless empty lines]
[Updated on: Thu, 29 August 2013 01:03] by Moderator
Report message to a moderator