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-9759135-2-2
ISBN 13
978-0975913529
Library of Congress number: 2005901257
280 pages
Perfect bind - 9x7
PD 605
Shelving: Database/Oracle Oracle In-Focus Series # 23

  Oracle Silver Bullets
Real-world Oracle performance Secrets

Donald K. Burleson     

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

Every Oracle professional should feel the exhilaration of adding a single function-based index and seeing the execution speed cut-in-half for 500 SQL statements. It's these silver bullets that can make you a hero in your shop and amaze your friends and associates. 

All Oracle tuning professionals know that they must start by optimizing the database as-a-whole before tuning individual SQL statements. Only after you have tuned the external hardware (disk RAID, network, OS kernel parms) and the instance (indexes, CBO statistics, optimal parameter settings), is it appropriate to tune individual SQL statements and application code.

A single change to the optimizer can improve the behavior of hundreds of SQL statements, and database-wide tuning approaches such as adding a missing index, creating a materialized view or adjusting CBO statistics must be done before detailed SQL tuning can happen. 

These silver-bullet recommendations have been codified inside the Oracle 10g Automatic Database Diagnostic Monitor (ADDM), and every Oracle professional must recognize the benefits of these important tuning techniques.

Oracle consultant Don Burleson shares his in-the trenches Oracle tuning secrets in this concise and practical book.  Packed with actual techniques and tips, Burleson shows you how to perform system-level tuning on all Oracle databases, from small OLTP systems to giant data warehouses.

This is the definitive collection of professional system-level tuning secrets for every Oracle professional DBA. 

 
Key Features

* Learn the secrets used by professional Oracle consultants to get optimal performance fast.

* See how adjusting important Oracle parameters can improve database-wide performance.

* Understand the importance of proper SQL optimizer configuration.

* Observe when it is appropriate to use faster hardware to solve an Oracle performance problem.

* See how to find and fix your database-wide bottleneck.

* Implement the techniques used by world-class Oracle tuning experts.

About the Author:


Donald Burleson
 

Donald 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 32 books, published more than 100 articles in National Magazines, and serves as Editor-in-Chief of Oracle Internals. Don is a popular lecturer and teacher and is a frequent speaker at Oracle Openworld and other international database conferences.

 

Free Oracle Tips

HTML Text

Reviews:
THE BEST, No wasted effort, September 24, 2006
 
Reviewer: W. Wheeles (USA) - See all my reviews
(REAL NAME)   
All,

I have several hundred Oracle books, and have worked with Oracle for sixteen years. This book is beyond words, it is accurate, and most of all it is concise. Finally someone understands that you do not need to write a book over 800 pages for people to read it.

The real world examples, problem identification and remediation techniques are the best I have ever seen. I will buy Burleson/RAMPANT from now on.
October 15, 2007

I have "Oracle Silver Bullets" and it's a good book.

Given that Oracle DBA work is never, ever a case of "Hey, I feel like improving my DB's performance today: I think I'll run this script of Don's in Production and keep my fingers crossed!", I find it odd that anyone with a brain would malign the book, or the idea of Silver Bullets, using the "A newbie could destroy a database with Silver Bullets" argument. A business that has a DBA that would blithely run ANYTHING, no matter who wrote it, on their Production database without having first tested it fully has employed a ticking bomb. It isn't Don's fault that an idiot would buy Silver Bullets and then start running scripts without first checking them for suitability to their own system. Nor is it Don's fault that a business would employ such a plonker.

Silver Bullets are IDEAS and APPROACHES that MAY work, but have to be TESTED... ALWAYS!!!!

Common sense is any professional's primary asset. To whinge about idiots hamfistedly using others' published ideas, suggestions and insights is both silly and, I think, disingenuous.

Regards,

Richard XXXX
Oracle DBA

 

Table of Contents:

CHAPTER 1- Oracle Silver bullets
 
CHAPTER 2 - The Oracle DBA of the 21st Century
 
CHAPTER 3 - Proactive Tuning and Silver Bullets
 
CHAPTER 4 - The Silver Bullet Hierarchy
 
CHAPTER 5 - Very Large Database Silver Bullets
 
CHAPTER 6 - Indexing Silver Bullets
 
