From: "akolk - gelrevision.nl" Subject: Re: Oracle Commits Date: 2000/03/03 Message-ID: <38BFA5A0.528477C@gelrevision.nl>#1/1 Content-Transfer-Encoding: 7bit References: <89mf2v$53$1@nnrp1.deja.com> <89midm$32r$1@nnrp1.deja.com> X-Accept-Language: en, pt-BR, pt Content-Type: text/plain; charset=us-ascii X-Complaints-To: abuse@wirehub.net X-Trace: thor.wirehub.nl 952080667 78656 195.86.58.244 (3 Mar 2000 10:51:07 GMT) Organization: Wirehub! Internet Mime-Version: 1.0 NNTP-Posting-Date: 3 Mar 2000 10:51:07 GMT Newsgroups: comp.databases.oracle.server Not always true. You could be doing block cleanout ......... dgpare wrote: > This is in addition to Mark's advice, which is correct, but if you are just > running a "query" as your question states you don't have to worry about > commits as you are not altering/updating data, basically you are only > reading the data. > wrote in message news:89midm$32r$1@nnrp1.deja.com... > > In article <89mf2v$53$1@nnrp1.deja.com>, > > victre@my-deja.com wrote: > > > How long does it take Oracle 8.0.5 to execute a commit? I want to > > > avoid running out of resources required to run a large query by using > > > commits every n records but also want to minimizing the execution time > > > of the query by not doing more commits than necessary. > > > > > Oracle 8 uses the same fast commit logic it used with ver 7, namely, on > > a commit Oracle flushes the redo log buffer to disk, but allows the > > database writer to get around to writing the changed data whenever it > > gets around to it (lazy writes). Because a commit requires writing to > > the redo log it is relatively expensive so you are correct in that you > > do not want to over commit, but I think you want to base your commit > > frequency based on the likelihood that another session will want to > > update one of the rows your process updated and how long it is > > acceptable for them to wait. That and the total number of bytes worth > > of rollback you want to limit a transaction to using. > > > > -- > > Mark D. Powell -- The only advice that counts is the advice that > > you follow so follow your own advice -- > > > > > > Sent via Deja.com http://www.deja.com/ > > Before you buy.