vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| |||
| I would suggest first: Oracle's online documentation...its documentation on cocepts and performance tuning at least. then : 1. Expert one on one by Tom Kyte 2. Effective oracle by design by him 3. Practical oracle 8i by Jonathan Lewis 4 Optimizing oracle performance by Carry Milsap. Thanks.. vvrk33@gmail.com wrote: > Hi All, > Can anyone please suggest me good books for the following. > > 1. Oracle Internals > 2. Oracle Performance Tuning > > Thanks, > Raj V |
| |||
| > vvrk33@gmail.com wrote: > > Hi All, > > Can anyone please suggest me good books for the following. > > > > 1. Oracle Internals > > 2. Oracle Performance Tuning > > > > Thanks, > > Raj V To what nirav already suggested, I would add: "Oracle Wait Interface: A Practical Guide to Performance Diagnostics & Tuning" http://www.amazon.com/gp/product/007...Fencoding=UTF8 ....*well* worth what ever you pay. Regards, Steve |
| ||||
| Steve Howard wrote: > > vvrk33@gmail.com wrote: > > > Hi All, > > > Can anyone please suggest me good books for the following. > > > > > > 1. Oracle Internals > > > 2. Oracle Performance Tuning > > > > > > Thanks, > > > Raj V > > To what nirav already suggested, I would add: > > "Oracle Wait Interface: A Practical Guide to Performance Diagnostics & > Tuning" > > http://www.amazon.com/gp/product/007...Fencoding=UTF8 > > ...*well* worth what ever you pay. > > Regards, > > Steve The only book I know of on true Oracle Internals (X$ views) was written by Steve Adams. I do not remember the title but if it is still available you should not have no trouble finding it via an author search on Amazon/B&N/Borders. Jonathan's book, Practical Oracle 8i, talks about how indexes work internally and includes several commands to dump traces on indexes, the optimizer, and data blocks. The book is in fact mostly current even for 10g. He has written a new one on how the Cost Based Optimizer works. My Kyte's books are both good practical guides for writing pl/sql routines, sql, and some general database managment. IMHO -- Mark D Powell -- |