Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Table Locking in Exclusive mode

The_RockMar 10 2010 — edited Mar 10 2010
Dear All,

The Finance users in my company have to execute Day ending procedures at the same time. We have about 10 different users hitting the same tables in the database via the day end procedures.

We have one table EQUITY_TRADE that is kept in EXCLUSIVE lock mode when one user is executing the day end. The other users have to wait until the one user is done and then another one gathers the same lock and others have to wait and so on.

The SQL that I get in the Blocking Sessions of OEM is "LOCK TABLE EQUITY_TRADE IN EXCLUSIVE MODE". Therefore it exclusively locks that table for one user while the others have to wait.

We have the one schema in which all the application users are accessing the tables.

Please advice as to how I can modify the locking mechanism of the table so that the table isnt locked for one user and all can smoothly execute their day end procedures with being blocked out.

Regards,
Rakesh Soni.
http://rakeshocp.blogspot.com/
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 7 2010
Added on Mar 10 2010
#general-database-discussions
4 comments
1,245 views