Re: SQL Challenge - how to flog the CPU

From: Doug Cowles <dcowles_at_bigfoot.com>
Date: Wed, 14 Jul 1999 18:49:24 -0400
Message-ID: <378D13F4.5E863DA1@bigfoot.com>

Did you post this yet?

Jonathan Lewis wrote:

> For those of you who feel that there
> db block buffer hit ratio is too small -
>
> How can you create a table with 33 rows
> and a very short SQL statement to use
> that table that will lock up 100% of the CPU
> for around 48 hours and generate 4 billion
> logical I/Os ?
>
> I'll post a solution on my web site (under MYTHS)
> some time late Tuesday.
>
> --
>
> Jonathan Lewis
> Yet another Oracle-related web site: www.jlcomp.demon.co.uk
Received on Wed Jul 14 1999 - 17:49:24 CDT