cancel
Showing results for 
Search instead for 
Did you mean: 

Performance problem PRD environment

Former Member
0 Kudos

Hi Everybody,

Some moments during the day we are having a performance problem in our PRD environment. The system get slow.

The CPU get 100% of his usage.

The most used process are:

oracle.exe - 35%

disp+work - 30%

disp+work - 11%

disp+work - 05%

disp+work - 05%

In SM50 we have the programs running.

In ST03N we can see the most sequential reads and DB time problems.

If we do a performance tunning of the programs identified we can reduce the performance problem?

Anybody know another solution or where can i get more information to see where exactly the problem is?More transactions

maybe?

Best Regards,

Fábio Karnik Tchobnian

Accepted Solutions (0)

Answers (3)

Answers (3)

former_member204746
Active Contributor
0 Kudos

This is a case for SAP course ADM315.

Former Member
0 Kudos

Hi

We solved this changing Oracle parameters according note below:

SAP Note 124361 - Oracle parameterization (R/3 >= 4.x,Oracle 8.x/9.x)

Best Regards,

Fábio Karnik Tchobnian

Former Member
0 Kudos

Hi,

In SM50 we have the programs running.

At what staus they are like commit , read etc; you also need to check for active JOBs get the details.

In ST03N we can see the most sequential reads and DB time problems.

Check for poorest SQL statement from ST04 => SQL cache => remove * => check for total execution time (descending order) => check for latest 3-4 SQL statement with your'e developer to fine tune the programe

      • This is just for analysis if this is happening every time then above solution for upgrading CPU is worth than tuning

Regards;

markus_doehr2
Active Contributor
0 Kudos

> The CPU get 100% of his usage.

>

> The most used process are:

>

> oracle.exe - 35%

> disp+work - 30%

> disp+work - 11%

> disp+work - 05%

> disp+work - 05%

>

> In SM50 we have the programs running.

So I'd say your machine is not sized appropriately (too small, too few CPUs to handle the load).

Markus