Re: Sun T2000

  • From: "Alexander Fatkulin" <afatkulin@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Tue, 27 Mar 2007 13:09:48 +1100

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
--
//www.freelists.org/webpage/oracle-l


Other related posts: