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
Java I/O
Slicing
Server Socket Channels
File Dialogs
Hot Plugging
The J2ME Generic Connection Framework
Interprocess Communications in Linux: The Nooks and Crannies
Process Group ID
Summary
Creating a Shared Memory Segment
Thread Attributes
Thread Synchronization
Lotus Notes and Domino 6 Development (2nd Edition)
Forms Design
Using View Column Properties
Error Handling
Validating Radio Buttons
DCR Example
Cisco IOS in a Nutshell (In a Nutshell (OReilly))
Mapping Hostnames to IP Addresses
Networking Technologies
Configuring a Simple DDR Connection
Dialer Interfaces (Dialer Profiles)
Switch Monitor Port for IDS or Sniffers
Cisco Voice Gateways and Gatekeepers
Securing SIP Gateways
Review Questions
Restricting Inbound Calls
Tcl IVR and VoiceXML Application Overview
Comparing, Designing, and Deploying VPNs
Benefits and Drawbacks of L2TP Remote Access VPNs
Implementing Full Network Access Using the Cisco SSL VPN Client
Strengthening SSL Remote Access VPNs Security by Implementing Cisco Secure Desktop
Designing and Building SSL Remote Access VPNs (WebVPN)
Understanding VPLS
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