Delete/Insert and high number of concurrent users

Hi,
Oracle version : 9.2

A transaction, in addition to other statements, involves first deleting all records belonging to that userid and then insert fresh set from another table.
The database must be able to support large number of users, each with own userid, performing this transaction.

I believe this is not a good design but have no control on this part.

To ensure that these delete statements do not result in any bottlenecks, what should be the focus areas.

Thanks and regards,
Gautrak Received on Sun Sep 19 2004 - 11:25:16 CDT