Re: Disabling rollback. Is it possible?

From: Michel Lapierre <milapier_at_ge.hydro.qc.hq>
Date: 1995/08/02
Message-ID: <DCov06.CD9_at_ireq.hydro.qc.ca>#1/1


The only reason to use a database in read only it's when you have only query to do and no insert, update or delete.

The rollback segment is use when a transaction use insert, update or delete. If you are not using those statements you should not have problems with rollbacks. People have problems with rollbacks because the do not know how to manage that object. I suggest you to read about How to manage rollback segment.

The problem you have with rollback it's usaly design problem or it's can be one shot problem like loading a lot of info in the database. To avoid that problem try to commit often (autocommit) but that option will increase the time of the request. Received on Wed Aug 02 1995 - 00:00:00 CEST

Original text of this message