Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Making sense of the SQL trace file
It wasn't quite that obscure - I had done a pl/sql loop with a single row fetch, and every single one took 291 microseconds. So then I checked a few of the larger numbers.
-- 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. Howard J. Rogers wrote in message <3c13c11d$0$3740$afc38c87_at_news.optusnet.com.au>...Received on Thu Dec 13 2001 - 05:41:24 CST
>I just want to know what sort of inspiration struck to make you realise
that
>they were all multiples of 291!!
>
>I mean, I know if I ever saw a time reading 24735, the last thing I'd say
to
>myself is, 'Hello! That looks like a multiple of 291 to me!!'.
>
>:-)