This book is an anthology of effective database management techniques representing the collective wisdom of the Oak Table Network. With an emphasis upon performance—but also branching into security, national language, and other issues—the book helps you deliver the most value for your company’s investment in Oracle Database technologies. You’ll learn to effectively plan for and monitor performance, to troubleshoot systematically when things go wrong, and to manage your database rather than letting it manage you.
Table des matières
Battle Against Any Guess.- A Partly Cloudy Future.- Developing a Performance Methodology.- The DBA as Designer.- Running Oracle on Windows.- Managing SQL Performance.- PL/SQL and the CBO.- Understanding Performance Optimization Methods.- Choosing a Performance Optimization Method.- Managing the Very Large Database.- Statistics.- Troubleshooting Latch Contention.- Measuring for Robust Performance.- User Security.- Securing Data.
A propos de l’auteur
Pete Finnigan works as an independent Oracle security consultant for his own company Pete Finnigan.com Limited. Pete specializes in performing detailed Oracle security Health checks against Oracle databases using a detailed methodology developed by Pete from many years of experience in securing databases. Pete performs this service for many clients worldwide, but also offers other specialist consulting services in many areas related to Oracle security. Pete’s company Pete Finnigan.com Limited also develops and delivers a number of Oracle security training courses that are well-regarded and comprehensive.