Download Troubleshooting Oracle performance : [methodically identify and

CONTENTS
Not Using PL/SQL for Data-Centric Processing
11
Performing Unnecessary Commits
11
Steadily Opening
Closing Database Connections
and
Do You Have Performance Problems?
11
System Monitoring
12
Response-Time Monitoring
12
Compulsive Tuning Disorder
12
Approach Performance Problems?
How Do You
Business
Perspective
vs.
System Perspective
Cataloging the Problems
the Problems
Working
On to
-
11
Chapter 2
13
13
14
14
17
Chapter 2: Key Concepts
19
and
19
Selectivity
What Is
Life
How
a
Cardinality
Cursor?
Cycle of
a
Cursor
Parsing Works
21
21
24
Shareable Cursors
25
Bind Variables
29
Reading and Writing Blocks
40
Instrumentation
42
Application Code
43
Database Calls
44
On to Part 2
48
Part II: Identification
49
Chapter 3: Analysis of Reproducible Problems
51
Tracing
viii
Database Calls
51
SQL Trace
52
Structure of the Trace Files
65
Using TRCSESS
67