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

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.

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.

Charles Hooper
PC Support Specialist
K&M Machine-Fabricating, Inc. Received on Tue Nov 28 2006 - 16:15:32 CST