The only advanced Oracle8 skills book on the market. Picks up teaching Oracle skills where Oracle8 DBA Handbook and Tuning Oracle leave off. Gives Oracle8 DBAs the advanced tools necessary to manage and tune their databases regardless of the rate of growth in the environment--a very important scalability skill. Revised to cover all new aspects of Oracle8, including: Partitioned tables, abstract datatypes, index-only tables, objects, and more. The CD-ROM includes code from the book, plus a new version of SQLab--a valuable application tool that help readers practice advanced optimisation techniques.
Sprache
Verlagsort
Verlagsgruppe
McGraw-Hill Education - Europe
Zielgruppe
Illustrationen
Maße
Höhe: 231 mm
Breite: 183 mm
Dicke: 43 mm
Gewicht
ISBN-13
978-0-07-882534-7 (9780078825347)
Copyright in bibliographic data and cover images is held by Nielsen Book Services Limited or by the publishers or by their respective licensors: all rights reserved.
Schweitzer Klassifikation
Kevin Loney (Wilmington, DE) is a veteran Oracle developer and DBA. He is the author of the best-selling Oracle8 DBA Handbook and co-author of Advanced Tuning and Administration and Oracle8i: The Complete Reference. He frequently makes presentations at Oracle conferences and contributes to Oracle Magazine
Part I: Managing Database Size, Performance, and Emergencies. Part II: Administration of a Growing Database. Planning for Your Database Growth. Memory and CPU Tuning Issues. Hardware Tuning Issues. Managing the Space Inside Your Database. Database Shutdown/Startup Kit. Part III: Tuning a Growing Database. Managing for Performance. Monitoring. Environment Tuning. EXPLAINing SQL Treatment Tuning. The Top 13 SQL Tuning Tips. Part IV: Advanced Tuning Options. Parallel Options. When All Else Fails: New and Improved Tuning Options. Part V: DBA Practice Questions. Oracle DBA Practice Questions. Analysis of the Practice Questions.