Home » RDBMS Server » Performance Tuning » NOWAIT lock requests could hang (like Parallel Queries may hang "enq: TS - contention") ( database enterprize edition 11.2.0.3 solaris 10)
NOWAIT lock requests could hang (like Parallel Queries may hang "enq: TS - contention") [message #594477] Thu, 29 August 2013 00:56 Go to next message
mshrkshl
Messages: 247
Registered: September 2006
Location: New Delhi
Senior Member
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

Re: NOWAIT lock requests could hang (like Parallel Queries may hang "enq: TS - contention") [message #594497 is a reply to message #594477] Thu, 29 August 2013 03:46 Go to previous messageGo to next message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
have you traced the sessions to see what they're waiting on?
Re: NOWAIT lock requests could hang (like Parallel Queries may hang "enq: TS - contention") [message #594506 is a reply to message #594497] Thu, 29 August 2013 04:38 Go to previous message
mshrkshl
Messages: 247
Registered: September 2006
Location: New Delhi
Senior Member
PFA entry in v$lock , process is getting hang.

Previous Topic: Please guide to improve the performance of query
Next Topic: Impact of RAM to oracle
Goto Forum:
  


Current Time: Thu Mar 28 07:38:54 CDT 2024