Oracle Database Discussions

Hi,

I have an issue where single insert statements are causing blocking issues. I am using Oracle10gR2 on a windows Server 2003 x64 platform. The issue relates to one table in particular. The table contains four fields and updated every few minutes. Another table within the same database (but in a different schema) copes efficiently with the insertion of upto 500,000 records at the time. The Enterprise Manager shows the wait event as 'TX - row lock contention'. This implies that the problem lies within the application, either lack of commits/rollback or the way in which the application is submitting the transactions. I have looked at this and can see nothing wrong. To confuse myself further the same application is set up on another application server and database, in this case there are no problems when the same data is fed in. I have compared the two table in each database but the are identical. Can any-one suggest whart my problem is?

Regard
Paul