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
Metrics and Models in Software Quality Engineering (2nd Edition)
The Prototyping Approach
The Rayleigh Model
Exponential Distribution and Reliability Growth Models
Staged versus Continuous Debating Religion
Using Function Point Metrics to Measure Software Process Improvements
SQL Tips & Techniques (Miscellaneous)
Using Keys and Constraints to Maintain Database Integrity
Working with Functions, Parameters, and Data Types
Understanding SQL Subqueries
Working with Data BLOBs and Text
Repairing and Maintaining MS-SQL Server Database Files
A+ Fast Pass
Domain 1 Installation, Configuration, and Upgrading
Domain 2 Diagnosing and Troubleshooting
Domain 3 Preventive Maintenance
Domain 6 Basic Networking
Domain 1 Operating System Fundamentals
MySQL Cookbook
Issuing Queries
Creating a Destination Table on the Fly from a Result Set
Using TIMESTAMP Values
Producing Master-Detail Lists and Summaries
Generating Previous-Page and Next-Page Links
.NET System Management Services
.NET Framework and Windows Management Instrumentation
Instrumenting .NET Applications with WMI
The WMI Schema
WMI Providers
WMI Security
User Interfaces in C#: Windows Forms and Custom Controls
Control Class Basics
Forms
Modern Controls
GDI+ Basics
GDI+ 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