Home » RDBMS Server » Performance Tuning » lock issue (oracle 10g , windows )
lock issue [message #429026] Sun, 01 November 2009 04:31 Go to next message
Messages: 153
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


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
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: 65090
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Expected behaviour.
What is the question?

Re: lock issue [message #429209 is a reply to message #429026] Mon, 02 November 2009 09:45 Go to previous messageGo to next message
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?
Re: lock issue [message #429797 is a reply to message #429026] Thu, 05 November 2009 17:26 Go to previous message
Kevin Meade
Messages: 2102
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?


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

Current Time: Fri Jul 28 00:10:33 CDT 2017

Total time taken to generate the page: 0.09917 seconds