Frequent commits may force redo buffers to be more aggressively written
to log files and that may result in more data buffers to be written to
data files. so you may get into a situation where you are putting
pressure on log writer and DBWR.


-----Original Message-----
From: Anbarasu Chinnaswamy
[mailto:oracledba-ezmlmshield-x76976693.[Email address protected]
Sent: 03 December 2004 01:21
To: LazyDBA Discussion
Subject: Frequent commits to database

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


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html



DISCLAIMER: The information in this message is confidential and may be legally privileged. It is intended solely for the addressee/recipient. Access to this message by any one else is unauthorized. If you are not the intended addressee/recipient any disclosure, copying or distribution of the message, or any action or omission taken by you by relying on it is prohibited and may be unlawful. Please notify the addressor/sender immediately if you have received this message in error. The organization is not responsible for any damage caused by a virus or an alteration of the e-mail by a third party or otherwise. The contents of this message may not necessarily represent the views or the policies of the organization.


Oracle LazyDBA home page