Oracle Consulting Oracle Training Oracle Support Development
Home
Catalog
Oracle Books
SQL Server Books
IT Books
Job Interview Books
eBooks
Rampant Horse Books
911 Series
Pedagogue Books

Oracle Software
image
Write for Rampant
Publish with Rampant
Rampant News
Rampant Authors
Rampant Staff
 Phone
 800-766-1884
Oracle News
Oracle Forum
Oracle Tips
Articles by our Authors
Press Releases
SQL Server Books
image
image

Oracle 11g Books

Oracle tuning

Oracle training

Oracle support

Remote Oracle

STATSPACK Viewer

Privacy Policy

  

 

ISBN
0-9745993-7-9
ISBN 13
978-0974599373
Library of Congress Number 2004096474
272 pages
 Perfect bind - 9x7
PD 1104
Shelving: Database/Oracle Oracle In-Focus: Series # 22

  Oracle Wait Event Tuning
High Performance with wait event interface analysis


Stephen Andert              
Retail Price $27.95 /  ฃ17.95
Order now and get immediate online access to the code depot! Only $19.95
(30% off)
     
Key Features About the Authors Table of Contents
Index Reader Comments Errata
     
Get the Oracle Tuning Library
Save $100 - All four books for only $118.95 
Oracle Tuning: The Definitive Reference 3rd Edition $69.95
Advanced Oracle SQL Tuning: The Definitive Reference $59.95
Oracle Performance Troubleshooting 2nd Ed $34.95
Oracle Tuning Powerscripts $37.95


The Oracle Wait Event interface is a revolution in Oracle tuning. Unlike archaic tuning techniques the Oracle wait interface provides a complete method for quickly locating and fixing even the most perplexing Oracle performance problem.

Stephen Andert is a practicing Oracle tuning expert and shares his secrets for fast and reliable Oracle tuning. The Oracle Wait Interface is very complex, and Andert guides you, step-by-step though the process of identifying and correcting any Oracle performance issue.

This is not a beginner book. This text is targeted at the working Oracle professional who must quickly and reliably locate problems and tune their database. Best of all, Andert reveals little-known tips and tricks for capturing external information relating to Oracle performance including disk, network and CPU bottlenecks.

 
Key Features

* Learn a complete method for tuning Oracle databases

* Get ready-to-use Oracle Wait Interface examples

* See expert tricks for interpreting wait interface results

* Understand this radical approach to Oracle tuning

* Learn to quickly gather all the information you need to tune any database

* Find the exact cause of hidden performance killers

About the Author:


Stephen Andert

Stephen Andert is a database administrator for First Health Group Corporation, and has been working with Oracle for 5 years. He has been working with various different relational databases for over 12 years. He has been a technical reviewer for several Oracle books from O'Reilly & Associates, authored an article on SQL*Loader tuning and has presented at local and international Oracle user group events. 

Stephen is an Oracle8 and Oracle8i Oracle Certified Professional and is currently serving on the Board of AZORA, the Arizona Oracle User Group (www.azora.org).  He lives in Arizona with his wife Deanna and two boys, Kevin and Timothy. 

 

Table of Contents:
Section I - Overview

CHAPTER 1. Introduction to Database Tuning Approaches
• Why Tune?
• Ratios – historical introduction
• Wait Interface – a new approach to system level tuning
• 10046 Tracing – a new approach to session level tuning
• Gathering real-time system waits events:
• STATSPACK

CHAPTER 2. Wait Interface – An Elapsed-Time Based System Measurement like Minutes
• Benefits
• Limitations

CHAPTER 3. 10046 Tracing - A Speed Based Session Measurement Like MPH
• Benefits
• Limitations

Section II – Methodology

CHAPTER 4. The Importance of Holistic Oracle Tuning
• Proactive STATSPACK tuning
• Ratio-based tuning
• Tuning disk I/O
• Tuning SQL
• Network tuning
 
CHAPTER 5. Using the Oracle Wait Interface
• Defining the wait interface environment
• Using the wait interface
• Step-by-step examples and case studies

