Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Making sense of the SQL trace file

Re: Making sense of the SQL trace file

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Thu, 13 Dec 2001 11:41:24 -0000
Message-ID: <1008243563.27029.0.nnrp-01.9e984b29@news.demon.co.uk>

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>...

>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!!'.
>
>:-)
Received on Thu Dec 13 2001 - 05:41:24 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US