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
Strategies for Information Technology Governance
Integration Strategies and Tactics for Information Technology Governance
An Emerging Strategy for E-Business IT Governance
A View on Knowledge Management: Utilizing a Balanced Scorecard Methodology for Analyzing Knowledge Metrics
Technical Issues Related to IT Governance Tactics: Product Metrics, Measurements and Process Control
Governance in IT Outsourcing Partnerships
The CISSP and CAP Prep Guide: Platinum Edition
Information Security and Risk Management
Security Architecture and Design
Operations Security
The Accreditation Phase
Appendix G Control Baselines
Cisco IP Telephony (CIPT) (Authorized Self-Study) (2nd Edition)
Upgrading Prior Cisco Unified CallManager Versions
Cisco CallManager User Database
Transformation Masks
Threats Targeting Remote Administration
Using FAC and CMC
Documenting Software Architectures: Views and Beyond
Overview
Summary Checklist
Deployment Style
Documenting a View
Volume I ECS Software Architecture Documentation Beyond Views
After Effects and Photoshop: Animation and Production Effects for DV and Film, Second Edition
Blue-Screen Garbage Mattes
Rotoscoping Techniques with Photoshop
Color, Light, and Focus
Atmosphere, Film, and Noise Effects
Motion Titling Effects
Telecommunications Essentials, Second Edition: The Complete Global Source (2nd Edition)
The Transport Network Infrastructure
Multimedia Networking Requirements
The Migration to Optical Networking
Wireless Communications Basics
A Brief History of Wireless Telecommunications
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