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: Performance estimation

Re: Performance estimation

From: Niall Litchfield <niall.litchfield_at_dial.pipex.com>
Date: Sun, 8 Oct 2000 11:33:06 +0100
Message-ID: <8rpi8h$g8q$1@lure.pipex.net>

<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

Original text of this message

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