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
ADO.NET 3.5 Cookbook (Cookbooks (OReilly))
Monitoring Connections
Getting a Sequence Value from Oracle
Adding Records with a GUID Primary Key
A.2. Classes
A.4. Interfaces
Kanban Made Simple: Demystifying and Applying Toyotas Legendary Manufacturing Process
Introduction to Kanban
Conduct Data Collection
Conclusion
Appendix B Kanban Supermarkets
Appendix J Abbreviations and Acronyms
Snort Cookbook
Configuring MySQL for Snort
Detecting Malware
Detecting Viruses
Creating HTML Log Analysis Output
Tools for Testing Signatures
AutoCAD 2005 and AutoCAD LT 2005. No Experience Required
Getting to Know AutoCAD
Basic Commands to Get Started
Using Layers to Organize Your Drawing
Generating Elevations
Printing an AutoCAD Drawing
Understanding Digital Signal Processing (2nd Edition)
Chapter Seven. Specialized Lowpass FIR Filters
COHERENT AVERAGING
SIMPLIFIED FIR FILTER STRUCTURE
EFFICIENT POLYNOMIAL EVALUATION
REFERENCES
User Interfaces in C#: Windows Forms and Custom Controls
Creating Usable Interfaces
Control Class Basics
Classic Controls
Forms
Data Controls
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