Skip to Main Content

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!

Database DeadLock Issue

3482Feb 19 2013 — edited Feb 21 2013
Dear Sir/Madam,
Our Vendor has developed application by .NET for import data into SQL Server 2005 Database (around 500 records/per times). But sometimes database has deadlock or timeout issue occur when users import data in office hour. So cause system seems hang and users can't use system. We need to stop this process then system can resume. Of course, I guess some users may edit importing record at the same time to cause error occur.

Import data procedure as below:
1) Copy data from Excel to Clipboard
2) Paste data into temp table thru .net client
3) Validate production table key fro m Temp table data When Press update
4) Update some columns data in production table.

As i knew that Oracle DB have UNDO tablespace & unlimitation Locking , SO, I would try to consider switch DB from SQL Server to Oracle .

Does Oracle Database have a better function to control this more than SQL Server?

Thanks a lot.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 21 2013
Added on Feb 19 2013
5 comments
988 views