Oracle DB 12.1 on SPARC m8 is very slower then on Intel x86
We are compare time execution very simple query on SPARC m8 and Intel Gold 6144. And see slow down SPARC.
declare
a number;
b number;
begin
a := 1;
n := 1000000;
for a..n loop
select 1 into b from dual;
end loop;
end;
On SPARC execution time 2-3 time longer tnen on Intel. this is simple test script. But we see same picture for any others queryes.
Have any idea for speed up SPARC?
Tagged:
0