Optimizing An Oracle Database On The Database And Application Level - An Application Developer's Perspective

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 to develop 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 a good 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 dynamic SQL.