Members   Search   Help    Register    Login   Home
Home » RDBMS Server » Performance Tuning » lock issue (oracle 10g , windows )
lock issue [message #429026] Sun, 01 November 2009 04:31 Go to next message
RAY_HT
Messages: 134
Registered: May 2005
Location: CAIRO
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 Go to previous messageGo to next message
Michel Cadot
Messages: 29419
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
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 Go to previous messageGo to next message
JRowbottom
Messages: 5362
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 Go to previous message
Kevin Meade
Messages: 1050
Registered: December 1999
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Nov 30 17:52:48 CST 2009

Total time taken to generate the page: 0.40154 seconds
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.