Skip to Content
author's profile photo Former Member
Former Member

Increase CPU usage during Upgrade

Hello All,

We are running upgrade from 4.7 to ECC 6. We have a very good hardware configuration with 8 Core (each core 8 threads and thus virtually 64 CPU). But still the CPU usage is between 2% to 5%. Is there any Parameters which could increase the CPU usage?

We are running in Solaris 10 and Oracle 10g

Kindly help

Regards,

Anand

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Posted on Dec 10, 2009 at 06:35 PM

    Hi,

    How many parallel processes did you specified during Prepare and at the begining of the Downtime?

    If you left it in 3 (Default) then this will be normal, also it depends on the phase your upgrade is running at the time you meassure the CPU consumption because much of the phases runs on Phisical disks and CPU won´t do much during those phases.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 11, 2009 at 05:41 AM

    Hi,

    It depends upon which strategy you have chosen in configuration mode for your upgrade. If you have chosen standard Resource Use then it is normal.

    If you have sufficient resources then you can use High resource use strategy.

    But better is use Manual Selection of parameters where you can define different processes like number of R3trans processes depends upon the how much resources you have like RAM and CPU etc.

    Thanks

    Sunny

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 11, 2009 at 11:55 AM

    > We are running upgrade from 4.7 to ECC 6. We have a very good hardware configuration with 8 Core (each core 8 threads and thus virtually 64 CPU). But still the CPU usage is between 2% to 5%. Is there any Parameters which could increase the CPU usage?

    What machine is that? If it's a T-Server series then that behaviour is expected.

    See the thread

    high CPU response times, altough low CPU utilization

    Markus

    Add a comment
    10|10000 characters needed characters exceeded

    • >

      > Yes we have split the 30 largest table and they were spilt successfully. But later the export is getting slow down and for the last six tables its taking nearly 6hours. The tables are as follows:

      >

      > CDCLS

      > FMIFIIT

      > COSB

      > BSAS

      > MLKEPH

      > COSD

      What I was referring to is not splitting them into separate packages but splitting up the export itself using R3ta, did you do that?

      > I future run we have decided to include these tables also in table splitting. But these tables are not in the list of first 50 tables and still they take more time. We are wondering how this is happening.

      Which 50 tables? biggest?

      > Also for server performance we are checking with hardware vendor for options if any. Please suggest us

      I'd change the hardware to a non-Cool Threads server (so no T-series).

      Markus

  • author's profile photo Former Member
    Former Member
    Posted on Feb 01, 2010 at 01:38 PM

    Thanks all for the response

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.