Faster Oracle running-Oracle 10 Gb Performance Analysis and Optimization

Faster Oracle running-Oracle 10 Gb Performance Analysis and Optimization

Basic Information

Author: Tan Huaiyuan
Series name: itpub Technology series
Press: Electronic Industry Press
ISBN: 9787121113253
Mounting time:
Published on: February 1, August 2010
Start: 16
Page number: 438
More Wonderful Details: http://www.china-pub.com/196935
More wonderful sample preemptive trial read: http://www.china-pub.com/computers/common/mianfeisd.asp? Id = 196935

Edit recommendations

In China, the first book in the true sense, starting from the work experience, with the author's experience, comprehensively discusses the Oracle database performance optimization books.
The author analyzes performance from a global perspective, rather than sticking to specific technical details, and presents readers with a new way of reading.
The book covers many new performance topics, such as execution plans, bind peeking, parallel execution, 10046 and 10053 events, and AWR reports. It covers almost all Oracle database performance knowledge.

Wonderful comments

I have read this book and read it for an afternoon. The author has rich experience and the content fits into reality,

It is definitely a necessary optimization guide for DBAs in their daily work. The author uses the long-term first-line work experience as an example to explain the Oracle Performance Analysis and Optimization ideas. In a word, I have benefited a lot!

The author's DBA experience is not rich. This book is worth reading.

Very good. The examples in the book are very detailed, the knowledge is very clear, a good book!

Directory

Chapter 1 factors that cause database performance problems 1
1.1 impact of software design on databases 1
1.2 Database Design 8
1.3 Database hardware design 14
1.4 Conclusion 19
Chapter 2 Lock and blocking 20
2.1 about lock 20
2.2 lock and blocking 22
2.3 other cases that cause blocking 30
Chapter 4 latch and wait 44
3.1 latch contention in the sharing pool 45
3.2 data buffer pool latch contention 54
Chapter 1 optimizer 66
4.1 RBO rule-based optimizer 66
4.2 CBO cost-based optimizer 69
Chapter 4 Execution Plan 85
5.1 cardinality (base) 85
5.2 SQL Execution Plan 94
Chapter 2 hint 6th
6.1 hint 115 related to Optimizer
6.2 hint 117 related to the access path
6.3 table join sequence hint 125
6.4 table join operation hint 127
......
Chapter 1 Analysis and Dynamic sampling 7th
7.1 histogram 141
7.2 dbms_stats package 147
7.3 dynamic sampling 176
7.4 conclusion 185
Chapter 2 parallel execution 8th
8.1 parallel and OLAP systems 187
8.2 Parallel Processing Mechanism 189
8.3 read an execution plan for Parallel Processing 191
8.4 a common parallel execution wait event 192
......
Chapter 2 variable binding 9th
9.1 what is variable binding and why is variable binding 232
9.2 Why do OLTP require variable binding and OLAP should not Bind Variable 241?
9.3 bind peaking 248
Chapter 2 SQL _trace and 10th event 10046
10.1 SQL _trace 254
10.2 tkprof tool 256
10.3 10046 event 268
Chapter 2 11th events 10053
Chapter 2 Performance view and performance parameters 12th
Chapter 2 Performance Report 13th
Appendix A common wait events 417
Postscript about database learning method 434