Dear all,
May any one confirm that the below issue is not only to RAC but also on normal database enterprize edition 11.2.0.3 ?
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.
SELECT txn_ID,status_FLAG
INTO txn_id,status_flag
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.
Regards,
[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
] 
Blog
Search
Help
Members
Register
Login
Home
