| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> SQL Challenge - how to flog the CPU
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 Sun Jul 11 1999 - 04:36:59 CDT
 |
 |