Troubleshooting Oracle Performance
The Oracle database engine has become a huge piece of software. This not only means that a single human can no longer be proficient in using all the features provided in recent versions, but it also means that some of them will rarely be used. Actually, in most situations, it is enough to know an...
Đã lưu trong:
| Tác giả chính: | |
|---|---|
| Định dạng: | Sách |
| Ngôn ngữ: | English |
| Được phát hành: |
Apress
2013
|
| Những chủ đề: | |
| Truy cập trực tuyến: | http://scholar.dlu.edu.vn/thuvienso/handle/DLU123456789/35002 |
| Các nhãn: |
Thêm thẻ
Không có thẻ, Là người đầu tiên thẻ bản ghi này!
|
| Thư viện lưu trữ: | Thư viện Trường Đại học Đà Lạt |
|---|
| id |
oai:scholar.dlu.edu.vn:DLU123456789-35002 |
|---|---|
| record_format |
dspace |
| spelling |
oai:scholar.dlu.edu.vn:DLU123456789-350022014-01-20T01:27:07Z Troubleshooting Oracle Performance Antognini, Christian Antognini Oracle Computer The Oracle database engine has become a huge piece of software. This not only means that a single human can no longer be proficient in using all the features provided in recent versions, but it also means that some of them will rarely be used. Actually, in most situations, it is enough to know and take advantage of a limited number of core features in order to use the Oracle database engine efficiently and successfully. This is precisely why in this book I will cover only the features that, based on my experience, are necessary to troubleshoot most of the databaserelated performance problems you will encounter. Forewords . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xv About the Author . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xix About the Technical Reviewers . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xxi Acknowledgments . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xxiii Introduction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xxv About the OakTable Network . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .xxvii Part 1 Foundations Chapter 1 Performance Problems . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3 Chapter 2 Key Concepts . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 13 Part 2 Identification Chapter 3 Identifying Performance Problems . . . . . . . . . . . . . . . . . . . . . . . . . . . . 35 Part 3 Query Optimizer Chapter 4 System and Object Statistics . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 109 Chapter 5 Configuring the Query Optimizer . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 169 Chapter 6 Execution Plans . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 195 Chapter 7 SQL Tuning Techniques . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 247 Part 4 Optimization Chapter 8 Parsing . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 309 Chapter 9 Optimizing Data Access . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 339 Chapter 10 Optimizing Joins . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 409 Chapter 11 Beyond Data Access and Join Optimization . . . . . . . . . . . . . . . . . . . 459 Chapter 12 Optimizing the Physical Design . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 527 Part 5 Appendixes Appendix A Downloadable Files . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 551 Appendix B Bibliography . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 563 Index . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 567 2013-07-31T02:18:14Z 2013-07-31T02:18:14Z 2008 Book 978-1-59059-917-4 http://scholar.dlu.edu.vn/thuvienso/handle/DLU123456789/35002 en application/pdf Apress |
| institution |
Thư viện Trường Đại học Đà Lạt |
| collection |
Thư viện số |
| language |
English |
| topic |
Oracle Computer |
| spellingShingle |
Oracle Computer Antognini, Christian Antognini Troubleshooting Oracle Performance |
| description |
The Oracle database engine has become a huge piece of software. This not only means that a
single human can no longer be proficient in using all the features provided in recent versions,
but it also means that some of them will rarely be used. Actually, in most situations, it is enough
to know and take advantage of a limited number of core features in order to use the Oracle database
engine efficiently and successfully. This is precisely why in this book I will cover only the
features that, based on my experience, are necessary to troubleshoot most of the databaserelated
performance problems you will encounter. |
| format |
Book |
| author |
Antognini, Christian Antognini |
| author_facet |
Antognini, Christian Antognini |
| author_sort |
Antognini, Christian Antognini |
| title |
Troubleshooting Oracle Performance |
| title_short |
Troubleshooting Oracle Performance |
| title_full |
Troubleshooting Oracle Performance |
| title_fullStr |
Troubleshooting Oracle Performance |
| title_full_unstemmed |
Troubleshooting Oracle Performance |
| title_sort |
troubleshooting oracle performance |
| publisher |
Apress |
| publishDate |
2013 |
| url |
http://scholar.dlu.edu.vn/thuvienso/handle/DLU123456789/35002 |
| _version_ |
1757651177987637248 |