Re: Any ideas if oracle development is reading and following up on Mr. Lewis's new book

Charles Hooper wrote:
> hpuxrac wrote:
> > It's been a busy year and I am just now putting a serious effort into
> > reading Jonathan Lewis's new book "Cost-Based Oracle Fundamentals".
> >
> > It's a tremendous book and my appreciation goes out to Mr. Lewis for
> > the time and effort involved in delivering this to the oracle
> > community. I am just making my way into chapter 5.
> >
> > One of the things I have noticed several times already are notes that
> > the author has introduced in the text about possible
> > inconsistencies/bugs in oracle code. For example, in chapter 4 ( page
> > 81 in my book ) under the section "Problems with 10.1.0.4" he notes one
> > specific example where gather_table_stats may not be updating index
> > statistics.
> >
> > One hopes that many/all of these possible bugs have been submitted and
> > reported to oracle already. One also hopes that oracle developers are
> > reading through the book and making their own test cases and list of
> > things to test and fix.
>
> I know that Tom Kyte posted a review of the book on Amazon.com a while
> ago.
>
> The "Cost-Based Oracle Fundamentals" book that Jonathan Lewis wrote is
> a great book.
>
> A couple days after applying patch 9 to 10.2.0.2 on my server, we
> started having problems with "ORA-07445: exception encountered: core
> dump" errors every time clients executed simple SQL statements
> containing LIKE, such as "select ID from PART where ID like '123%';
> Each time this happened, a 4MB to 5MB log file was generated on the
> server.

Yikes ... just when I get closer to migrating to 10.2 you have to tell me this!

>
> Metalink is still working on a solution. Bug 5680308 was posted on
> 11/24/06 reporting essentially the same core dump error, with no
> apparent solution.
>
> 10053 traces are interesting. I updated the SR on Metalink that I
> opened today to tell them what needs to be changed to work around the
> ORA-07445, and then the ORA-00600 errors that appear when other SQL
> statements are executed. Jonathan Lewis wrote is a great book.

It took me a couple times to get started on that book. I picked it up and put it down a couple of times before now ... just finished chapter 9.

I think it's going to be similar to Cary Millsap's Optimizing Oracle Performance where I am going to read it 3 or 4 times before most of the content sinks in. It's not exactly light reading. Received on Tue Nov 28 2006 - 19:44:34 CST