Re: Making sense of the SQL trace file

Jonathan Lewis doodled thusly:

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

Was that on HP?

IIRC, most Unix boxes have some default timers of low resolution. Wouldn't surprise me if 9i used the default?

Cheers
Nuno Souto
nsouto_at_optushome.com.au.nospam Received on Thu Dec 13 2001 - 06:11:38 CST