Re: oracle SE very slow on P7
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Thu, 2 Feb 2012 02:57:39 +0000 (UTC)
Message-ID: <pan.2012.02.02.02.57.37_at_gmail.com>
On Wed, 01 Feb 2012 18:12:44 -0800, John Hurley wrote:
>> hello
>>
>> We move our JDE production DB, oracle 10GR2 EE, from IBM P570 with P6
>> processor (4.2Ghz) on P740 with P7 processor (3.3Ghz). The first test
>> we ran was an import mono process, on P740 it take two time than on
>> P570, the import spent a lot of time in index build ans statistics
>> computation.
>> It seems that the multi-threading of P7 is not used when Oracle is used
>> in mono-thread, and the performance of one thread on P7 is by far less
>> good than P6.
>> If someone get some experience on Oracle on P7, could you share..
>>
>> Thank you
Date: Thu, 2 Feb 2012 02:57:39 +0000 (UTC)
Message-ID: <pan.2012.02.02.02.57.37_at_gmail.com>
On Wed, 01 Feb 2012 18:12:44 -0800, John Hurley wrote:
> On Jan 29, 6:20 am, nonor73 <tempo.ve..._at_gmail.com> wrote:
>> hello
>>
>> We move our JDE production DB, oracle 10GR2 EE, from IBM P570 with P6
>> processor (4.2Ghz) on P740 with P7 processor (3.3Ghz). The first test
>> we ran was an import mono process, on P740 it take two time than on
>> P570, the import spent a lot of time in index build ans statistics
>> computation.
>> It seems that the multi-threading of P7 is not used when Oracle is used
>> in mono-thread, and the performance of one thread on P7 is by far less
>> good than P6.
>> If someone get some experience on Oracle on P7, could you share..
>>
>> Thank you
> > Oracle standard edition does not do many things in parallel ... versus > enterprise edition. > > Make sure you are comparing oranges to oranges ...
John, the original poster specified "oracle 10GR2 EE". I don't thing that SE is the problem here.
-- http://mgogala.byethost5.comReceived on Wed Feb 01 2012 - 20:57:39 CST