After purchasing the book / reading chapter 9 'choosing a performance
optimisation method' by Randolf Geist & Charles Hooper ...the first
quick checkup refers to ' sampling performance with low overhead'

I have been unable to find the script / please could anyone advise if

1) I've missed it in an obvious location

or
2) I am missing a CD with the book which includes scripts

or

3) Something else!!

regards
Chris B

On Nov 16, 10:22*am, dba cjb <chris.br... (AT) providentinsurance (DOT) co.uk>
wrote:
Hi Chris,

Sorry to hear about the confusion regarding the scripts. The two
chapters that Randolf and I wrote were originally organized as a
single chapter 4, and were later split by the editor into chapters 9
and 10. When the book was published, chapters 9 and 10 became
chapters 8 and 9, and it appears that the Apress editors missed
changing a couple of the cross-chapter references.

The section in chapter 9 that you mentioned should actually refer to
the "Sampling Performance with Low Overhead" section in chapter 8 on
pages 203-212. The script index on page 294 indicates that the
following scripts from the script library are related to that section
of the book: LowOverheadTable.sql, LowOverheadDataCollect.sql,
LowOverheadInsPercBusy.sql, LowOverheadPercentBusy.sql,
LowOverheadProcessList.bat

You can download the script library from the Apress website (http://
www.apress.com/9781430226680 then select the Source Code/Downloads
tab). The scripts of interest will be found in the
ch08n09_UnderstandingOptMethods\ch09Scripts directory. I just tried
to download the script library, and Winzip tells me that the file is
corrupt. Let me know if you cannot download the script library - if
that is the case, I will try to post it on my blog.

Charles Hooper
http://hoopercharles.wordpress.com/
IT Manager/Oracle DBA
K&M Machine-Fabricating, Inc.

I also downloaded the zip file as you mentioned and also found that
winzip reports an error when I try to unzip it.

On Nov 17, 9:07*am, jkv... (AT) yahoo (DOT) com wrote:
Thanks for the confirmation.

I have just posted the code library for the book on my blog. Click
the picture of the book at the right side of the blog and scroll down
to the bottom to the November 17, 2011 heading. Be sure to save the
file with a .zip extension and not a .doc extension. The link will be
removed when the download problem is corrected on the Apress website.

Direct link to the article on my blog:
http://hoopercharles.wordpress.com/2...ak-table-book/

Charles Hooper
http://hoopercharles.wordpress.com/
IT Manager/Oracle DBA
K&M Machine-Fabricating, Inc.

Thank you. I was able to successfully get the copy from your blog and
unzip it

On Nov 17, 4:04*pm, Charles Hooper <hooperc2... (AT) gmail (DOT) com> wrote:
thanks Charles ...this has worked for me

Chris B

PS Now I can start using scripts I'll hopefully come back with some
more stuff for you !!