Re: Performance estimation

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Sat, 7 Oct 2000 13:21:31 +0100
Message-ID: <970921811.2305.0.nnrp-09.9e984b29@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 Sat Oct 07 2000 - 07:21:31 CDT