Oracle8I Tuning and Administration: The Essential Reference - Brossura

Thorpe, Heidi

Brossura

ISBN 10: 0201704366 ISBN 13: 9780201704365

Casa editrice: Addison-Wesley, 2001

Riassunto

A guide for both less-experienced and advanced database administrators, covering major areas of Oracle8i for which database administrators are typically responsible, such as sizing and reconfiguration, monitoring, and application and database tuning for better performance. Reviews fundamental Oracle concepts, summarizes the latest features of Oracle8i, and covers aspects including security, free space search algorithms, SQL statement tuning, online index creation, and statistics generation for long-running operations. Thorpe works for a major financial institution in Australia. Annotation c. Book News, Inc., Portland, OR (booknews.com)

Su questo libro

L'autore

Heidi Thorpe is a Senior DBA with a major financial institution in Melbourne, Australia. She has fifteen years of industry database experience with major international companies, and is a highly respected practitioner of database technologies.

0201704366AB04062001

Dalla quarta di copertina

Poring over the 30 volumes of official Oracle documentation is a daunting task for any Oracle database administrator (DBA). Oracle8iTM Tuning and Administration: The Essential Reference distills the essentials of what you need to know to perform your job intelligently and skillfully. Bypassing obscure technical details, this book answers three essential questions for each topic listed below: What is it? Why is it important? How do I use it? Less experienced DBAs can now acquire the framework they need to understand important details in the Oracle documentation. Advanced DBAs will find this book a practical reference to effective configuration and troubleshooting. Oracle8iTM Tuning and Administration covers the major areas for which DBAs are typically responsible: administration, sizing and configuration, monitoring, and application and database tuning for better performance. In addition, the book reviews fundamental Oracle concepts and summarizes the newest features of Oracle8iTM. Specific topics covered include:

• Security and auditing
• Administering tables, views, constraints, indexes, data files, log
• files, and more
• Free space search algorithm
• Using database blocks efficiently
• Optimizing space management
• Partitioning
• Database, process, and object limits
• Monitoring events, usage, waits, and log files
• Query optimization hints
• SQL statement tuning
• Diagnosing performance problems and detecting runaway processes
• Tuning the operating system, CPU, memory, and disk I/O
• Tuning Private SQL and PL/SQL areas
• Tuning and initialization parameters
• New features for bitmapped indexes
• The new SAMPLE function
• Advanced queuing and sort improvements
• Online index creation, rebuild, and defragmentation
• Statistics generation for long-running operations

Concise and thorough, with an easy-access format, Oracle8iTM Tuning and Administration: The Essential Reference is the Oracle resource you will keep close at hand.

Dettagli dell?edizione

• Editore: Addison-Wesley
• Data di pubblicazione: 2001
• Lingua: Inglese
• ISBN 10: 0201704366
• ISBN 13: 9780201704365
• Rilegatura: Copertina flessibile
• Numero di pagine: 590
• Contatto del produttore: non disponibile
• Persona responsabile: GS1 Slovakia; https://www.gs1sk.org; ; Nantersk� 23; Žilina; 010 08; Repubblica Slovacca