I have read on one book following paragraphs.
Redo log buffer may be flushed before commit, the size
of transaction does not affect the amount of time needed for an actual commit operation.
can any body ple. explain above statement in details
Not really that well I can't, but it's saying that.
No matter how big an insert or an update, once the changes have been written to that database.
A commit will take the same amount of time whether you updated 1 row or 1,000,000 rows.
The statement itself will take longer but the commit will take the same amount of time.
The redo log buffer contains entries to be written to redo log files.
When the buffer fills it writes it's info to the log file. You can force this to happen by flushing the buffer.
This again will not affect the time it takes to commit the change.
Hope that helps.
Click Here to Expand Forum to Full Width