Re: SQL Challenge - how to flog the CPU

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Sun, 11 Jul 1999 21:14:00 +0800
Message-ID: <37889898.1204@yahoo.com>

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

The answer to that is any one of the queries written by the Forms developers on the system I am currently looking after...

:-)

--

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Sun Jul 11 1999 - 08:14:00 CDT