Re: Oracle function myth on Solaris machinie

Sybrand Bakker <gooiditweg_at_sybrandb.nospam.demon.nl> wrote in message news:<00psrvgs8c8vilkp2tilu5u5joqoo25fkr_at_4ax.com>...
> On 21 Nov 2003 07:44:49 -0800, guo_at_andrews.edu (Limin Guo) wrote:
>
> > WHY sql_trace or 10046 has impact on the insert, I
> >don't understand.
>
> Are you familiar with the buffer cache? If so, won't you think a
> likely explanation is in your so-called 'fast-mode' everything is in
> the buffer cache and in your so-called 'slow-mode' Oracle has to fetch
> everything again?
> So why are you making up myths?

So why was it slow on the third try?

Maybe he needs to go to 8.1.7.4 to fix one of the performance bugs?

jg

--
@home.com is bogus.
http://catless.ncl.ac.uk/Risks/23.01.html#subj12