Re: oracle SE very slow on P7
From: John Hurley <hurleyjohnb_at_yahoo.com>
Date: Wed, 1 Feb 2012 18:12:44 -0800 (PST)
Message-ID: <7e7f3b40-d0e8-486e-b61f-15daa3171982_at_p12g2000yqe.googlegroups.com>
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
Date: Wed, 1 Feb 2012 18:12:44 -0800 (PST)
Message-ID: <7e7f3b40-d0e8-486e-b61f-15daa3171982_at_p12g2000yqe.googlegroups.com>
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 ... Received on Wed Feb 01 2012 - 20:12:44 CST