Delete records problem-Weblogic timeout

Hi,
I have a delete problem in my java application. In my application at one place it have to delete multiple rows from a table which has 5 child tables.
The format of the DELETE statement is as follows:
DELETE FROM RESOURCE WHERE RESOURCE_ID IN (list_of_resourceIds).

The list of list_of_resourceIds size is 200 in number. We are using JDBC to do this. The records in the related child tables are deleting.
But, its taking more time(more than 3 minutes) which is longer than our weblogic time out. So the server is timing out.
Sometimes it’s taking up to 8 minutes also.

also we are have checked that Validation of referential constraints in child table is not causing problem from our DBA TEAM

The interesting thing to note here is the same group delete works very fast(normal behavior) most of the times.
Only sometimes it’s taking more time and hence my weblogic is timing out.

I looked into the code but couldn’t found any problem there. Because most of the times it’s finishing less than a minute.

Please suggest me a solution for this problem

Amit,
Are you able to reproduce when it takes longer? Ideas are:

contention on the database

a transaction having a lock on the row you want to delete

a significantly larger number of child records to delete