ISBN 0-9744486-2-1 ISBN 13 978-0974448626 Library of Congress Number:2005901261 980 pages: Hardcover - 9x7 Shelving: Database/Oracle Oracle in-Focus Series # 24

Oracle Tuning The Definitive Reference Donald K. Burleson Retail Price $59.95 / £37.95 Order now for 30% off and get online access to the code depot! Only $41.95 (30% off) Key Features About the Authors Table of Contents Index Reader Comments Errata Oracle has become the most flexible and robust database ever created and Oracle tuning has become increasingly complex as the result of this massive power. This book provides a complete step-by-step approach for holistic Oracle tuning and it is the accumulated knowledge from tuning thousands of Oracle databases.

Incorporating the principles of artificial intelligence, Oracle has developed a sophisticated mechanism for capturing and tracking database performance over time periods. This new complexity has introduced dozens of new v$ and DBA views, plus dozens of Automatic Workload Repository (AWR) tables. The AWR and its interaction with the Automatic Database Diagnostic Monitor (ADDM) is a revolution in database tuning. By understanding the internal workings of the AWR tables, the senior DBA can develop time-series tuning models to predict upcoming outages and dynamically change the instance to accommodate the impending resource changes. This is not a book for beginners. Targeted at the senior Oracle DBA, this book dives deep into the internals of the v$ views, the AWR table structures and the new DBA history views. Packed with ready-to-run scripts, you can quickly monitor and identify the most challenging performance issues.

* See how Oracle captures time-series performance data. * Learn techniques for visualizing performance signatures over time. * Use the online code depot to quickly find performance bottlenecks. * Use historical data to predict impending performance problems. * Understand how to interpret complex Oracle tuning metrics. * Create customized performance alerts using AWR information. * See how AWR allows intelligent Oracle performance optimization. * Learn why the Oracle wait interface and 10046 dumps may become obsolete. * Understand proactive time-series Oracle tuning techniques.

About the Author:

Donald Burleson

Donald K. Burleson is one of the world’s top Oracle Database experts with more than 20 years of full-time DBA experience. He specializes in creating database architectures for very large online databases and he has worked with some of the world’s most powerful and complex systems. A former Adjunct Professor, Don Burleson has written 30 books, published more than 100 articles in National Magazines, and serves as Editor-in-Chief of Rampant TechPress. Don is a popular lecturer and teacher and is a frequent speaker at Oracle Openworld and other international database conferences.

