Database DeadLock Issue
3482Feb 19 2013 — edited Feb 21 2013Dear 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.