Secrets of the Oracle Database
The book is intended to complement the vast documentation from Oracle Corporation as well as articles found on Oracle’s Metalink support platform. Arguably, the omission of some features from Oracle’s documentation might be considered a documentation bug. Many features, especially among those for t...
Đã 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/34660 |
| 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-34660 |
|---|---|
| record_format |
dspace |
| institution |
Thư viện Trường Đại học Đà Lạt |
| collection |
Thư viện số |
| language |
English |
| topic |
Database Computer |
| spellingShingle |
Database Computer Debes, Norbert Secrets of the Oracle Database |
| description |
The book is intended to complement the vast documentation from Oracle Corporation as
well as articles found on Oracle’s Metalink support platform. Arguably, the omission of some features from Oracle’s documentation might be considered a documentation bug. Many features, especially among those for troubleshooting (e.g., events) and tracing, remain undocumented on purpose and for good reason, since Oracle Corporation rightfully suspects that they might backfire when used in the wrong situation or without fully understanding the implications of their use. Such features are not the subject of this book either. Instead, this text is centered
on those undocumented features that provide significant benefit without compromising the
integrity or availability of databases.
In this book, a certain feature is said to be undocumented if the full text search of the documentation provided on the Oracle Technology Network2 web site does not yield any hint of the feature’s existence. A feature is said to be partially documented if the full text search does reveal that the feature exists, but significant aspects of the feature are undocumented, thus limiting
the usefulness of the feature. Incomplete documentation often causes the need to investigate a feature, which constitutes a significant investment in time and thus money, to reveal the undocumented aspects through trial and error, searching the Internet, or Oracle’s Metalink support platform. A significant number of undocumented aspects unveiled in this text are not addressed by Metalink articles.
This book is a highly technical book. I have spared no effort in making the material as easily accessible as possible by not assuming too much previous knowledge by the reader, adopting a clear writing style, and presenting many examples. An occasional humorous remark serves to intermittently stimulate the right brain and perhaps even trigger a grin, allowing the left analytical
brain to rest for a moment before tackling more technicalities. |
| format |
Book |
| author |
Debes, Norbert |
| author_facet |
Debes, Norbert |
| author_sort |
Debes, Norbert |
| title |
Secrets of the Oracle Database |
| title_short |
Secrets of the Oracle Database |
| title_full |
Secrets of the Oracle Database |
| title_fullStr |
Secrets of the Oracle Database |
| title_full_unstemmed |
Secrets of the Oracle Database |
| title_sort |
secrets of the oracle database |
| publisher |
Apress |
| publishDate |
2013 |
| url |
http://scholar.dlu.edu.vn/thuvienso/handle/DLU123456789/34660 |
| _version_ |
1757658647821811712 |
| spelling |
oai:scholar.dlu.edu.vn:DLU123456789-346602014-01-20T01:46:46Z Secrets of the Oracle Database Debes, Norbert Database Computer The book is intended to complement the vast documentation from Oracle Corporation as well as articles found on Oracle’s Metalink support platform. Arguably, the omission of some features from Oracle’s documentation might be considered a documentation bug. Many features, especially among those for troubleshooting (e.g., events) and tracing, remain undocumented on purpose and for good reason, since Oracle Corporation rightfully suspects that they might backfire when used in the wrong situation or without fully understanding the implications of their use. Such features are not the subject of this book either. Instead, this text is centered on those undocumented features that provide significant benefit without compromising the integrity or availability of databases. In this book, a certain feature is said to be undocumented if the full text search of the documentation provided on the Oracle Technology Network2 web site does not yield any hint of the feature’s existence. A feature is said to be partially documented if the full text search does reveal that the feature exists, but significant aspects of the feature are undocumented, thus limiting the usefulness of the feature. Incomplete documentation often causes the need to investigate a feature, which constitutes a significant investment in time and thus money, to reveal the undocumented aspects through trial and error, searching the Internet, or Oracle’s Metalink support platform. A significant number of undocumented aspects unveiled in this text are not addressed by Metalink articles. This book is a highly technical book. I have spared no effort in making the material as easily accessible as possible by not assuming too much previous knowledge by the reader, adopting a clear writing style, and presenting many examples. An occasional humorous remark serves to intermittently stimulate the right brain and perhaps even trigger a grin, allowing the left analytical brain to rest for a moment before tackling more technicalities. PART 1 ■ ■ ■ Initialization Parameters ■CHAPTER 1 Partially Documented Parameters . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3 ■CHAPTER 2 Hidden Initialization Parameters . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 29 PART 2 ■ ■ ■ Data Dictionary Base Tables ■CHAPTER 3 Introduction to Data Dictionary Base Tables . . . . . . . . . . . . . . . . . . . 41 ■CHAPTER 4 IND$, V$OBJECT_USAGE, and Index Monitoring . . . . . . . . . . . . . . . . 45 PART 3 ■ ■ ■ Events ■CHAPTER 5 Event 10027 and Deadlock Diagnosis . . . . . . . . . . . . . . . . . . . . . . . . . 57 ■CHAPTER 6 Event 10046 and Extended SQL Trace . . . . . . . . . . . . . . . . . . . . . . . . . 61 ■CHAPTER 7 Event 10053 and the Cost Based Optimizer . . . . . . . . . . . . . . . . . . . . 63 ■CHAPTER 8 Event 10079 and Oracle Net Packet Contents . . . . . . . . . . . . . . . . . . 87 PART 4 ■ ■ ■ X$ Fixed Tables ■CHAPTER 9 Introduction to X$ Fixed Tables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 93 ■CHAPTER 10 X$BH and Latch Contention . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 105 ■CHAPTER 11 X$KSLED and Enhanced Session Wait Data . . . . . . . . . . . . . . . . . . . 113 ■CHAPTER 12 X$KFFXP and ASM Metadata . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 119 PART 5 ■ ■ ■ SQL Statements ■CHAPTER 13 ALTER SESSION/SYSTEM SET EVENTS . . . . . . . . . . . . . . . . . . . . . . . 129 ■CHAPTER 14 ALTER SESSION SET CURRENT_SCHEMA . . . . . . . . . . . . . . . . . . . . . 135 ■CHAPTER 15 ALTER USER IDENTIFIED BY VALUES . . . . . . . . . . . . . . . . . . . . . . . . . 143 ■CHAPTER 16 SELECT FOR UPDATE SKIP LOCKED . . . . . . . . . . . . . . . . . . . . . . . . . . 149 PART 6 ■ ■ ■ Supplied PL/SQL Packages ■CHAPTER 17 DBMS_BACKUP_RESTORE . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 165 ■CHAPTER 18 DBMS_IJOB . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 173 ■CHAPTER 19 DBMS_SCHEDULER . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 181 ■CHAPTER 20 DBMS_SYSTEM . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 197 ■CHAPTER 21 DBMS_UTILITY . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 213 PART 7 ■ ■ ■ Application Development ■CHAPTER 22 Perl DBI and DBD::Oracle . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 223 ■CHAPTER 23 Application Instrumentation and End-to-End Tracing . . . . . . . . . . 251 PART 8 ■ ■ ■ Performance ■CHAPTER 24 Extended SQL Trace File Format Reference . . . . . . . . . . . . . . . . . . 271 ■CHAPTER 25 Statspack . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 311 ■CHAPTER 26 Integrating Extended SQL Trace and AWR . . . . . . . . . . . . . . . . . . . . 345 ■CHAPTER 27 ESQLTRCPROF Extended SQL Trace Profiler . . . . . . . . . . . . . . . . . . 351 ■CHAPTER 28 The MERITS Performance Optimization Method . . . . . . . . . . . . . . . 371 PART 9 ■ ■ ■ Oracle Net ■CHAPTER 29 TNS Listener IP Address Binding and IP=FIRST . . . . . . . . . . . . . . . 401 ■CHAPTER 30 TNS Listener TCP/IP Valid Node Checking . . . . . . . . . . . . . . . . . . . . 413 ■CHAPTER 31 Local Naming Parameter ENABLE=BROKEN . . . . . . . . . . . . . . . . . . 419 ■CHAPTER 32 Default Host Name in Oracle Net Configurations . . . . . . . . . . . . . . 423 PART 10 ■ ■ ■ Real Application Clusters ■CHAPTER 33 Session Disconnection, Load Rebalancing, and TAF . . . . . . . . . . . 429 ■CHAPTER 34 Removing the RAC Option Without Reinstalling . . . . . . . . . . . . . . . 445 PART 11 ■ ■ ■ Utilities ■CHAPTER 35 OERR . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 459 ■CHAPTER 36 Recovery Manager Pipe Interface . . . . . . . . . . . . . . . . . . . . . . . . . . . . 465 ■CHAPTER 37 ORADEBUG SQL*Plus Command . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 479 PART 12 ■ ■ ■ Appendixes ■APPENDIX A Enabling and Disabling DBMS Options . . . . . . . . . . . . . . . . . . . . . . . 495 ■APPENDIX B Bibliography . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 497 ■APPENDIX C Glossary . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 499 ■INDEX . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 507 2013-07-17T07:22:17Z 2013-07-17T07:22:17Z 2009 Book 978-1-4302-1952-1 http://scholar.dlu.edu.vn/thuvienso/handle/DLU123456789/34660 en application/pdf Apress |