No label defined (Q4234032)

Tuning of databases is a special domain, requiring an experienced database administrator. That is as more the case as the database management system is a complex product; Oracle 8 is. The authors of this book are experienced as leading administrators and Oracle management system developers. The know Oracle management functionality since years, especially applied to very large databases. The book is a compendium of their experience. It is written for Oracle8 mainly, but the Oracle7 administrator will also find enough information, worth to read the book. The logical structuring of the book, and the clear, to the point explainations, complemented by a lot of examples and illustrations, will help the unexperienced administrator to do a good job. Listings and clear hints in form of rules will help to avoid mistakes from the beginning. The detail level will help the experienced administrator to find the one or another information to become yet more efficient. The book is recommended to Oracle8 and Oracle7 database administrators. It is obligate for database administrators of very large databases. Application developers will profite from, too. Also the beginner will understand it, due to its step-by-step methodology, starting with installation. Naturally, the reader has to know what a relational database and a database management system is. Bigger parts of the book are dedicated to Oracle8 on Windows NT. The edition of the Hanser Verlag is a translation in German. It is a translation from the official, Oracle authorizided book (Oracle Press serie) with the same title, published 1998, Mc Graw Hill. The content is structured thema-oriented. There is no special reference list, just the general index. The specialities of Oracle7 are listed at the end of each chapter. The section before it is also repeated within each chapter, called: Let's tune it. It summarizes the hints for tuning, given through the chapter. The content is as follows: Part 1: Installation; a.o. hard- and software requirements, national language support, authorization, dimensioning the common pool, installation-log, file structure, create a database, initialize parameters, tests on comprehensiveness; Part 2: Main memory/CPU; a.o. Window NT system monitor, background processes, trace and instance alert files, paging and swapping, main memory sizing, caches, multithreaded server, parallelization, usage CPU, session control; This chapter is mainly directed to Windows NT; Part 3: The I/O; a.o. performance views (system owned), processing queueing, tables and index (definition, splitting, dimensioning etc), stripping, rollback segments, temporary segments, redo-logs, disk-controller, hot spots, occupied main memory, re-use of unoccupied main memory; Part 4: Partitioning; a.o. partitioning and tuning process, partioning types, partitioning of tables, partitioned indices, operations with partined objects; Part 5: Parallelity; a.o. parallel queries, parallel processing, parallel SQL statements (reasons for parallelization, degree of parallelization), creation of a table (impact of physical design Oracle8), parallel indexing, parallel load, limitations of parallel operations; Part 6: Further questions with respect to the database; a.o. the initialization parameter file, performance statistics, how to do it, how to interprete it, safe of storage space, relations with redo-logs; Part 7: Show Stopper; a.o. database and system limitations (number of maximal open files, initialize file of the operating system etc.), Oracle specific limitations, free list bottleneck, archive log, locks, ANSI C compiler, truncate-problems; Part 8: Application tuning; a.o. Oracle Enterprise Manager, common pool, generic codes, cost based optimizer, explain plan, autotrace, sql trace, colum indices, looks; Chapter 9: Performance pack; a.o. components of the performance pack, relations with the tuning process, user defined diagrams, advises; Chapter 10: Comprehensive approach; a.o. Oracle Connection Manager, transaction and rollback segments, session control, integrity checks, standby-database, tuning of database backups, tuning and recovery, dba ptfalls, datum mask 2000, efficient resource management, cluster, PL/SQL file I/O; Chapter 11: Skripts and tips; a.o. archive log modus, backup cycles, space administration, user informations, access to admistration/system views, SQL code generation, new generation of a stored object, shutdown. Appendix: Appendix A: example table definitions, Appendix B: Object management, Appendix C: Create a second database in Windows NT.