文件名称:
oracle performance tuning for 9i and 10g
开发工具:
文件大小: 10mb
下载次数: 0
上传时间: 2008-12-04
详细说明： This book is about tuning Oracle databases. Three areas of Oracle Database tuning are data model tuning, SQL code tuning plus physical, and configuration tuning. The author began his career as an applications developer and not a systems or network administrator. As a result this book is written from an applications rather than an operating system perspective. The objective of this book is to cover all three areas of Oracle Database tuning. Currently there is no title on the market completely covering all of these. This book wil l cover all three by explaining both problem detection and resolution. The approach in this book is to present something which appears to be immensely complex in a simplistic and easy-to-understand manner. Both reference material and examples are utilized appropriately in order to expedite understanding for the reader. Reference material is not overused. Oracle software has been in general use commercially for many years and is intended to provide for a very large and diverse customer base. Features are often not removed from Oracle software between versions and new features are continuously being added. The result is that Oracle software contains a plethora of available options and features. Using only reference information to explain Oracle Database tuning would therefore be difficult to read, contrary to the approach of this book and would not provide the reader with much practical advice. This book contains a lot of examples, with realistic databases and data; sometimes even very large amounts of data. After all, if your production database needs tuning, you probably have more data than you first expected. This book is written from not only an applications perspective but from the expert knowledge of the author, both in development and database administration roles. A broad-based tutorial on the subject of tuning Oracle Database is much needed. Most database administrators have operating system administration experience and little SQL code or data-modeling experience. On the other hand, developers have the opposite. This book will target both developers and database administrators since it includes all three areas essential to tuning Oracle installations effectively. The important factor is that all tuning skills are required for best performance, both administration and development skills sets. Being a broad-based tutorial this title is written to reach the widest possible audience, including data modelers, developers, database administrators, and system administrators. Each of these audiences is very specialized, but all are related and interdependent. There are no existing titles including tuning for data models, tuning of SQL code plus physical and configuration tuning, all in one book. People who would benefit from reading this book would be database administrators, developers, data modelers, systems or network administrators and technical managers. Technical people with these different skills are often ignorant of the skills of each other. This is a great pity because all skill sets are very much dependent on each other for well-constructed databases and applications. Let's take a common example situation. Developers cannot simply hand off SQL code tuning to database administrators when application coding is complete. Database administrators more often than not know absolutely nothing about SQL code tuning. The result is no SQL code tuning is ever done and too much time is spent squeezing out an extra 10% of performance, with the database administrator doing physical and configuration tuning. Targeting a few hard- hitting SQL statements will probably result in much more than a 10% performance improvement, which is much more productive. ...展开收缩
(系统自动生成,下载前可以参看下载内容)
下载文件列表
相关说明
- 本站资源为会员上传分享交流与学习,如有侵犯您的权益,请联系我们删除.
- 本站是交换下载平台，提供交流渠道，下载内容来自于网络，除下载问题外，其它问题请自行百度。
- 本站已设置防盗链，请勿用迅雷、QQ旋风等多线程下载软件下载资源，下载后用WinRAR最新版进行解压.
- 如果您发现内容无法下载，请稍后再次尝试；或者到消费记录里找到下载记录反馈给我们.
- 下载后发现下载的内容跟说明不相乎，请到消费记录里找到下载记录反馈给我们，经确认后退回积分.
- 如下载前有疑问，可以通过点击"提供者"的名字，查看对方的联系方式，联系对方咨询.
