Re: Finally! The RAID F Simulator is here ( and attachedd )

I don't think you should be playing with this and having fun when you could use the valuable Christmas period for rebuilding all your indexes. <NB Joke>

But since it's Oracle 9.2 that gets mentioned how about trying the new bit functions:

select sys_op_rawtonum(
  sys_op_vecxor(
   sys_op_numtoraw(6),
   sys_op_numtoraw(5)
  )
 )
from dual
/

I won't guarantee that they're faster, and they certainly look messier than the pl/sql function calls, but I think they are SQL built-ins, and therefore may be faster running than pl/sql function calls.

sys_op_vecor and sys_op_vecand are also
available.

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

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

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

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Monday, December 22, 2003 11:34 AM

LOL! Just to add my 2c worth....I think you can get a simpler XOR implementation with:

CREATE OR replace FUNCTION bitor( x IN NUMBER, y IN NUMBER ) RETURN NUMBER AS
BEGIN
    RETURN x + y - bitand(x,y);
END;
/

CREATE OR replace FUNCTION bitxor( x IN NUMBER, y IN NUMBER ) RETURN NUMBER AS
BEGIN
    RETURN bitor(x,y) - bitand(x,y);
END;
/

Cheers
Connor

• Jared Still <jkstill_at_cybcon.com> wrote: > Dear All,
  >
  > Jesper from the Copenhagen Business School got this
  > crazy idea some
  > weeks ago, and with input from Michael Möller of
  > Miracle A/S, it's my
  > proud honor to present the World's first
  > Oracle-based RAID-F Simulator.
  >
  > It's all fun and games, of course, and Jesper got
  > inspired after reading
  > James Morle's book. He simply copied the 20 pages or
  > so about RAID and
  > handed it to his boss and said that this was the
  > knowledge he needed to
  > understand the way Jesper was thinking about RAID!
  > The boss did read it,
  > and did understand it, and then Jesper went ahead
  > with the RFS project
  > just for fun.
  >
  > With the kind permission of Jared, I have attached
  > it. So this is your
  > Christmas gift from Jesper :-).
  >
  > Best regards,
  >
  > Mogens
  >
  

-- 
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).