OraFAQ Forum: Performance Tuning » NOWAIT lock requests could hang (like Parallel Queries may hang "enq: TS

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)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

NOWAIT lock requests could hang (like Parallel Queries may hang "enq: TS - contention") [message #594477]

Thu, 29 August 2013 00:56

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.

Code: [Select all] [Show/ hide]

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

cookiemonster
Messages: 13966
Registered: September 2008
Location: Rainy Manchester

Senior Member

have you traced the sessions to see what they're waiting on?

Report message to a moderator

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

mshrkshl
Messages: 247
Registered: September 2006
Location: New Delhi

Senior Member

PFA entry in v$lock , process is getting hang.

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 29 00:09:53 CDT 2025