Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Performance estimation
<VBG>
"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message
news:970921811.2305.0.nnrp-09.9e984b29_at_news.demon.co.uk...
>
> Easy -
> You set every profile to bomb out after (say)
> 200,000 logical I/Os , then trap the Oracle error
> and return the response -
> 'Query too complex.'
>
> It may not be the response you want, but it
> comes back in less than 5 seconds.
>
> ;)
>
>
> --
>
> Jonathan Lewis
> Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk
>
> Niall Litchfield wrote in message <8reqhd$lhk$1_at_soap.pipex.net>...
> >
> ><kal121_at_my-deja.com> wrote in message news:8rdls3$iho$1_at_nnrp1.deja.com...
> >
> >is the way the CBO will change its mind as statistics change. Mind you it
> >looks like we are buying a product whose suppliers 'guarantee' a response
> >time under 5 seconds - even for ad-hoc & free text queries by end
users.This
> >I can't wait to see.
> >
>
>
>
Received on Sun Oct 08 2000 - 05:33:06 CDT