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

Source: Internet
Author: User

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
     

    Contact Us

    The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

    If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

    A Free Trial That Lets You Build Big!

    Start building with 50+ products and up to 12 months usage for Elastic Compute Service

    • Sales Support

      1 on 1 presale consultation

    • After-Sales Support

      24/7 Technical Support 6 Free Tickets per Quarter Faster Response

    • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.