CPU Usage

[Mitra Bhanu Rath_1]

Hi All UNIX Gurus.When we run an Inventory Close in Oracle, only 1 of 8 CPU is 100% occupied, rest are idle. And it took long time (3 hrs) to completed. Is there any way to balance CPU usage? Or is that the application which is not having the feature which can spread across multiple CPU`s.

Thanks in advance...

Mitra

[Alex Lavrov. · Accepted solution]

How many processes of Inventory Close do you see? (ps -ef, top)

One process will run on one cpu, so if it's a single process task, then it will occupy only one cpu.

[Hein van den Heuvel]

That 'inventory close', is it a single process/job? If so, then you can really only expect one CPU being used at the most.
The system will not breakdown an parallize for you.

Now if you can split up the work say in multiple chunks (maybe for certain product ranges), then you can HOPE for more than 1 CPU, but it still is not certain based on serialization factors in teh application design.

So this is 99% sure not to be a OS question, but first and foremost application design (threading? forks?) and secondly oracle usage.
To get a base understanding of the Oracle usage, many of us like to use a 'statspack' report as a starting point.

If the 'close' spends a lot of time scanning large tables in a single query, then you may be able to use more processors by allowing Oracle to parralize/decompose teh query.

Good luck!
Hein.

[Mitra Bhanu Rath_1]

Hi,
Thanks Alex and Van for ur valuable input.
Yes you bothe were correct....There was only one process running for that Job....and got ur points that i can`t split one process into multiple CPU`s.Thanks again ten points to u both..