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

Oracle Software
image
image
Write for Rampant
Publish with Rampant
Rampant News
Rampant Authors
Rampant Staff
  Phone
  252-431-0050
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-9823061-5-6
ISBN 13
978-0-9823061-5-4
Library of Congress: xxx
378 pages:
Hardcover - 9x7
PD 0710
Shelving: Databases/Oracle Oracle In-Focus Series #37

 

Advanced Oracle SQL Tuning
The Definitive Reference


By
Donald K. Burleson           Retail Price $59.95  

Preorder now
Only $49.95
(30% off)
Buy it now
       
Key Features   About the Authors Reader Comments
Table of Contents   Errata  
       
Get the Oracle Tuning Half-Pack
Three for $79.95 - A $125.00 value
Oracle Tuning: The Definitive Reference 2nd Edition $69.95
Oracle Replication $27.95
Oracle Silver Bullets $27.95

 


It's impossible to tune an Oracle database without understanding SQL tuning.  Oracle is a SQL processing engine and the execution speed of any SQL query is influenced by many factors, both internal and external.

As a declarative data access method, SQL relies on the Oracle cost-based optimizer to always choose the "best" execution plan for every SQL query.  However, Oracle's SQL is among the most flexible and robust in the world, and along with this great power comes complexity.

Tuning Oracle SQL is the single most important skill of any Oracle professional, and Oracle professionals are challenged to create SQL statements that will support thousands of concurrent executions with sub-second response time.

"Advanced Oracle SQL Tuning" is a pragmatic treatment of Oracle SQL tuning, short on theory and big on real-world techniques and tips.   This book is the culmination of the author's 25 years of full-time DBA experience and he shares expert tips and secrets for hyper charging SQL execution speed.

This book covers advanced topics and it is not appropriate for beginners, dilettantes or neophytes.

 
Key Features

* Hypercharge your SQL performance

* Learn expert secrets for global SQL optimization

* See how to tune SQL with hints.

* Understand how to tune SQL with statistics and histograms.

* Tuning with tuning tips.

* See inside the Oracle Cost-Based Optimizer.

* Receive ready-to-run scripts to tune your Oracle SQL.

* Tune your library cache for super-fast SQL parsing.

 

 

About the Author:


Donald Burleson

Donald K. Burleson is one of the world’s top Oracle Database experts with more than 25 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 more than 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.

 

Free Oracle Tips

HTML Text

Table of Contents:

Using the Online Code Depot
Conventions Used in this Book
Acknowledgements

Preface

     Foreword

Reasons to Certify

     Certification Tracks
     Where to Find Official Information
What This Book Covers
The Structure of the Book
Exam Objectives and Requirements

   Exam Topics
Exam Information

    Advice for Taking the OCE Exam
How to Use This Book
         

Chapter 1:  Introduction to Linux          

What is Linux?

History of Linux and Unix

The Linux Kernel

The Different Distributions of Linux
How is Linux Structured?

Why Oracle on Linux?

What is the Oracle Unbreakable Linux Program?

Hardware Supported by LinuxOS Support

Defining User’s Linux Version

Processes and Threads in Linux

Devices in Linux

Commands and Programs in Linux

Environment Variables

Linux and RPM

Summary

Exercises

Q&A

Questions
Answers:

Solutions to Exercise:

Chapter 2:  Linux Level 2: File Permissions and Processes

Users and Groups

Users

Groups

Administering Users by Command

Rules about the UID and GID
How to Set Up a BASH Environment or Profile

File Permissions

File Security and Administration

How to Change File Permissions

How to Create Links

Processes

Commands to Manage Processes

Kernel Parameters

Introduction to Semaphores
Modifying Parameters for the Semaphores

Shared Memory Parameters

Commands Used For Changing Values

Network Parameters
File Handler Parameters

Summary

Exercises
Q&A

Questions:

Answers:

Solutions to Exercises

Chapter 3:  Linux Level 3:  File Systems and Structures

File Systems

Superblocks

Inodes

Handling File Systems

File System Creation

Swap

Startup Sequences for Linux

Init Modes

OS Patches

Summary

Exercises

Questions:
 Answers:

Solutions for Exercises

Chapter 4: Linux Measurements, Scheduling Tools and X Windows   

Linux Measurements Tools

Memory Measurement Tools

X Windows GUI Measurement Tools

xosview

Scheduling Tools

Task Scheduler

X Windows

Summary

Exercises

Q&A

Questions:

 Answers:      

Chapter 5:  Linux Text Editor

Introduction

Launch vi

Modes with vi

Chapter 6:  Preparing Linux for Oracle     

Oracle on Linux

Metalink – My Oracle Support

Hardware Requirements

RPM Packages

Operating System Settings

Linux Kernel Parameters

Groups and User

Typical Groups for Oracle under Linux

Oracle Users

Download the Oracle Installation

Additional Resources and Tools

Summary

Exercises

Q&A

Questions

Answers:

Exercise Solutions        

 

Chapter 7:  Installing Oracle on Linux 

Oracle Account Settings

OFA (Optimal Flexible Architecture)

Multiple Oracle Versions on the Same Server

Download the Installation Files

Installation

Oracle Universal Installer Log Files

OPatch Utility

Relink the Binaries

Solve Issues During the Installation

Topics Not On Exam

Java NCOMP

OUI Silent Installation

OUI Binaries Cloning

Conclusion

Exercises

Q&A

Questions:

Answers:

Results of the Exercises        

Chapter 8:  Managing Storage     

File System Features

Partitions in Linux

Supported and Certified File Systems by Oracle

Conclusion

Exercises

Q&A

Questions:

Answers:

Solutions to Exercises

Chapter 9:  Automatic Storage Management

What is ASM?

What is ASM Able to Store?

ASM Installation, Settings and Best Practices

ASM Library Install and Setup

Perform the Disk Configuration

Mark Disks to be Used by ASM

Create the ASM Instance

ASMLib and ASM Digest

Conclusion

Exercises

Q&A

Questions:

Answers:

Solutions to Exercises     

Chapter 10:  Creating An Oracle Database    

How to Create an Oracle Database

Oracle Instance Processes, Files and Structures

URL Information
OS Authentication

Oracle Diverse Commands and Files

Summary

Exercises

Q&A

Questions:

Answers:

Solutions to Exercises

Chapter 11:  Customizing Oracle Databases Under Linux

Why Customize Oracle Databases under Linux?

Automatic vs. Manual Oracle Stop and Start

Script to Perform Stop and Start of an Oracle Database

Stop and Start Script dbora

Oracle EM Dbconsole Scheduling Possibilities

Customization of Oracle Initialization Parameters

Conclusion

Exercises
Q&A

Questions:

Answers:

Solutions to the Exercises          

Chapter 12:  Memory Management    

 

Memory Models Available in Linux Kernels

Swap in Linux

Memory Report Tools

Hugepages

Configuration of Hugepages

SGA Relocation Operations

Kernel with Huge Memory

Summary

Exercises

Q&A

Questions:

Answers:

Solutions for Exercises

Chapter 13:  Measurement, Tuning and Debugging         

Linux Measurement Tools

I/O Consideration and Tuning Tools

CPU Consideration and Tuning Tools

Tuning Performance

Debugging

RDA

OS Watcher

Solving the ORA-***** Errors

Summary

Exercises
Q&A

Questions:

Answers:

Chapter 14:  Post Certification Information     

Congratulations!
 DBA and Linux System Administrator Jobs

DBA Tasks

DBA Tools

Book Conclusion

Index

About the Authors

Technical Editors

 

 

 

   

 Copyright © 1996 -2009 by Burleson Enterprises, Inc. 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