Home » RDBMS Server » Performance Tuning » Locks
Locks [message #225610] Tue, 20 March 2007 08:55 Go to next message
Messages: 27
Registered: December 2006
Junior Member

We have just made numerous applications live. Users have been complaining of the screens 'hanging'. On investigation we have found numerous locks.

To overcome these locks, which would be a better option.
Include the NO WAIT option when updating a table in the form
OR change the locking mode on the block properties to 'Delayed'.

Would this overcome the locking problems. We are new to forms.


[Updated on: Tue, 20 March 2007 08:56]

Report message to a moderator

Re: Locks [message #225704 is a reply to message #225610] Wed, 21 March 2007 01:45 Go to previous messageGo to next message
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

Do you get any FRM or ORA errors ?

You have to options

If 'Locking Mode' is set to 'Immediate', the row is immediately locked upon modification. Locking occurs as soon as a key is pressed to enter or edit that value in the item. 'Immediate' is the default setting.


If 'Locking Mode' is set to 'Delayed', the row is not locked until
commit-time, specifically until changes are 'posted' to the database. Oracle Forms then compares the current value to the database value before issuing the UPDATE statement. The user will get an error if the row has been updated
since it was fetched.

Have a look at Docid 1004126.6 on metalink

[Updated on: Wed, 21 March 2007 01:46]

Report message to a moderator

Re: Locks [message #225943 is a reply to message #225704] Thu, 22 March 2007 01:09 Go to previous messageGo to next message
Messages: 27
Registered: December 2006
Junior Member
The screens just hang, no ORA or FRM errors.

Thanks, would go to metalink.

Re: Locks [message #233362 is a reply to message #225610] Wed, 25 April 2007 17:02 Go to previous message
Messages: 9
Registered: April 2007
Junior Member
Hello ora_dev,

I just want to pose some more questions which may lead you into the direction of a solution to your problem.

What I would like know, is:
Who is waiting on what? Did you try to trace the locking and / or locked sessions or query information about the sessions (from v$session_wait, v$session_event and v$system_event, v$open_cursor etc.)?
Did you try to google with search terms like "oracle session hang"?
Are there queries with a lot of union (all)'s ?
How do the application(s) connect to the database(s)(JDBC/OCI or TNS or else)?
Is dead session detection working correctly? Are there sessions which are suspisciously old and still open (except the background processes of course)? And do you know whether the client is still running or has logged off, has crashed or has been rebooted in the meantime? Then check our connection configuration. And do this "dead" sessions still own locks?
How do batch processes behave (if you have them)?
Are there a lot of long running operations?

More application oriented questions are:
Are we talking about client/server forms or web forms? Is the application closing its cursors efficiently when the forms call procedures?
Do the users open a lot of screens simultanously for example in query-mode and leave them inactive for a long time?
When does the application execute commits?
Hoe do users exit the application(s)? By switching of the client machines or with a decent logoff?

Hope this helps a little to pinpoint the problem area.

Previous Topic: Query execution time is fluctuating lot
Next Topic: Database Space Usage Measurements
Goto Forum:

Current Time: Sat Aug 19 19:32:27 CDT 2017

Total time taken to generate the page: 0.58426 seconds