Re: Making sense of the SQL trace file

Thanks,
I did wonder if I had gone a bit over the top with all the stuff on gets, pins, and latches.

If you are interested, I have posted a 'white paper' with a more thorough treatment of the 'FAN Hit Ratio' as a 110K pdf file at:

    www.miracleas.dk/undskyld/fhr.pdf

--
Jonathan Lewis
http://www.jlcomp.demon.co.uk

Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Author of:
Practical Oracle 8i: Building Efficient Databases

Screen saver or Life saver: http://www.ud.com
Use spare CPU to assist in cancer research.

Paul Brewer wrote in message
<3c19968f_2_at_mk-nntp-1.news.uk.worldonline.com>...


>You do indeed enjoy extreme tests :-0

>

>Attended and very much enjoyed your presentation in Birmingham yesterday.

>Keep up the good work.

>

>Paul