Optimizing an Oracle Database on the Database and Application Level

Database management systems are an integral part of ICT infrastructure in contemporary companies. Their performance is imperative for the company to be competitive. Thus, knowing how todevelop efficient database applications and to be able to measure their performance and optimise them is a crucial asset for any application developer. In this book a special emphasis is put on Oracle as it is a widely used database management system with agood array of optimisation techniques and tools. This book examines database optimisation first on a theoretical level and then the optimisation and performance measurement techniques are tested in practice in a laboratory experiment. In this constructive part an Oracle PL/SQL procedure is optimised by using bulk processing techniques, applying better transaction handling and using dynamicSQL.