|
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.
|
|
* 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:
|
