Author: Mathias

Commit, I/O, Oracle, Undo

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 […]

Blogging

Introduction

TweetShareSharePin0 SharesIt’s time to start a blog and write down some ideas, findings, and general commentary about development with the Oracle database. This blog will be a place where I write about things related to Oracle development and performance that interests me. I have been a DBA for longer than I really want to admit as that leads to the conclusion that I’m a middle aged man today. When I started in this industry, I used to feel that the […]