CHAPTER 7 - Instance Parameter Silver Bullets
 
CHAPTER 8 - Table Structure Silver Bullets
 
CHAPTER 9 - Segment Structure Silver Bullets
 
CHAPTER 10 - Oracle SQL Silver Bullets
 
CHAPTER 11 - Oracle Hardware Silver Bullets
 

 

Errata:

Page 71 - Indexes - Users can now choose between b*tree, bitmap and bitmap join indexes.

Page 172 - 2nd paragraph from the bottom the sentence - "When data using the new cbo feature cpu_cost in Oracle10g,..."

Page 16 -  “complex DSS queries” should read “complex queries”

Page 35 - “/dbms_schedule/” should read “/dbms_scheduler/”

Page 103 - The following sentence is backwards: 

When the clustering factor is close to the number of data blocks the column value is not row ordered. When the clustering_factor approaches the number of rows on the table, the table rows are synchronized with the index.

It should read:

When the clustering factor is close to the number of data blocks the column values are row ordered. When the clustering_factor approaches the number of rows on the table, the table rows are increasingly not synchronized with the index.

Page 169 - “Non-relation databases” should read Non-relational databases”

Page 172 - “new /cpu_cost /parameter in” should read “new CBO feature
/cpu_cost/ in Oracle 10g”

Page 229 - add to the bottom of the 2^nd code listing this line: “exec dbms-stats”

The dba_hist_sql_plan table was incorrectly called dba_hist_sqlplan.
 


Index Topics:

_allow_read_only_corruption  
_allow_resetlogs_corruption  
_always_star_transformation  
_corrupt_blocks_on_stuck_recovery  
_corrupted_rollback_segments 
_db_aging_cool_count   
_db_aging_hot_criteria 
_db_aging_stay_count   
_db_aging_touch_time   
_db_block_hash_buckets 
_db_block_hash_latches 
_db_block_hi_priority_batch_size   
_db_block_max_cr_dba   
_db_block_max_scan_cnt 
_db_block_med_priority_batch_size  
_db_block_write_batch  
_fast_full_scan_enabled
_kgl_latch_count 
_latch_spin_count
_parallelism_cost_fudge_factor     
_small_table_threshold 
A
ADDM 
Address Windowing Extension  
advanced bitmap indexing     
all_rows   
alter system     
AMM  
ANSI WITH clause 
anti-join  
artificial intelligence
ASH  
ASM  
auto_sample_size 
Automated Workload Repository
Automatic Database Diagnostic Monitor    
Automatic Memory Management  
automatic query re-write     
Automatic Segment Space Management 
Automatic Storage Management 
Automatic Workload Repository
avg_row_len
AWE  
AWR  
awr_full_table_scans.sql     
awr_sql_cartesian.sql  
awr_sql_object_freq.sql
awr_top_tables_phyrd.sql     
awrrpt.sql 
B
bg_event_int_g.sql     
bi-modal   
bitmap freelists 
bitmap index     
Bitmap Indexes   
block contention 
buf_blocks.sql   
buf_keep_pool.sql
C
Capture    
Cartesian joins  
CBO  
CBO Histograms   
Change Data Capture    
clustering_factor
Cost-based Optimizer   
CPU Bottleneck   
cpu_cost   
CTAS 
cursor_sharing   
D
Data Block Contention  
data buffer hit ratio  
Data Cache Advice
Data Guard 
Data Manipulation Locks
db file scattered read waits 
db file sequential read waits
db_k_cache_size  
db_k_cache_size  
db_k_cache_size  
db_k_cache_size  
db_k_cache_size  
db_block_buffers 
db_block_lru_statistics
db_block_size    
db_cache_advice  
db_cache_size    
db_file_multiblock_read_count
db_keep_cache_size     
db_recycle_cache_size  
DB   
dba_data_files   
dba_hist   
dba_hist_active_sess_history 
dba_hist_filestatxs    
dba_hist_osstat  
dba_hist_snapshot
dba_hist_sql_plan
dba_hist_sqlplan 
dba_hist_sqlstat 
dba_hist_sqltext 
dba_hist_sysstat 
dba_hist_waitstat
dba_histograms   
dba_indexes
dba_tab_modifications  
dba_tables 
dbms_advisor     
dbms_job   
dbms_mview 
dbms_redefinition
dbms_schedule    
dbms_scheduler   
dbms_sqltune     
dbms_stats 
dbms_utility     
Decision Support Systems     
dictionary managed tablespaces     
dimension tables 
Disk Bottleneck  
DML  
DSS  
dss_config.ksh   
dynamic_sampling 
E
EM   
Enterprise Manager     
Enterprise Resource Planning 
estimate_percent 
execution plan   
executions_delta 
explain_rewrite  
F
fact table 
filesystemio_options   
first_rows 
Freelist Block Contention    
FREELIST GROUP   
full table scans 
function-based indexes 
G
Gallium Arsenide 
gather     
gather auto
gather empty     
gather stale     
glance     
Global temporary tables  

 

