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 --