CHAPTER 6. Using 10046 Tracing
• Setting-up for 10046 tracing
• Collecting the trace files
• Interpreting a 10046 trace
• Using third-party tools
• Step-by-step examples and case studies
CHAPTER 7. Using Statspack
• Setting-up Statspack
• Gathering statistics (frequency, history)
• Using spreport
• Using manual script analysis
• Step-by-step examples and case studies
 
CHAPTER 8. New 10g wait event tuning.
The 10046 wait interface becomes obsolete
  • v$session_wait – The current waits in all sessions
  • v$session_wait_history – The last ten waits encountered
  • v$active_session_history - This is populated every second for the past 30 minutes
  • v$waitclassmetric_history
  • v$system_wait_class
  • v$event_histogram
  • v$eventmetric
WRH wait event tables
  • wrh$_event_name
  • wrh$_system_event
  • wrh$_system_event_bl
  • wrh$_bg_event_summary
  • wrh$_waitclassmetric_history – This is populated with wait alerts
  • wrh$active_session_history
Oracle10g DBA views for historical wait events.
  • dba_hist_waitclassmet_history – wait alerts
  • dba_hist_system_event – Populated from wrh$_system_event_bl and wrh$_system_event
  • dba_hist_bg_event_summary

 

Index Topics:
A
Active Session History
active_session_history
Automatic Database Diagnostic Monitor
Automatic Workload Repository
B
binds
Buffer Cache Hit Ratio
C
Cost Based Optimizer
cursor_sharing
D
db file scattered read
db file sequential read
db_file_parallel_write
db_file_sequential_read
dba_advisor
dba_advisor_actions
dba_advisor_definitions
dba_advisor_findings
dba_advisor_log
dba_advisor_objects
dba_advisor_rationale
dba_advisor_recommendations
dba_advisor_sqla_wk_map
dba_advisor_tasks
dba_advisor_usage
dba_data_files
dba_extents
dba_feature_usage_statistics
dba_hist_active_sess_history
dba_hist_baseline
dba_hist_database_instance
dba_hist_snapshot
dba_hist_sql_plan
dba_hist_wr_control
dba_users
dbms_advisor
dbms_application_info
dbms_sqltune
dbms_support
dbms_system
 
E
Event
H
hold_cursor

I
iostat
L
Level
loaded_versions
M
max_dump_file_size
Maximum Transmission Unit
N
netstat
nslookup
O
ORA-
P
perfmon
PERFSTAT
pfile
ping
R
Real Application Cluster
release_cursor
S
Serial#
Session Data Unit
session_cached_cursors
set_bool_param_in_session
set_ev
set_int_param_in_session
set_sql_trace_in_session
SID
sort_area_size
spfile
spray
 
SQL*Net message from client
start_trace
start_trace_in_session
stats$
STATSPACK
statspack.snap
stop_trace
svrmgrl
sysdba
T
timed_statistics
TKPROF
tracefile_identifier
traceroute
Transport Data Unit
U
user_dump_dest
using ratios
V
v$active_session_history
v$buffer_pool_statistics
v$event_histogram
v$event_name
v$eventmetric
v$filestat
v$sess_time_model
v$session
v$session.sid
v$session_event
v$session_wait
v$session_wait_class
v$sesstat
v$sql
v$sys_time_model
v$sysstat
v$system_event
v$system_wait_class
v$tempstat
v$waitclassmetric
v$waitstat
vmstat
W
waits
wrh$_active_session_history
wrh$_bg_event_summary
wrh$_event_name
wrh$_metric_name
wrh$_sessmetric_history
wrh$_sys_time_model
wrh$_sysmetric_history
wrh$_sysmetric_summary
wrh$_sysstat
wrh$_system_event
wrh$_waitclassmetric_history
wrh$_waitstat
wrh$active_session_history
wri$_adv_tasks

Reviews:

 

Errata:
 

 

Hit Counter

   

 Copyright ฉ 1996 -2016 by Burleson. All rights reserved.


Oracleฎ is the registered trademark of Oracle Corporation. SQL Serverฎ is the registered trademark of Microsoft Corporation. 
Many of the designations used by computer vendors to distinguish their products are claimed as Trademarks