What are the problems associated with doing frequent commits to the
database.

I have a package that may have to commit every sec (for about 4000
records).

If I don't do this I get ORA-2049 time out waiting for lock error.

Thanks,
Anbu

Oracle LazyDBA home page