Re: Buffer cache statistics (ratios) and CBO SQL optimization?

As the author of the Oracle utilities book, I can assure you it's not a cut and paste from OTN. The only reason I wrote the book was to share insight that was orginal and that I couldn't find anywhere else.  For instance, the book includes how to actually use orakill in combination with something like QSlice ... or how to create your own facility and acutally make oerr useful. Trace Analyzer was explained as well as scripts provided that aid in the tracing of user sessions (all Oracle tracing tools were detailed). For some of the common utilities (imp, exp, sqlldr) I discussed performance and gave the benchmarks when using many different options on a table with 1M rows. Should you use exp/imp or the SQL*Plus copy command? It depends, but many times the copy command will do it even faster and with less hassles.

I couldn't dive straight into the "value add" part of each utility until I explained first what it did. Some people are not even aware of utilities like maxmem or oradebug. For those, I took a different approach - what does it do, how do I execute it, and what problem can it solve for me. Hope this helps.

Dave Moore Received on Wed Jan 07 2004 - 08:02:36 CST