OraFAQ Forum: Performance Tuning

Home » RDBMS Server » Performance Tuning » lock issue (oracle 10g , windows )

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

lock issue [message #429026]

Sun, 01 November 2009 04:31

RAY_HT
Messages: 155
Registered: May 2005
Location: Giza

Senior Member

Dear all ,

i'm facing big problem ..

when i'm executing calculation funtion of customer invoices , exclusive lock happening to customer account table .

if user try to update any record while this funtion running on deferent set of customer invoices , the system hange until the function execution complet.

i'm useing

LOCK TABLE bl_USAGE_TX IN ROW SHARE MODE;

but when i'm tracing this issue i get this information

Table lock (TM): NMISBL.BL_USAGE_TX - Mode held: Row-X (SX) / Mode requested: Share

Report message to a moderator

Re: lock issue [message #429032 is a reply to message #429026]

Sun, 01 November 2009 06:10

Michel Cadot
Messages: 68653
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Expected behaviour.
What is the question?

Regards
Michel

Report message to a moderator

Re: lock issue [message #429209 is a reply to message #429026]

Mon, 02 November 2009 09:45

JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...

Senior Member

A good question to start with might be 'Why are you manually locking the table in the first place?

Report message to a moderator

Re: lock issue [message #429797 is a reply to message #429026]

Thu, 05 November 2009 17:26

Kevin Meade
Messages: 2103
Registered: December 1999
Location: Connecticut USA

Senior Member

google and read about what LOCK TABLE IN ROW SHARE MODE means. Then your next post should include two pieces of info...

1) you should be able to tell us why the update waits.

2) you should tell us why you think you need to lock the table this way. What were you trying to achieve with the lock?

Kevin

Report message to a moderator

Previous Topic:	How to reduce CPU Utilization
Next Topic:	How to Query Large table .?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 18 05:13:26 CDT 2024