Oracle DBA manual-database diagnosis cases and performance optimization practices (planned by guobiao)

Oracle DBA manual-database diagnosis cases and performance optimization practices (planned by guobiao)

Pricing: ￥59.80

Member price: ￥44.85 (off)

Example of this book free trial: http://www.china-pub.com/196286

[Basic Information]
Author: Editorial Board of Oracle DBA Manual
Press: Electronic Industry Press
ISBN: 9787121101397
Mounting time:
Published on: February 1, January 2010
Start: 16
Page number: 407
Version: 1-1

[Edit recommendations]
Director of Oracle ace and author of Oracle best-selling book guobiao personally planned
Thoughts on the work of five first-line Oracle DBAs
How to diagnose and optimize databases from different perspectives

[Content Overview]
This book is composed of multiple engineers working on database maintenance. It contains carefully selected database diagnostic cases and performance optimization practices. It covers the analysis and diagnosis of typical Oracle errors, various SQL optimization methods (including adjusting indexes, processing table fragments, optimizing paging queries, and improving execution plans) and experience in optimizing system performance.
The authors not only emphasize the practicality and operability of the case, but also repeat the process and ideas for solving the problem and sum up experience and lessons. They hope to combine the accumulated work methods over the years, the insights on DBA career development are presented for the reference of Oracle DBAs.

Directory
1st DBA work Note 1
DBA work manual of eygle (Author: guoguo) 3
DBAs 2.0 4
DBA's daily work responsibilities-my advice on DBA 10
What are the most important qualities of DBA? 11
DBA's accidental deletion in his career Article 12
DBA police record-some habits DBAs need to develop 13
Troubleshooting 1 in RAC Environment 14
SQL _trace trace and diagnosis 16
Case 19 of recursive SQL High Resolution caused by temporary tablespace groups
Use flashback to query and restore accidentally deleted data 21
Use errorstack for Error Tracking and diagnosis 24
Failure and recovery of ASM diskgroup caused by Power Failure Case 26
Improvement of Shared Pool and change of ORA-04031 27
Handling of abnormal release of shared memory 34
Log_buffer settings and changes 35
Logmnr simple and powerful tool 36
Learn more from data dictionary 38
DBA work Note of yangtingkun (by Yang Tingting) 45
Use SQL to explain a magic 46

. ORA-600 (17069) Error solving process 47
V $ diagnosis of exceptions in the SQL view Result 51
Error parsing for Stored Procedure ORA-4068 54
Diagnosis of a network connection error 57
Talking about the features of job and database link 58
One ORA-01041 error diagnosis 60
Analysis of an ORA-604 error 61
ORA-7445 (kdodpm) Error 62
Function indexes generate hidden columns 65
Use SQL to solve an interesting question 67
Old Xiong's DBA note (Author: Xiong Jun) 71
Case 72 caused by tns_admin and OEM
DB link fault caused by Trojan protection software 74
Bad block and data recovery 76
ORA-12541 error caused by IP address conflict 82
ORA-8103 error handling 83
DBA work manual of banping (Author: Yan depping) 87
SQL Execution Plan Change Causes query to slow down 88
Large data volume operations cause data guard delay 91
Performance problems caused by frequent Oracle redo log switching 92
Solution to a ORA-01438 error 93
Use logminer to find log information 95
Optimize oralce's storage structure by merging shards 97
Handling of GES alarms in RAC environments 99

2nd diagnosis cases 101
ASM case analysis and diagnosis (by Yang Tingting) 103
ORA-1012 Error Analysis for ASM instance connection 104
ASM space expansion fault solving 111
ORA-569 error solution for creating tablespace in ASM 115
Diagnosis and handling of a monitoring fault (Author: Xiong Jun) 121
Problem diagnosis and analysis 122
Working principle 123
Solution 127
Conclusion 129
Ora series errors and diagnostics (by Yang Tingting) 131
Process for resolving ORA-600 (16164) errors 132
Trace 139 For A ORA-942 Error
Removing tablespace ORA-22868 error 150
One ORA-1461 error handling process 160
ORA-01200 error bare device recovery (Author: guobiang) 169
170 of problems discovered
Analysis of Problems 171
Control File and Data File Header 174
Physical device verification 176
Solution identification 176
Resume execution 177
Use RMAN to manage bare Device Files 181
Oracle gave up 184 support for bare Devices
Meaning of Oracle Database Version 185
Troubleshooting of Oracle Database faults without response (Author: Xiong Jun) 189
Analysis of Non-responsive fault phenomena 190
Cause Analysis of no response fault 190
No response fault handling process 191
How to Avoid zero response failures in the database 193
Actual case handling process: 193
Case summary analysis 198
Conclusion 201
RAC environmental diagnosis case 1 (by Yang Tingting) 203

3rd SQL optimization 213
Rational use of indexes to solve performance problems (Author: Xiong Jun) 215
Case 1: using composite indexes to solve 216 of performance problems
Structure and features of B-tree indexes 218
How Does Oracle scan indexes 223
Case 2: clever use of index descending scanning to solve performance problems 224
The cost of data access through indexes is calculated as 225.
Case 3: Reduce the clustering factor and solve the performance problem by 227
Conclusion 228
SQL optimization and adjustment practices (by Yang Tingting) 229
How does a hint take effect 230 across views
SQL optimization issues 236
Processing of constants in SQL statements 244
247 Optimization for one update operation
Index access and Data Reading (Author: gaiguoqiang) 253
SQL 254 for high dB time usage
Execution Plan acquisition and index optimization 255
Index fast full scan and sorting 256
Descending index full scan eliminates sorting optimization by 260
Index fast full scan data access 262
Index full scan data access 268
Key-value sequence and index access performance: 269
Improve query performance by 274 using function-based indexes
SQL Optimization-everything is possible (by Yang Tingting) 281
Union efficiency is 282 higher than Union all efficiency.
The effect of constant query conditions on queries is 284.
The efficiency of two-layer group by is 287 higher than that of one-layer group
After distinct is added, the query efficiency increases by 290.
Add index change execution plan 292

4th performance optimization 295
Case study of execution plan and statistical information (Author: Yang Tingting) 297
A check bug in CBO 298
Error 303 when the query is normal as a condition
Job call dbms_stats package error diagnosis 308
Long latch free wait-record the diagnosis process of a system exception 310
A ORA-4030 problem diagnosis and solution 317
Oracle Database performance and statistical information (by Xiong Jun) 329
A real case 330
Importance of Statistical Information 334
Statistics related knowledge 335
Problems and challenges 337
Common Mistakes in statistics 339
Conclusion 341
Clustering factor, bar chart and Execution Plan (Author: Duan linzhong) 343
Clustering_factor has 344 impact on the Execution Plan
Cursor_sharing and SQL Execution Plan 348
Histograms has 352 impact on the execution plan.
Table fragment and paging query optimization (Author: guobiao Qiang) 363
Starting Point of Performance Analysis 364
AWR and oswatcher diagnostic cases 367
Statspack case study 370
Statistical data analysis for Data Tables 371
Fragment elimination and performance optimization 374
The impact of cache and nocache on performance is 379.
Case study of cache tables in ERP system 380
384 Optimization for paging queries
Dbms_profiler package for diagnosis and optimization 387
Conclusion 390
Adjustment and optimization of one sort (Author: Duan linzhong) 391
Statspack problems found 392
SQL Sorting Problem locating 393
SQL optimization and problem solving 394
After optimization, the performance is 400 higher.

References 403