Flylib.com
Oracle Wait Interface: A Practical Guide to Performance Diagnostics & Tuning (Osborne ORACLE Press Series)
Oracle Wait Interface: A Practical Guide to Performance Diagnostics & Tuning (Osborne ORACLE Press Series)
ISBN: 007222729X
EAN: 2147483647
Year: 2004
Pages: 114
Authors:
Richmond Shee
,
Kirtikumar Deshpande
,
K. Gopalakrishnan
BUY ON AMAZON
Table of Contents
BackCover
Oracle Wait Interface - A Practical Guide to Performance Diagnostics Tuning
Foreword
Introduction
Chapter 1: Introduction to Oracle Wait Interface
The Old Fashion of Oracle Performance Optimization
Why Are Cache-Hit Ratios Grossly Inefficient?
The New Fashion of Oracle Performance Optimization
The OWI Philosophy
Database Response Time Tuning Model
Paradigm Shift
In a Nutshell
Chapter 2: Oracle Wait Interface Components
OWI Components
New OWI Views in Oracle Database 10g Release 1
OWI Limitations
In a Nutshell
Chapter 3: Common Wait Events
Common Wait Events in Oracle Real Application Clusters Environment
Tracking CPU and Other Statistics
In a Nutshell
Chapter 4: OWI Monitoring and Collection Methods
Why Is Historical Performance Data Important?
Fast and Accurate Root Cause Analysis
Why Trace Event 10046 Is Not a Suitable Data Collector
Why Statspack Is Not a Suitable Data Collector
Database Logoff Trigger as a Data Collector
Sampling for Performance Data Using PLSQL Procedure
Sampling for Performance Data with SQL-less SGA Access
In a Nutshell
Chapter 5: Interpreting Common IO Related Wait Events
db file sequential read
db file scattered read
direct path read
direct path write
db file parallel write
log file parallel write
control file parallel write
In a Nutshell
Chapter 6: Interpreting Locks-Related Wait Events
Latch Free
Enqueue
Buffer Busy Waits
In a Nutshell
Chapter 7: Interpreting Common Latency-Related Wait Events
log buffer space
free buffer waits
write complete waits
log file switch completion
log file switch (checkpoint incomplete)
In a Nutshell
Chapter 8: Wait Events in a Real Application Clusters Environment
Global Cache Waits
RAC Wait Event Enhancements in Oracle Database 10g
Enqueue Waits
In a Nutshell
Chapter 9: Performance Management in Oracle Database 10g
New Background Processes
Automatic Workload Repository
Active Session History
Automatic Database Diagnostic Monitor (ADDM)
In a Nutshell
Appendix A: Oracle Database 10g Diagnostic Events
Appendix B: Enqueue Waits in Oracle Database 10g
Appendix C: Oracle Dumps and Traces
Data Block Dump
Buffers Dump
Buffer Dump
File Headers Dump
Control File Dump
Heap Dump
Library Cache Dump
Processstate Dump
Shared Server State Dump
Systemstate Dump
Redo Log Dump
Appendix D: Direct SGA Access
Security
Speed
Concurrency
Get Hidden Information
Introduction to X Views
The Necessary Ingredients
Attaching the SGA to a C Program
Appendix E: References
Index
Index_B
Index_C
Index_D
Index_E
Index_F
Index_G
Index_H
Index_I
Index_K
Index_L
Index_M
Index_N
Index_O
Index_P
Index_Q
Index_R
Index_S
Index_T
Index_U
Index_V
Index_W
Index_X
Index_Y
List of Figures
List of Tables
List of Sidebars
Oracle Wait Interface: A Practical Guide to Performance Diagnostics & Tuning (Osborne ORACLE Press Series)
ISBN: 007222729X
EAN: 2147483647
Year: 2004
Pages: 114
Authors:
Richmond Shee
,
Kirtikumar Deshpande
,
K. Gopalakrishnan
BUY ON AMAZON
ADO.NET 3.5 Cookbook (Cookbooks (OReilly))
Executing Queries That Use COMPUTE BY
Getting an Identity Column Value from SQL Server
Getting a Sequence Value from Oracle
Updating a DataSet with a Many-to-Many Relationship
Using Manual Transactions
The .NET Developers Guide to Directory Services Programming
Searching for Deleted Objects
Directory Synchronization Queries
Schema Extension Best Practices
Managing Passwords for ADAM Users
The Reflection Method
PostgreSQL(c) The comprehensive guide to building, programming, and administering PostgreSQL databases
Adding New Records to a Table
PostgreSQL SQL Syntax and Use
Client 5Using a Typed DataSet
Roadmap (Wheres All My Stuff?)
Securing the PostgreSQL Data Files
Competency-Based Human Resource Management
An Overview of Competency-Based HR Management Practices
Competency-Based Performance Management
Competency-Based Employee Rewards
The Transformation to Competency-Based HR Management
Appendix B Further Suggestions on Employee Development
Oracle SQL*Plus: The Definitive Guide (Definitive Guides)
Running SQL Queries
Working with PL/SQL
Cleaning Up the Display
Returning Values to Unix
Improving on EXPLAIN PLAN Results
Programming .Net Windows Applications
Mouse Interaction
Label
ProgressBar
Exceptions
Deployment
flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net
Privacy policy
This website uses cookies. Click
here
to find out more.
Accept cookies