TweetShareSharePin0 SharesJust a quick note that I have accepted to speak at the conference the Swedish Oracle User Group Orcan will hold May 11-13. The subject will be on rowid, ITL, and row migration where I hope to show it both from the block level view and a little showing it from the OWI view. THe general idea is to show more on what happens in the blocks and why and how the rowid a row first gets when it […]
I/O
Commit frequency and Undo
TweetShareSharePin0 SharesToo frequent commits can lead to performance problems, but can it also affect how much undo the updates generate? The fact that very frequent committing causes performance problems has been noticed by almost every Oracle developer with even just a couple of months experience with the Oracle database. However, if commit can increase I/O requests issued by the database, then this would also impact the performance of other processes. With Oracle, that can be done in many ways, but […]