H
hash cluster tables    
hash join  
HASH joins 
hash_area_size   
high_resource_sql.sql  
high_scan_sql.sql
I
index contention 
INDEX hint 
Indexes    
Index-Organized Tables 
init.ora   
Instance Parameters    
IOT  
Itanium      
J
JBOD 
Just a Bunch of Disks  
K
KEEP pool  
L
library cache      
library cache contention     
LIO  
listener.ora     
LMT  
Locally Managed Tablespaces  
Locally-Managed Tablespaces  
Logical I/O
M
Manual Oracle Aggregation    
materialized views     
method_opt 
Moore’s Law
Most Recently Used     
multiple blocksizes    
multi-table index cluster    
MySQL
N
NESTED LOOP join 
Network Bottleneck     
Non-Uniform Memory Access    
NUMA 
O
Object Parameters
OLTP 
Online Transaction Processing
optimizer plan stability     
optimizer_index_caching
optimizer_index_cost_adj     
optimizer_index_cost_adj.sql 
optimizer_max_permutations   
optimizer_mode   
Oracle Parallel Query  
Oracle*Net 
ORDERED hint     
os_stat_int_g.sql
P
page stealing daemon   
parallel_automatic_tuning    
parallelism
partitioned structures 
pctfree    
pctused    
PGA  
PGA Target Advice
pga_aggregate_target   
Physical I/O     
PIO  
plani.sql  
proactive monitoring   
proactive tuning 
Program Global Area    
R
RAC  
RAID 
RAM Bottleneck   
reactive tuning  
read-only tablespace   
RECYCLE pool     
refresh interval 
rpt_sysstat_dy_g.sql   
rpt_sysstat_hr_g.sql   
RRDtool    
S
SAME 
sar        
scan rate  
schema     
Segment Header Contention    
Segment Structures     
SGA  
sga_max_size     
shared pool
Shared Pool Advice     
shared_pool_size 
single-table index cluster table   
skewonly   
snapfileio_filename.sql
snapfileio_sums.sql    
solid-state disk   
sort_area_size   
SORT-MERGE joins 
SQL Access advisor     
SQL hints  
SQL profiles     
SQL Profiles     
SQL Server 
SQL Tuning Advisor     
SQL WITH clause  
SQL*Net    
SQL*Plus   
SQL_ID     
sqlnet.ora 
STAR Query 
STAR schema
star transformation join     
statistics_level 
stats$filestatxs 
STATSPACK  
Stored Outlines  
Streams    
Stripe And Mirror Everywhere 
Symmetric Multiprocessing    
sys_event_int_g.sql    
System Global Area     
T
table cluster    
table clusters   
Table Structures 
Tablespace Parameters  
time-series tuning     
TKPROF     
tnsnames.ora     
top        
top__sessions.sql
Transparent Network Substrate
U
Undo Header Contention 
undocumented parameters
user_indexes     
V
v$bh 
v$osstat   
v$pga_target_advice    
v$segment_statistics   
v$session  
v$session_wait   

 

v$shared_pool_advice   
v$sql
v$sql_plan 
v$system_event   
v$waitstat 
very large database    
Virtual Memory   
VLDB 
vmstat     
W
wait_time_detail.sql   
workarea_size_policy   
Workload Interface Statistical Engine    
wt_events_int_g.sql    
X
x$bh 
x$kcbcbh   
x$kcbrbh   

 


 

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