Chapter 1: Introduction to Oracle Tuning Oracle Tuning Reactive Oracle Tuning Proactive Oracle Tuning Inside AWR Poor Design and Poor System Performance The Proactive Oracle Tuning Hierarchy External Hardware Performance Review Finding Database Bottlenecks Disk Constrained Database CPU Constrained Database Network Constrained Database Using Hardware to Correct a Sub-Optimal Oracle Database Oracle Instance Tuning Dynamic Instance Parameters Static Instance Parameters Statistics for the Oracle SQL Optimizer Oracle Object Tuning Oracle SQL Tuning Emergency Oracle Tuning Support Fix Missing CBO Statistics Repair CBO Statistics Set Missing Initialization Parameters Adding Missing Indexes Change CBO Parameters Employ cursor_sharing=force Implement the KEEP Pool Employ Materialized Views Implement Bitmap Indexes Adding Freelists Summary of Silver Bullet Tuning Techniques Conclusion Chapter 2: Time-Series Oracle Tuning Introduction to Time Series Analysis Time-Series Tuning Guidelines Measuring Behavior over Short Periods Rules for adjusting shared_pool_size Sizing the Shared Pool with the New Advisory Utility Rules for adjusting pga_aggregate_target Rules for Adjusting the Data Buffer Sizes Scheduling an SGA Reconfiguration Trend-based Oracle Reconfiguration When to Trigger a Dynamic Reconfiguration Approaches to Self-tuning Oracle Databases Tuning a constantly changing database Can Oracle possess psychic abilities? Capturing time-series metrics AWR Licensing Options Tracking Oracle Option Usage Customized AWR Tuning Reports Exception Reporting with OEM Exception Reporting with the AWR Exception reporting with dba_hist_filestatxs Trend identification with the AWR Correlation analysis reports with the AWR and ASH views Conclusion References Chapter 3: Oracle10g Automated Workload Structures The Many Faces of Oracle10g The AWR data collection mechanism Customizing AWR Scripts for Proactive Tuning The Mysterious AWR Performance Tables AWR vs. STATSPACK Inside the AWR Tables The Oracle10g Wait Event Tables A Kick in the ASH Inside the dba_hist Views Conclusion Chapter 4: Investigating the dba_hist Views Know the History Access Paths to AWR data Inside the dba_hist Data Dictionary Views Database Wait Events in the dba_hist Views dba_hist_system_event dba_hist_event_name dba_hist_bg_event_summary dba_hist_waitstat dba_hist_enqueue_stat Metric dba_hist Views dba_hist_filemetric_history dba_hist_sessmetric_history dba_hist_sysmetric_history dba_hist_sysmetric_summary dba_hist_waitclassmet_history Time Model Statistics dba_hist Views dba_hist_sys_time_model System statistics dba_hist_sysstat dba_hist_latch dba_hist_latch_misses_summary dba_hist_librarycache dba_hist_rowcache_summary dba_hist_buffer_pool_stat Operating System Statistics in AWR SQL Statistics The dba_hist_sqlstat View Segment Statistics Datafile I/O Statistics Conclusion References Chapter 5: AWR vs. STATSPACK Why Such a Difference? Files Delivered with STATSPACK STATSPACK and AWR Statistics Comparison Statistic Management in AWR and STATSPACK The snap_level Parameter session_id num_sql STATSPACK Collection Thresholds Conclusion Chapter 6: Inside Oracle10g v$ Views The Secret World of the v$ Views Changes in Wait Event v$ Views New Active Session History v$ View New Time Model v$ Views New Database Metric v$ Views Changes to SQL Related v$ Views Tips for v$data buffer contents Conclusion Chapter 7: Understanding the Oracle 10g Metrics Inside Oracle10g Metrics The v$metric Tables Database Workload Metrics Database Wait Metrics Datafile Metrics Database Service Metrics Conclusion Chapter 8: Oracle10g DBMS Tuning Packages Packaging Oracle10g Tuning The dbms_workload_repository Package Creating an AWR Report The dbms_advisor Package The ADDM Advisor Working with the SQLAccess Advisor Using the quick_tune option Inside the dbms_sqltune Package Conclusion Chapter 9: The AWR Time Model Approach Time Model Tuning for Oracle Finding the Cause of Buffer Busy Waits Conclusion Chapter 10: Reading an AWR or STATSPACK Report Listening to the Database Generating the AWR Report Reading the AWR Report Report Summary Cache Sizes Load Profile Instance Efficiency Percentage Top 5 Timed Events Section Wait Events Time Model Statistics Operating System Statistics Service Statistics Top SQL Instance Activity Section I/O Reports Section Advisory Section Buffer Pool Advisory Buffer Wait Statistics Section Enqueue Activity Section Undo Segment Summary Section Undo Segment Stats Section Latch Statistics Section Segment Statistics Section Dictionary Cache Stats Section Library Cache Activity Section SGA Memory Summary Section init.ora Parameters Section Conclusion Chapter 11: Predictive Models with AWR Predicting the Future with AWR Exception Reporting with the AWR Exception reporting with dba_hist_filestatxs General trend identification with the AWR Correlation analysis with AWR and ASH Conclusion Chapter 12: Server & Network Tuning with AWR Oracle Server Tuning Outside the Oracle Instance Oracle Server Bottlenecks Disk I/O and Oracle Moore’s Law Server RAM and Oracle Tracking External Server Metrics with AWR Oracle and the 64-bit server technology The New Age of Oracle Server Consolidation Enterprise Manager for Server & Environment Server Metrics and SQL Execution CPU Based Optimizer Costing I/O Costing Network Tuning The tcp.nodelay parameter The automatic_ipc parameter The SDU and TDU parameters Conclusion Chapter 13: Disk Tuning with Oracle Monitoring Disk Performance Inside Oracle Disk Architecture Disk Architectures of the 21st Century RAID Technology Oracle and Direct I/O Checking the Server Direct I/O Option Enabling Direct I/O with Kernel Parameters Direct I/O for Windows Direct I/O for IBM AIX Direct I/O for Linux Direct I/O for Sun Solaris Direct I/O for Veritas Oracle Blocksize and Disk I/O Oracle Blocksize & Index I/O Not all Indexes are used in Range Scans Using Oracle Multiple Blocksizes Improving SQL execution plans Real World Applications of multiple blocksizes Reducing disk I/O with SSD Oracle Disk Monitoring Examining Real-time Disk Statistics Examining Global I/O Locating Hot I/O Objects Tracking I/O for specific Tables Find the Current I/O Session Bandits Measuring Disk I/O Speed Analyzing real time I/O waits Time series I/O Wait Analysis Time Series Monitoring of the Data Buffers Monitoring Disk I/O with AWR Conclusion	Chapter 14: Oracle Instance Tuning Semper Vigilans Instance Tuning comes first! Instance Configuration for High Performance OS kernel parameters Server Settings for Windows Servers Kernel setting for UNIX and Linux servers Oracle Parameter Tuning SQL Optimizer Parameters Data Buffer Cache Hidden Parameters Instance Wait Tuning Tuning the Oracle10g Data Buffer Pools The Problem of Duplicitous RAM Caches Why is Oracle Logical I/O so Slow? <
Para obtener mas informacion, visite la pagina del producto.
Este producto esta en nuestro catalogo desde sábado 08 enero, 2005.
Clientes que compraron este producto, tambien han comprado Exploring Oracle Internals Oracle Job Interview Handbook Advanced Oracle Utilities Oracle Tuning:The Definitive Reference Oracle 11g Database DBA Reference Poster Advanced Oracle SQL Programming