| Buffered Commit [message #171119] |
Mon, 08 May 2006 08:50  |
theo06
Messages: 29
Registered: February 2006
|
Junior Member |
|
|
Hi,
I read in a book about the [un]buffered commit strategy. By now I am searching the Oracle documentation for that keyword. Unfortunately I can't find anything. For IBM DB2 I found that it is called buffered inserts. But for that and similiar keywords I can't find anything too.
Could you please be me a help?!
Thank you in advance!
Theo
|
|
|
|
|
|
| Re: Buffered Commit [message #171125 is a reply to message #171124] |
Mon, 08 May 2006 09:18  |
theo06
Messages: 29
Registered: February 2006
|
Junior Member |
|
|
I read about the topic in "Database Tuning : A Principled Approach" from Dennis E. Shasha on page 34:
"Unbuffered commit strategy: write the after images into the database after committing.
Buffered commit strategy: Keep each after image x in random access memory until it is "convenient" to write it. Normally, this means waiting until the database disk heads are over the cylinder containing x."
As far as I unterstand the buffered commit strategy is a little faster because a write access to disk is performed with a bundle of finished Statements. The drawback is that when there is a failure e.g. during an insert, the error message displays on a point which has not anything to do with that error message.
[Updated on: Mon, 08 May 2006 09:18] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
