Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Interesting Marketing

Re: Interesting Marketing

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Mon, 12 May 2003 13:47:01 -0800
Message-ID: <F001.005972D8.20030512134701@fatcity.com>

It's been on my website for 3 or 4 years -

create table kill_cpu (n, primary key(n)) organization index
as
select rownum n
from all_objects
where rownum <= 23
;

select count(*) X
from kill_cpu
connect by n > prior n
start with n = 1
;

Under Oracle 9 you have to enable the
old connect by, but under Oracle 8
this will do 4M CR Gets and 6M
'buffer is pinned' visits.

Time it on your CPU, and compare it
with a disc doing a nominal 100 random
reads per second.

Typical (ballpark) rate is 10,000 LIO/s
per second per 100MHz of CPU.

Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

  The educated person is not the person
  who can answer the questions, but the
  person who can question the answers -- T. Schick Jr

One-day tutorials:
http://www.jlcomp.demon.co.uk/tutorial.html

____Denmark__May 21-23rd
____Sweden___June
____Finland__September
____Norway___September

Three-day seminar:
see http://www.jlcomp.demon.co.uk/seminar.html

____UK_(Manchester)_May x 2
____Estonia___June 4th - 6th
____Australia_June 18th - 20th (Perth)
____Australia_June 23rd - 25th (t.b.a)
____USA_(CA, TX)_August

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

> I don't suppose you'd care to share that two-liner with us poor
people? :)
>
>
> TIA!
> Rich
>
> Rich Jesse System/Database Administrator
> rich.jesse_at_qtiworld.com Quad/Tech International, Sussex,
WI USA
>
>
> > -----Original Message-----
> > From: Jonathan Lewis [mailto:jonathan_at_jlcomp.demon.co.uk]
> > Sent: Monday, May 12, 2003 1:27 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Re: Interesting Marketing
> >
> >
> >
> >
> > Coincidentally, I proved this point for data
> > block management in my first session at
> > IOUG-A 2003, and left the audience with a
> > two-line SQL script that they could take home
> > and run for themselves if they didn't want to
> > believe me.
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jonathan Lewis
  INET: jonathan_at_jlcomp.demon.co.uk

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Mon May 12 2003 - 16:47:01 CDT

Original text of this message

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