Flylib.com
Oracle High Performance Tuning for 9i and 10g
Oracle High Performance Tuning for 9i and 10g
ISBN: 1555583059
EAN: 2147483647
Year: 2003
Pages: 164
Authors:
Gavin JT Powell
BUY ON AMAZON
Table of Contents
BackCover
Oracle High Performance Tuning for 9i and 10g
Preface
Introduction
When to Tune
What to Tune in Production
When to Stop Tuning in Production
Tuning from Development to Production
How is this Book Organized?
Some Final Points
What is Oracle Database 10g?
Part I: Data Model Tuning
Chapter 1: The Relational Database Model
1.1 A Layman s Approach to Normalization
1.2 Referential Integrity
Chapter 2: Tuning the Relational Database Model
2.2 Referential Integrity and Tuning
2.3 Optimizing with Alternate Indexes
2.4 Undoing Normalization
Chapter 3: Different Forms of the Relational Database Model
3.1 The Purist s Relational Database Model
3.2 Object Applications and the Relational Database Model
Chapter 4: A Brief History of Data Modeling
4.1 The History of Data Modeling
4.2 The History of Relational Databases
4.3 The History of the Oracle Database
4.4 The Roots of SQL
Part II: SQL Code Tuning
Chapter 5: What is SQL?
5.1 DML and DDL
5.2 DML Command Syntax
5.3 Transaction Control
5.4 Parallel Queries
Chapter 6: The Basics of Efficient SQL
6.1 The SELECT Statement
6.2 Using Functions
6.3 Pseudocolumns
6.4 Comparison Conditions
6.5 Joins
6.6 Using Subqueries for Efficiency
6.7 Using Synonyms
6.8 Using Views
6.9 Temporary Tables
6.10 Resorting to PLSQL
6.11 Replacing DELETE with TRUNCATE
6.12 Object and Relational Conflicts
Chapter 7: Common Sense Indexing
7.1 What and How to Index
7.2 Types of Indexes
7.3 Types of Indexes in Oracle Database
7.4 Tuning BTree Indexes
7.5 Summarizing Indexes
Chapter 8: Making SQL Efficient in Oracle Database
8.1 What is the Parser?
8.2 What is the Optimizer?
8.3 How Best to Access Data in the Database
8.4 Rule-versus Cost-Based Optimization
8.5 Data Access Methods
8.6 Sorting
8.7 Special Cases
8.8 Overriding the Optimizer using Hints
Chapter 9: How to Find Problem Queries
9.1 Tools to Detect Problems
9.2 EXPLAIN PLAN
9.3 SQL Trace and TKPROF
9.4 TRCSESS
9.5 Autotrace
9.6 Oracle Database Performance Views for Tuning SQL
Chapter 10: Tuning SQL with Oracle Enterprise Manager
Part III: Physical and Configuration Tuning
Chapter 11: Installing Oracle and Creating a Database
11.2 Basic Configuration
11.3 Creating a Database
Chapter 12: Tuning Oracle Database File Structures
12.1 Oracle Database Architecture and the Physical Layer
12.2 Tuning and the Logical Layer
Chapter 13: Object Tuning
13.1 Tables
13.2 Indexes
13.3 Index-Organized Tables and Clusters
13.4 Sequences
13.5 Synonyms and Views
13.6 The Recycle Bin
Chapter 14: Low-Level Physical Tuning
14.1 What is the High Water Mark?
14.2 Space Used in a Database
14.3 What are Row Chaining and Row Migration?
14.4 Different Types of Objects
14.5 How Much Block and Extent Tuning?
14.6 Choosing Database Block Size
14.7 Physical Block Structure
14.8 Extent-Level Storage Parameters
Chapter 15: Hardware Resource Usage Tuning
15.2 How Oracle Database Uses Memory
15.3 Tuning Oracle IO Usage
Chapter 16: Tuning Network Usage
16.1 The Listener
16.2 Network Naming Methods
16.3 Connection Profiles
16.4 Shared Servers
Chapter 17: Oracle Partitioning and Parallelism
17.1 What is Oracle Partitioning?
17.2 Tricks with Partitions
Chapter 18: Ratios: Possible Symptoms of Problems
18.1 Database Buffer Cache Hit Ratio
18.2 Table Access Ratios
18.3 Index Use Ratio
18.4 Dictionary Cache Hit Ratio
18.5 Library Cache Hit Ratios
18.6 Disk Sort Ratio
18.7 Chained Rows Ratio
18.8 Parse Ratios
18.9 Latch Hit Ratio
Chapter 19: Wait Events
19.1 Idle Events
19.2 Significant Events
Chapter 20: Latches
20.2 The Most Significant Latches
Chapter 21: Tools and Utilities
21.2 Spotlight
21.3 Operating System Tools
21.4 Other Utilities and Tools
Chapter 22: Tuning with the Wait Event Interface and STATSPACK
22.1 What is a Bottleneck?
22.2 Detecting Potential Bottlenecks
22.3 What is the Wait Event Interface?
22.4 Oracle Database Wait Event Interface Improvements
22.5 Oracle Enterprise Manager and the Wait Event Interface
22.6 Using STATSPACK
Appendix A: Sample Databases
Active Concurrent Database Scripting
Updating Summary Fields
Partitioning Tablespace Creation
Appendix B: Sample Scripts
Statistics Generation
Count Rows
Constraints
Indexes
Space in the Database
TKPROF Trace Files Interpretation Scripts
The TKPROF Interpretation Script
Appendix C: Sources of Information
Index
Index_B
Index_C
Index_D
Index_E
Index_F
Index_H
Index_I
Index_J
Index_L
Index_M
Index_N
Index_O
Index_P
Index_R
Index_S
Index_T
Index_U
Index_W
List of Figures
Oracle High Performance Tuning for 9i and 10g
ISBN: 1555583059
EAN: 2147483647
Year: 2003
Pages: 164
Authors:
Gavin JT Powell
BUY ON AMAZON
Lotus Notes and Domino 6 Development (2nd Edition)
Forms Design
Adding an Outline to a Frameset
Putting Your Agent to Work
Working with Forms, Views, and Shared Actions
Frameset Tags
Snort Cookbook
Invisibly Sniffing 100 MB Ethernet
Logging Only Alerts
Logging to Email
Installing and Configuring SnortCenter
Snort as Evidence in the U.K.
Postfix: The Definitive Guide
The Postfix Queue
How qmgr Works
Separate Message Store
A.1. Postfix Parameter Reference
C.2. Postfix Compiling Primer
Information Dashboard Design: The Effective Visual Communication of Data
All That Glitters Is Not Gold
Supplying Inadequate Context for the Data
Characteristics of a Well-Designed Dashboard
Key Goals in the Visual Design Process
Sample Sales Dashboard
Microsoft WSH and VBScript Programming for the Absolute Beginner
VBScript Basics
Conditional Logic
Using the Windows Registry to Configure Script Settings
Combining Different Scripting Languages
Appendix A WSH Administrative Scripting
Python Standard Library (Nutshell Handbooks) with
The robotparser Module
The pstats Module
The posixpath Module
The macurl2path Module
The cmp Module
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