使用Oracle SQLTXPLAIN优化SQL：Oracle Database 12c实战指南

Oracle

SQL

5星 · 超过95%的资源需积分: 9 144 浏览量更新于2023-03-16 2 收藏 24.39MB PDF 举报

身份认证购VIP最低享 7 折!

领优惠券(最高得80元）

资源详情

资源推荐

■ Contents

■Chapter 19: Comparing Execution Plans �� 325

How Do You Use SQLTCOMPARE? �� 325

A Practical Example �� 326

Collecting the Main Method Repository Data �� 328

Preparing the Main Method Repository Data �� 328

Importing the Respository Data �� 330

Running SQLTCOMPARE �� 331

Reading the SQLTCOMPARE Report �� 333

Summary �� 339

■Chapter 20: Running a Health Check �� 341

What Is SQL Health Check? �� 341

The sqlhc�sql Script �� 342

What sqlhc�sql Produces �� 343

Running the SQLHC Script �� 343

The Main Health Check Report ��346

The Diagnostics Report��350

The Execution Plan Report �� 353

The Monitor Reports �� 354

The sqldx�sql Script �� 356

The sqlhcxec�sql Script �� 358

Summary �� 360

■Chapter 21: The Final Word �� 361

Tuning Methodology �� 362

Why SQLT Is, Hands Down, the Best Tuning Utility �� 364

A Word about Platforms �� 364

Other Resources �� 364

Summary �� 365

■ Contents

xvi

■Appendix A: Installing SQLTXPLAIN �� 367

A Standard SQLT Installation �� 367

How to Change the Licensing Level after a SQLT Installation �� 371

A Remote SQLT Installation �� 372

Other Ways to Install SQLT �� 373

How to Remove SQLT �� 373

Installation and Runtime Errors �� 375

12c Privilege Missing �� 375

Where to Find the Log Files �� 376

One or Both of the SQLT Users Not Created �� 376

Installation Hanging �� 376

SQLT_USER_ROLE Not Granted �� 377

■Appendix B: The CBO Parameters (12�1�02) �� 379

General Approach to Dealing with Hidden Parameters �� 379

More Detailed Descriptions of Some Hidden Parameters �� 380

_and_pruning_enabled �� 380

_bloom_ﬁlter_enabled �� 380

_complex_view_merging ��380

_disable_function_based_index ��381

_hash_join_enabled �� 381

_optimizer_extended_cursor_sharing_rel ��381

_optimizer_cartesian_enabled �� 381

_optimizer_cost_model �� 381

_optimizer_ignore_hints ��381

_optimizer_max_permutations �� 382

_optimizer_use_feedback ��382

_optimizer_search_limit ��382

Full List of Parameters �� 382

■Appendix C: Tool Conﬁguration Parameters and the Express Methods �� 395

Index �� 403

xxi

Acknowledgments

First and foremost of course is Carlos Sierra, who wrote the SQLT product and who inspired me to write this

book in the first place. His enthusiasm and patience and willingness to listen allowed me to enter the world

of Oracle SQL tuning with SQLT. Without his help this book would never have come into existence. I hope

that this second edition of the book meets his expectations and I also hope I haven’t made any errors in

my description of his baby. If I have I apologize and of course the error was all mine. Abel Macias deserves

a special mention for keeping me on the right track, when I could not see the obvious path. His clarity of

thought is inspiring; I learned a lot from him and hope to use that knowledge to help others see the path of

righteous tuning.

I feel I must also thank many members of my first family within Oracle (The Oracle Performance

Group), Chris Crocker, and Cathy Scully who had the good sense to hire a Brit; and Mike Matagranno, whose

persistence in getting me to move to Oracle was truly astounding. I hope none of you have regretted that

decision. Special mention must go to Mauro Pagano, whose special knowledge and endless enthusiasm

convinced me that I had something to say that was useful about SQLT.

Special thanks go to Mike Gervais, who was my manager at Oracle and whose kindness and fairness got

me through the first few months at Oracle. Alan Bashy, Nick Meola, and Peter Gadah get a special mention

for being awesome and showing me that no matter how much you think you know about tuning, there’s

always more to learn. Many other managers and colleagues have all supported me in many ways. I have

been very lucky to come across an endless number of knowledgeable and enthusiastic colleagues and

all-round nice people.

On the book side Jonathan Gennick was the one who made the final decision to publish this book.

He showed faith when others were doubtful. Chris Nelson deserves a mention: his Herculean efforts have

immeasurably improved the first edition of this book and created something useful from my poor illiterate

scratrchings (don’t change that) and allowed me to produce what I hope will be a useful book for years to

come. Chris shouted at me during the marathon that is writing a book and kept me going by telling me the

finishing line was just around the corner. For your patience and hard work I sincerely thank you. Arup Nanda

and Iggy Fernandez are especially to be thanked for making many useful suggestions for improvement in the

book text.

剩余411页未读，继续阅读

DWcsdnNET

粉丝: 415
资源: 652

会员权益专享

使用Oracle SQLTXPLAIN优化SQL：Oracle Database 12c实战指南

Oracle SQL Tuning with Oracle SQLTXPLAIN(Apress,2013)

sql performance tuning

Oracle 12C SQL语言参考指南

Oracle Database 12c关键功能选件详解

Oracle 12c 新特性深度解析：内存优化与多租户管理

Oracle Database 10g SQL Tuning 教材第二版

Oracle 12c 开发指南：从创建用户到部署的全方位指导

Oracle SQL Tuning Advisor：自动化查询优化，提升性能

Oracle 12c中的SQL优化技巧

oracle sql解析器

优化oracle sql语句详细

oracle sqlmonitor不显示

oracle performance tuning guide

学习oracle调优 官方语言翻译一下

Oracle SQL优化

oracle19c官方文档

oracle数据库sql优化

oraclesql优化

掌握SQL知识，熟悉SQL优化流程，精通oracle数据开发

会员权益专享

最新资源

学习oracle调优官方语言翻译一下