Re: Sun T2000

From: Alexander Fatkulin <afatkulin_at_gmail.com>
Date: Tue, 27 Mar 2007 13:09:48 +1100
Message-ID: <49d668000703261909y197ace62pe0088b3a7f0dbb09@mail.gmail.com>

> Looks like the cache subsystem of the T2000 is pretty good so the
> local (in relation to a cache) algorithms can benefit.

Thanks to Kevin Closson - my theory about what it's the Niagara cache that helps it out was wrong.

declare

        l_x dual.dummy%type;
begin

	for i in 1 .. 500000
	loop
		select dummy into l_x from dual;
	end loop;

end;

call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ----------

Parse        1      0.01       0.00          0          0          0           0
Execute      1    133.29     134.92          0          0          0           1
Fetch        0      0.00       0.00          0          0          0           0
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total        2    133.30     134.92          0          0          0           1

Pretty much the same numbers as from my "lookup-table" tests.

-- 
Alexander Fatkulin
--
http://www.freelists.org/webpage/oracle-l

Received on Mon Mar 26 2007 - 21:09:48 CDT