Quick Benchmark Request

I am interested in how the following PL/SQL performs on unloaded RISC, mainframe, Pentium, DX4, nCUBE node etc. machines running Oracle V7.

declare
a number;
begin
  for x in 1..10000000 loop
  a:= a+1;
  end loop;
  end;
/

Clearly, this quick test does not test I/O capability. Please note if you call this from a stored procedure and it dramatically changes the result.

If your machine should happen to perform this test under a second or feel client-server startup is skewing the result feel free to add another couple of zeros to the loop.

Machine -:
Loop ----: 10,000,000
Time(sec):
Notes ---:

Thanks,

Carl

cservice_at_orange.digex.net Received on Sun Aug 14 1994 - 23:11:51 CEST